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

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

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

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

Data Modeling in Power BI

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

О курсе

This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. In this course, you'll learn how to use Power BI to create and maintain relationships in a data model and form a model using multiple Schemas. You'll explore the basics of DAX, Power BI's expression language, and add calculations to your model to create elements and analysis in Power BI. You'll discover how to configure the model to support Power BI features for insightful visualizations, analysis, and optimization. After completing this course you'll be able to: ● Create and maintain relationships in a data model. ● Form a model using a Star Schema ● Write calculations DAX to create elements and analysis in Power BI ● Create calculated columns and measures in a model ● Perform useful time intelligence calculations in DAX ● Optimize performance in a Power BI model This is also a great way to prepare for the Microsoft PL-300 exam. By passing the PL-300 exam, you’ll earn the Microsoft Power BI Data Analyst certification.

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

Data Analysis Expressions (DAX)Data ModelingPower BIStar SchemaModel OptimizationPerformance TuningSnowflake SchemaTime Series Analysis and ForecastingData AnalysisDatabase DesignData VisualizationBusiness Intelligence

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

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

01Concepts for data modeling40 материалов

Welcome to the course

Course introductionВидеоCourse syllabusЧтениеHow to be successful in this courseЧтениеSetting up your Power BI environmentЧтение

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

Microsoft

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

Data Modeling in Power BI
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 25.3 ч

4 модулей

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

Субтитры: Арабский, Французский, Бенгальский, Узбекский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Вьетнамский, Нидерландский, Корейский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Дари, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
New name for Power BI datasetsЧтение
Additional resources: Concepts for data modelingЧтение

Introduction to data models

Introduction to data modelsВидеоModel view in Power BIЧтениеIntroduction to schemasВидеоSchemas cheatsheetЧтениеSetting up a Flat schema in Power BIВидеоTable and column properties cheatsheetЧтениеExercise: Configuring a Flat schemaЧтениеExemplar: Configuring a Flat schemaЧтениеActivity: Configure a Flat schema with multiple sourcesЧтениеKnowledge check: Introduction to data modelsЗаданиеAdditional resources: Introduction to data modelsЧтениеUnderstanding Data Models and SchemasDIALOGUE

Introduction to cardinality and cross-filter direction

Understanding fact and dimension tablesВидеоNormalization and denormalizationЧтениеIntroduction to cardinalityВидеоManaging model relationshipsЧтениеModel relationships cheatsheetЧтениеIntroduction to cross-filter directionВидеоDefining data granularityВидеоKnowledge check: Introduction to cardinality and cross-filter directionЗаданиеAdditional resources: Introduction to cardinality and cross-filter directionЧтение

Working with advanced data models

Setting up a Star schema in Power BIВидеоExercise: Configuring a Star schemaЧтениеExemplar: Configuring a Star schemaЧтениеSetting up a Snowflake schemaВидеоActivity: Changing your Star schema into a Snowflake schemaЧтениеWhy it is important to use Snowflake schemaВидеоData View in Power BIЧтениеResolving challenges in data modelsВидеоKnowledge check: Working with advanced data modelsЗаданиеModule summary: Concepts for data modelingВидеоModule quiz: Concepts for data modelingЗаданиеWhy is data modeling important in the data analysis process?ОбсуждениеAdditional resources: Working with advanced data modelsЧтение
02Using Data Analysis Expressions (DAX) in Power BI55 материалов

Introduction to DAX

Introduction to Data Analysis Expressions (DAX)ВидеоFormulas and functions in DAXВидеоRow context and filter contextВидеоDAX cheatsheetЧтениеIntroduction to calculated tablesВидеоCloning and calculating tablesЧтениеDAX table functionsЧтениеCreating calculated columnsВидеоExercise: Adding a calculated table and columnЧтениеSelf-review: Adding a calculated table and columnЗаданиеExemplar: Adding a calculated table and columnЧтениеKnowledge check: Using Data Analysis Expressions (DAX) in Power BIЗаданиеAdditional resources: Introduction to DAXЧтение

Introduction to measures

Introduction to measuresВидеоTypes of measuresВидеоBasic statistical functionsВидеоStatistical functions cheatsheetЧтениеDAX measures and context in businessВидеоKnowledge check: Introduction to measuresЗадание

Working with measures

Creating quick measuresВидеоCreating custom measures with DAXВидеоExercise: Adding a measureЧтениеSelf-review: Adding a measureЗаданиеExemplar: Adding a measureЧтениеIntroduction to the CROSSFILTER functionВидео

DAX and table relationships

Introduction to role-playing dimensionsВидеоIntroduction to the USERELATIONSHIP functionВидеоConfiguring role-playing dimensionsВидеоExercise: Adding a role-playing dimensionЧтениеSelf-review: Adding a role-playing dimensionЗаданиеExemplar: Adding a role-playing dimensionЧтение

Time intelligence calculations in DAX

The importance of time intelligenceВидеоUsing DAX for summarization over timeВидеоUsing DAX for comparison over timeВидеоAdditional time intelligence functionsЧтениеExercise: Using time intelligence to compare to previous yearЧтениеSelf-review: Using time intelligence to compare to previous yearЗадание
03Optimize a model for performance in Power BI29 материалов

Optimize performance in a Power BI model

What is optimization and why is it necessary?ВидеоOptimization by exampleВидеоIdentifying and reducing cardinality levelsВидеоResolving performance issues in the data modelВидеоExercise: Improving data model performanceЧтениеSelf-Review: Improving data model performanceЗаданиеExemplar: Improving data model performanceЧтениеOptimizing columns and metadataЧтениеOptimizing the Auto date/time featureЧтениеActivity: Optimizing the columns and Auto date/timeЧтениеKnowledge check: Optimize a model for performance in Power BIЗаданиеAdditional resources: Optimize performance in a Power BI modelЧтение

Optimize DirectQuery models

Behavior and limitations of DirectQuery connectionsВидеоOptimizing DirectQuery performance with query reductionsВидеоOptimizing DirectQuery performance with table storageВидеоWalk-through: Optimizing a DirectQuery modelЧтениеKnowledge check: Optimize DirectQuery modelsЗаданиеAdditional resources: Optimize DirectQuery modelsЧтение

Create and manage aggregations

What are aggregations and why use them?ВидеоCreating an aggregationВидеоExercise: Adding an aggregationЧтениеSelf-review: Adding an aggregationЗаданиеExemplar: Adding an aggregationЧтениеHow to manage aggregations step-by-step Чтение
04Final project and assessment: Modeling data in Power BI9 материалов

Final project and assessment: Modeling data in Power BI

Course recap: Modeling data in Power BIВидеоAbout the final project and assessment: Modeling data in Power BIЧтениеExercise: Building and optimizing a data modelЧтениеSelf-review: Building and optimizing a data modelЗаданиеExemplar: Building and optimizing a data modelЧтениеCourse quiz: Modeling data in Power BIЗадание

Course wrap-up: Data modeling in Power BI

Congratulations!ВидеоReflect on learningОбсуждениеNext stepsЧтение
Additional resources: Introduction to measuresЧтение
Using CALCULATE with filtersВидео
Filter functions in CALCULATEЧтение
Activity: Using the CALCULATE functionЧтение
Knowledge check: Working with measuresЗадание
Additional resources: Working with measuresЧтение
Knowledge check: DAX and table relationshipsЗадание
Additional resources: DAX and table relationshipsЧтение
Exemplar: Using time intelligence to compare to previous yearЧтение
Setting up a common date table using DAXВидео
Setting up a common date table with M and Power QueryВидео
Activity: Set up a common date tableЧтение
Time intelligence in businessВидео
Knowledge check: Time intelligence calculations in DAXЗадание
Module summary: Using DAX in Power BIВидео
Module quiz: Using DAX in Power BIЗадание
Which DAX features did you find most useful?Обсуждение
Additional resources: Time intelligence and calculations in DAXЧтение
Knowledge check: Create and manage aggregationsЗадание
Module summary: Optimize a model for performance in Power BIВидео
Module quiz: Optimize a model for performance in Power BIЗадание
How would performance and optimization impact different stakeholders?Обсуждение
Additional resources: Create and manage aggregationsЧтение