К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Microsoft Power BI - The Complete Masterclass - 2026 EDITION · LearnSpace
Назад в каталог
courseraАнализ данных

Microsoft Power BI - The Complete Masterclass - 2026 EDITION

Курс от Packt
Средний≈ 22.5 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Updated in May 2025. This course now features Coursera Coach! A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. In this comprehensive Microsoft Power BI Masterclass, you'll embark on a transformative learning journey designed to make you proficient in Power BI's full range of features. By the end of the course, you’ll have mastered everything from data transformation and visualization to creating complex data models and applying advanced analytics techniques. The course begins by familiarizing you with Power BI's interface and essential functionalities. You'll start with downloading and installing Power BI, learning how to create data models, and handling data transformation through the Query Editor. Mini-projects will help you gain hands-on experience, ensuring you understand both data transformation and visualization. As you progress, you’ll dive deeper into advanced data transformation techniques, including working with different data sources such as CSV files, web pages, and SQL databases. You will learn to manage complex data structures and perform powerful operations like pivoting, merging, and using M formulas for optimization. This course is ideal for data professionals, analysts, and business intelligence enthusiasts who want to harness Power BI for their data-driven decision-making. There are no specific prerequisites, though familiarity with basic data analysis concepts can be beneficial. The course is structured for intermediate learners, but beginners will also find valuable content to help them grow.

Навыки, которые вы освоите

Power BIData Visualization SoftwareData Analysis Expressions (DAX)Data ManipulationInteractive Data VisualizationRole-Based Access Control (RBAC)DashboardData IntegrationPivot Tables And ChartsRelational DatabasesSecurity ControlsData VisualizationData Import/Export

Программа курса

14 модулей · 163 учебных материалов

01Introduction10 материалов

Introduction

What is Power BI?ВидеоFull Course ResourcesЧтениеDownload and Install Power BI DesktopВидеоQuick Interface TourВидео

Учитесь у экспертов

Packt - Course Instructors

Преподаватель курса

Microsoft Power BI - The Complete Masterclass - 2026 EDITION
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 22.5 ч

14 модулей

Язык: Английский

Субтитры: Венгерский, Казахский

Часть программы вашего университета
Creating Visualizations - Quick IntroВидео
Mini Project: Transform DataВидео
Mini Project: Visualize DataВидео
Mini Project: Creating a Data ModelВидео
Course Outline: What Will You Learn in This Course?Видео
Introduction - AssessmentЗадание
02Preparing Our Project4 материалов

Preparing Our Project

Creating Our Initial Project FileВидеоWorking with the Attached Project FilesВидеоSetting Up Power BI OptionsDIALOGUEPreparing Our Project - AssessmentЗадание
03Data Transformation - The Query Editor26 материалов

Data Transformation - The Query Editor

First Data ConnectionВидеоExploring the Query EditorВидеоConnecting to Our Data SourceВидеоEditing RowsВидеоChanging Data TypesВидеоReplacing ValuesВидеоClose and ApplyВидеоConnecting to a CSV FileВидеоConnecting to a WebpageВидеоExtracting CharactersВидеоSplitting and Merging ColumnsВидеоCreating Conditional ColumnsВидеоCreating Columns from ExamplesВидеоMerging QueriesВидеоPivoting and UnpivotingВидеоAppending QueriesВидеоPractice and Solution: Population TableВидеоThe Fact-Dimension-ModelВидеоPractice: Load the Dimension TableВидеоOrganizing Our Queries in GroupsВидеоEntering Data ManuallyВидеоCreating an Index ColumnВидеоWorkflow and More TransformationsВидеоModule SummaryВидеоConnecting and Importing Data Sources in Power BIDIALOGUEData Transformation - The Query Editor - AssessmentЗадание
04Data Transformation - Advanced13 материалов

Data Transformation - Advanced

Advanced Editor - Best PracticesВидеоPerformance: References Versus DuplicatingВидеоPerformance: Enable / Disable Load and Report RefreshВидеоGroup ByВидеоMathematical OperationsВидеоRun R ScriptВидеоUsing Parameters to Dynamically Transform DataВидеоM Formula Language: BasicsВидеоM Formula Language: Values, Lists, and TablesВидеоM Formula Language: FunctionsВидеоM Formula Language: More Functions and StepsВидеоMastering Power Query's Advanced EditorDIALOGUEData Transformation - Advanced - AssessmentЗадание
05Creating a Data Model10 материалов

Creating a Data Model

Why a Data Model?ВидеоCreate and Edit RelationshipsВидеоOne-One RelationshipsВидеоOne-to-many relationshipВидеоMany-to-many (m:n) relationshipВидеоCross filter directionВидеоActivate & deactivate relationshipsВидеоModule summaryВидеоUnderstanding Data Models in Power BIDIALOGUECreating a Data Model - AssessmentЗадание
06Data Visualization25 материалов

Data Visualization

Our First VisualВидеоAdding values to visualВидеоThe Format TabВидеоUnderstanding tablesВидеоConditional FormattingВидеоThe Pie ChartВидеоAll about the Filter VisualВидеоThe Filter Pane for DevelopersВидеоCross Filtering and Edit InteractionsВидеоSyncing Slicers across PagesВидеоCreating DrilldownsВидеоCreating Drill-ThroughsВидеоThe Treemap VisualВидеоThe Decomposition TreeВидеоUnderstanding the Matrix VisualВидеоEditing PagesВидеоButtons and ActionsВидеоBookmarks to Customize Your ReportВидеоAnalytics and Forecasts with Line ChartsВидеоWorking with Custom VisualsВидеоGet Data Using R Script and R Script VisualВидеоAsking Questions - Q&A VisualВидеоWrap Up - Data VisualizationВидеоCreating Interactive Reports in Power BIDIALOGUEData Visualization - AssessmentЗадание
07Power BI and Python9 материалов

Power BI and Python

Python in Power BI - Plan of AttackВидеоSetting Up Python for Power BIВидеоTransforming Data Using PythonВидеоCreating Visualizations Using PythonВидеоViolin Plots, Pair Plots and Ridge Plots Using PythonВидеоMachine Learning (BayesTextAnalyzer) Using PythonВидеоPerformance and TroubleshootingВидеоIntegrating Python with Power BIDIALOGUEPower BI and Python - AssessmentЗадание
08DAX - The Essentials12 материалов

DAX - The Essentials

IntroductionВидеоThe Project DataВидеоMeasures Versus Calculated ColumnsВидеоAutomatically Creating a Date Table in DAXВидеоCalendarВидеоCreating a Complete Date Table with FeaturesВидеоCreating a Key Measure TableВидеоAggregation FunctionsВидеоThe Different Versions of COUNTВидеоSUMX – Row-Based CalculationsВидеоExploring Power BI DAX SUMX FunctionDIALOGUEDAX - The Essentials - AssessmentЗадание
09DAX - The CALCULATE Function7 материалов

DAX - The CALCULATE Function

CALCULATE - The BasicsВидеоChanging the Context with FILTERВидеоALLВидеоALLSELECTВидеоALLEXCEPTВидеоExploring Power BI's CALCULATE FunctionDIALOGUEDAX - The CALCULATE Function - AssessmentЗадание
10Tell a Story with Your Data - Learn to Visualize Effectively10 материалов

Tell a Story with Your Data - Learn to Visualize Effectively

Introduction - Best PracticesВидеоShow Empathy and Identify the RequirementsВидеоFind the Most Suitable KPIsВидеоChoose an Effective VisualВидеоMake Use of Natural Reading PatternВидеоTell a Story Using Visual CuesВидеоAvoid Chaos and Group InformationВидеоWrap Up - Storytelling with DataВидеоDesigning Effective Data ReportsDIALOGUETell a Story with Your Data - Learn to Visualize Effectively - AssessmentЗадание
11Power BI Service - Power BI Cloud19 материалов

Power BI Service - Power BI Cloud

How to Go On Now?ВидеоPower BI licenses & Microsoft FabricВидеоWhat is Microsoft Fabric?ВидеоPower BI & Fabric Signing UpВидеоEnable Free Trial for Fabric CapacityВидеоCreating a workspace in FabricВидеоPublish a report to the CloudВидеоWorking in Power BI service and editing reportsВидеоCreating new reports in Power BI serviceВидеоUnderstanding Semantic Models and Updating ReportsВидеоManaging Workspaces and Access ControlВидеоCreating Dashboards as Business UsersВидеоCreating and Using Apps: How to Distribute Content to UsersВидеоUpdating an App: Implementing Changes to the AppВидеоCreating the Layout for the Mobile AppВидеоWrap Up - Power BI CloudВидеоScheduling Refresh of DataВидеоPublishing and Collaborating with Power BI ServiceDIALOGUEPower BI Service - Power BI Cloud - AssessmentЗадание
12Row-Level Security9 материалов

Row-Level Security

IntroductionВидеоCreating a Row-Level SecurityВидеоRow-Level Security in the CloudВидеоRow-Level Security and Data ModelВидеоDynamic Row-Level SecurityВидеоDynamic Many-to-Many RLSВидеоHierarchical Row-Level SecurityВидеоImplementing Row Level Security in Power BIDIALOGUERow-Level Security - AssessmentЗадание
13More Data Sources6 материалов

More Data Sources

JSON and REST APIВидеоSetting Up a Local MySQL DatabaseВидеоConnecting to a MySQL Database in Power BIВидеоConnecting to a SQL Database (PostgreSQL)ВидеоConnecting Power BI to REST APIsDIALOGUEMore Data Sources - AssessmentЗадание
14Next Steps to Improve and Stay Up-to-Date3 материалов

Next Steps to Improve and Stay Up-to-Date

Congratulations and Next StepsВидеоFull Course Practice AssessmentЗаданиеFull Course AssessmentЗадание