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

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

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

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Data Preparation and Visualization with Power BI · LearnSpace
Назад в каталог
courseraIT и технологии

Data Preparation and Visualization with Power BI

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

О курсе

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. Master the art of transforming raw data into actionable insights with Power BI. This course equips you with the skills to leverage Power Query and Power Pivot for efficient data preparation, build robust data models, and write powerful DAX formulas for advanced analytics. You'll also learn to create interactive dashboards, reports, and visualizations that effectively communicate your insights. Beginning with the fundamentals of Power Query and Power Pivot, you’ll explore essential techniques such as data transformation, unpivoting columns, merging queries, and creating dynamic models. The course also delves deep into DAX expressions, teaching you how to compute metrics, manage relationships, and perform advanced calculations like year-over-year comparisons and percentages. As you advance, you’ll use Power BI to design impactful dashboards and reports. You'll gain hands-on experience with mapping visuals, KPIs, and conditional formatting. Practical exercises throughout the course ensure you can apply your knowledge, from creating pivot tables to crafting professional-grade reports and publishing them using the Power BI service. This course is ideal for aspiring analysts, business professionals, and data enthusiasts. Basic familiarity with Excel is recommended. Whether you’re a beginner or have intermediate experience, you’ll acquire the essential skills needed to thrive in data-driven roles.

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

Power BIData TransformationInteractive Data VisualizationData ModelingData Analysis Expressions (DAX)Pivot Tables And ChartsData ManipulationData Visualization SoftwareDashboard CreationData WranglingData SharingData PresentationPerformance ReportingReport WritingBusiness IntelligenceData IntegrationDashboardMicrosoft ExcelData Visualization

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

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

01Introduction to Power Pivot and Power Query7 материалов

Introduction to Power Pivot and Power Query

Introduction to the Course 'Data Preparation and Visualization with Power BI'ЧтениеFull Specialization ResourcesЧтениеWelcome and OverviewВидеоWhat is Power Query?Видео

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

Packt - Course Instructors

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

Data Preparation and Visualization with Power BI
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 17.1 ч

17 модулей

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

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Испанский, Японский, Казахский

Часть программы вашего университета
What is Power Pivot?Видео
Understanding Power Query TransformationsDIALOGUE
Introduction to Power Pivot and Power Query - AssessmentЗадание
02Getting Started with Power Query9 материалов

Getting Started with Power Query

Exploring the Power Query EditorВидеоCommon Power Query TransformationsВидеоEditing an Existing QueryВидеоImporting Multiple Files from a FolderВидеоConnecting to Data in Another Excel WorkbookВидеоImportant: Checking the Location of Your Query's SourceВидеоRetrieving Data from the WebВидеоPractice ExerciseВидеоGetting Started with Power Query - AssessmentЗадание
03Useful Power Query Features10 материалов

Useful Power Query Features

Unpivoting ColumnsВидеоCombining Data from Multiple Tables with Merge QueriesВидеоUsing Merge Queries to Compare Two TablesВидеоStacking Data into One Table with Append QueriesВидеоDuplicating and Referencing QueriesВидеоGrouping and Aggregating DataВидеоAdding Conditional Columns in Power QueryВидеоPractice ExerciseВидеоUsing Unpivot Columns in Power QueryDIALOGUEUseful Power Query Features - AssessmentЗадание
04Creating a Data Model9 материалов

Creating a Data Model

Enabling the Power Pivot Add-inВидеоUnderstanding the Power Pivot WindowВидеоCreating Relationships Between TablesВидеоManaging Relationships of the ModelВидеоCreating a Pivot Table from the Data ModelВидеоHiding Fields from the Client ToolsВидеоGrouping QueriesВидеоPractice ExerciseВидеоCreating a Data Model - AssessmentЗадание
05Introduction to Data Analysis Expressions (DAX)8 материалов

Introduction to Data Analysis Expressions (DAX)

Why Use Data Analysis Expressions (DAX)ВидеоCreating Calculated Columns with Data Analysis Expressions (DAX)ВидеоCreating the First Data Analysis Expressions (DAX) MeasureВидеоUsing the COUNTROWS FunctionВидеоUsing the SUMX and RELATED FunctionsВидеоPractice ExerciseВидеоIntroduction to DAX Calculated Columns and MeasuresDIALOGUEIntroduction to Data Analysis Expressions (DAX) - AssessmentЗадание
06More Data Analysis Expressions (DAX) Measures8 материалов

More Data Analysis Expressions (DAX) Measures

Creating a Date Table in Power PivotВидеоUsing the CALCULATE FunctionВидеоUsing the DIVIDE FunctionВидеоUsing the DATESYTD FunctionВидеоCalculating the Percentage of a TotalВидеоPractice ExerciseВидеоCreating a Date Table using Power PivotDIALOGUEMore Data Analysis Expressions (DAX) Measures - AssessmentЗадание
07Using Pivot Tables and Slicers6 материалов

Using Pivot Tables and Slicers

Creating Pivot Tables and Pivot ChartsВидеоUsing Slicers with Pivot TablesВидеоCreating a Top 10 Pivot TableВидеоPractice ExerciseВидеоCreating Interactive Reports with Excel PivotTablesDIALOGUEUsing Pivot Tables and Slicers - AssessmentЗадание
08Power Pivot, Power Query, and Data Analysis Expressions (DAX): Summary2 материалов

Power Pivot, Power Query, and Data Analysis Expressions (DAX): Summary

SummaryВидеоExploring Excel's Power Pivot and DAXDIALOGUE
09Introduction to Power BI7 материалов

Introduction to Power BI

Welcome and OverviewВидеоWhat Is Power BI?ВидеоInstalling Power BI DesktopВидеоTour of Power BI DesktopВидеоExploring the Commonly Used Power BI OptionsВидеоNavigating Power BI Desktop InterfaceDIALOGUEIntroduction to Power BI - AssessmentЗадание
10Power BI: Getting and Transforming Data9 материалов

Power BI: Getting and Transforming Data

Importing Files from a Folder into Power BI DesktopВидеоGetting Data from Excel and Text FilesВидеоChanging Query SourceВидеоReference Queries to Create Additional Lookup TablesВидеоMerge Queries in Power QueryВидеоPrevent Queries from Loading into Power BI DesktopВидеоPractice ExerciseВидеоImporting Multiple CSV Files in Power BIDIALOGUEPower BI: Getting and Transforming Data - AssessmentЗадание
11Power BI: Data Modelling9 материалов

Power BI: Data Modelling

Creating a Relationship Between TablesВидеоCreating a Dynamic List of DatesВидеоCreating Additional Date Columns for AnalysisВидеоSorting the Month and Weekday Names CorrectlyВидеоMarking the Table as a Date TableВидеоHiding Unnecessary Fields from the Report ViewВидеоPractice ExerciseВидеоModeling Relationships in Power BIDIALOGUEPower BI: Data Modelling - Assessment Задание
12Introduction to Data Analysis Expressions (DAX) Measures8 материалов

Introduction to Data Analysis Expressions (DAX) Measures

Calculating Total RevenueВидеоCounting the Total Rows of a TableВидеоUsing the CALCULATE DAX FunctionВидеоCalculating the Total Revenue for Last YearВидеоDifference Compared to Last YearВидеоPractice ExerciseВидеоCreating DAX Measures for Aggregation and AnalysisDIALOGUEIntroduction to Data Analysis Expressions (DAX) Measures - AssessmentЗадание
13Power BI: Adding Visualizations to Your Report11 материалов

Power BI: Adding Visualizations to Your Report

Showing Summary Information with CardsВидеоComparing Values with Columns ChartsВидеоMapping Visual to Plot Geographic DataВидеоFiltering Reports with SlicersВидеоKey Performance Indicator (KPI) Card to Measure Performance against a GoalВидеоLine Graphs to Visualize a TrendВидеоShowing Details with the MatrixВидеоTop N Lists with Table VisualizationВидеоPractice ExerciseВидеоCreating Visualizations in Power BIDIALOGUEPower BI: Adding Visualizations to Your Report - AssessmentЗадание
14Power BI: Report Design6 материалов

Power BI: Report Design

Adding Text Boxes and ShapesВидеоUsing ThemesВидеоConditional FormattingВидеоPractice ExerciseВидеоDesigning User-Friendly Report BannersDIALOGUEPower BI: Report Design - Assessment Задание
15Power BI: Editing Interactions and Filters6 материалов

Power BI: Editing Interactions and Filters

Editing Interactions between VisualizationsВидеоFilter Pane to Filter at any LevelВидеоDrilling through to More DetailВидеоPractice ExerciseВидеоEditing Visual Interactions in Power BIDIALOGUEPower BI: Editing Interactions and Filters - AssessmentЗадание
16Power BI Service5 материалов

Power BI Service

Publishing a Report to the Power BI ServiceВидеоDifferent Ways to Share a Power BI ReportВидеоPractice ExerciseВидеоPublishing and Sharing Reports in Power BIDIALOGUEPower BI Service - AssessmentЗадание
17Power BI: Summary5 материалов

Power BI: Summary

SummaryВидеоCreating Interactive Power BI DashboardsDIALOGUEConclusion to the course 'Data Preparation and Visualization with Power BI'ЧтениеFull Course Practice AssessmentЗаданиеFull Course AssessmentЗадание