Data Modeling in Power BI

This course is part of Microsoft Power BI Data Analyst Professional Certificate

Instructor: Microsoft

Access provided by Special Competitive Studies Project

94,555 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

805 reviews

Beginner level

Recommended experience

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

89%

Most learners liked this course

4 modules

Gain insight into a topic and learn the fundamentals.

805 reviews

Beginner level

Recommended experience

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

89%

Most learners liked this course

What you'll learn

How to form a model using a Star Schema.
How to write calculations DAX to create elements and analysis in Power BI.
How to optimize performance in a Power BI model.

Skills you'll gain

Tools you'll learn

Power BI

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

24 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Data Analysis expertise

This course is part of the Microsoft Power BI Data Analyst Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Microsoft

There are 4 modules in this course

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.

This module introduces data modeling and the schemas used to create them.

What's included

13 videos23 readings6 assignments2 discussion prompts

13 videos Total 68 minutes

Course introduction 4 minutes
Introduction to data models 5 minutes
Introduction to schemas 6 minutes
Setting up a Flat schema in Power BI 5 minutes
Understanding fact and dimension tables 4 minutes
Introduction to cardinality 5 minutes
Introduction to cross-filter direction 5 minutes
Defining data granularity 6 minutes
Setting up a Star schema in Power BI 6 minutes
Setting up a Snowflake schema 6 minutes
Why it is important to use Snowflake schema 4 minutes
Resolving challenges in data models 5 minutes
Module summary: Concepts for data modeling 6 minutes

23 readings Total 255 minutes

Course syllabus 10 minutes
How to be successful in this course 10 minutes
How to open an image in a new tab 10 minutes
Setting up your Power BI environment 10 minutes
New name for Power BI datasets 10 minutes
How to locate your downloaded files 10 minutes
Additional resources: Concepts for data modeling 5 minutes
Model view in Power BI 15 minutes
Schemas cheatsheet 10 minutes
Table and column properties cheatsheet 10 minutes
Exercise: Configuring a Flat schema 30 minutes
Exemplar: Configuring a Flat schema 10 minutes
Activity: Configure a Flat schema with multiple sources 10 minutes
Additional resources: Introduction to data models 5 minutes
Normalization and denormalization 10 minutes
Managing model relationships 10 minutes
Model relationships cheatsheet 10 minutes
Additional resources: Introduction to cardinality and cross-filter direction 5 minutes
Exercise: Configuring a Star schema 30 minutes
Exemplar: Configuring a Star schema 10 minutes
Activity: Changing your Star schema into a Snowflake schema 10 minutes
Data View in Power BI 10 minutes
Additional resources: Working with advanced data models 5 minutes

6 assignments Total 95 minutes

Self-review: Configuring a Flat schema 10 minutes
Knowledge check: Introduction to data models 15 minutes
Knowledge check: Introduction to cardinality and cross-filter direction 15 minutes
Self-review: Configuring a Star schema 10 minutes
Knowledge check: Working with advanced data models 15 minutes
Module quiz: Concepts for data modeling 30 minutes

2 discussion prompts Total 20 minutes

Discussion prompt: What do you hope to learn? 10 minutes
Why is data modeling important in the data analysis process? 10 minutes

This module introduces the learner to the DAX (Data Analysis Expressions) language. The module explores the syntax of DAX using multiple business use cases. The module also integrates DAX with previous lessons on database tables and their use and introduces the concept of time intelligence.

What's included

23 videos21 readings10 assignments1 discussion prompt

23 videos Total 113 minutes

Introduction to Data Analysis Expressions (DAX) 6 minutes
Formulas and functions in DAX 5 minutes
Row context and filter context 6 minutes
Introduction to calculated tables 5 minutes
Creating calculated columns 5 minutes
Introduction to measures 5 minutes
Types of measures 5 minutes
Basic statistical functions 5 minutes
DAX measures and context in business 4 minutes
Creating quick measures 6 minutes
Creating custom measures with DAX 4 minutes
Introduction to the CROSSFILTER function 5 minutes
Using CALCULATE with filters 5 minutes
Introduction to role-playing dimensions 6 minutes
Introduction to the USERELATIONSHIP function 5 minutes
Configuring role-playing dimensions 3 minutes
The importance of time intelligence 5 minutes
Using DAX for summarization over time 6 minutes
Using DAX for comparison over time 5 minutes
Setting up a common date table using DAX 5 minutes
Setting up a common date table with M and Power Query 4 minutes
Time intelligence in business 3 minutes
Module summary: Using DAX in Power BI 7 minutes

21 readings Total 265 minutes

DAX cheatsheet 10 minutes
Cloning and calculating tables 10 minutes
DAX table functions 10 minutes
Exercise: Adding a calculated table and column 30 minutes
Exemplar: Adding a calculated table and column 10 minutes
Additional resources: Introduction to DAX 5 minutes
Statistical functions cheatsheet 10 minutes
Additional resources: Introduction to measures 5 minutes
Exercise: Adding a measure 30 minutes
Exemplar: Adding a measure 10 minutes
Filter functions in CALCULATE 10 minutes
Activity: Using the CALCULATE function 10 minutes
Additional resources: Working with measures 5 minutes
Exercise: Adding a role-playing dimension 30 minutes
Exemplar: Adding a role-playing dimension 10 minutes
Additional resources: DAX and table relationships 5 minutes
Additional time intelligence functions 10 minutes
Exercise: Using time intelligence to compare to previous year 30 minutes
Exemplar: Using time intelligence to compare to previous year 10 minutes
Activity: Set up a common date table 10 minutes
Additional resources: Time intelligence and calculations in DAX 5 minutes

10 assignments Total 145 minutes

Self-review: Adding a calculated table and column 10 minutes
Knowledge check: Using Data Analysis Expressions (DAX) in Power BI 15 minutes
Knowledge check: Introduction to measures 15 minutes
Self-review: Adding a measure 10 minutes
Knowledge check: Working with measures 15 minutes
Self-review: Adding a role-playing dimension 10 minutes
Knowledge check: DAX and table relationships 15 minutes
Self-review: Using time intelligence to compare to previous year 10 minutes
Knowledge check: Time intelligence calculations in DAX 15 minutes
Module quiz: Using DAX in Power BI 30 minutes

1 discussion prompt Total 10 minutes

Which DAX features did you find most useful? 10 minutes

This module explores the optimization process and examines the tools and methods to achieve this in Power BI, including using performance analyzer and DirectQuery features. This module also dives deeper into DAX and its use in the real world.

What's included

10 videos12 readings6 assignments1 discussion prompt

10 videos Total 59 minutes

What is optimization and why is it necessary? 7 minutes
Optimization by example 7 minutes
Identifying and reducing cardinality levels 6 minutes
Resolving performance issues in the data model 5 minutes
Behavior and limitations of DirectQuery connections 7 minutes
Optimizing DirectQuery performance with query reductions 4 minutes
Optimizing DirectQuery performance with table storage 6 minutes
What are aggregations and why use them? 6 minutes
Creating an aggregation 6 minutes
Module summary: Optimize a model for performance in Power BI 8 minutes

12 readings Total 145 minutes

Exercise: Improving data model performance 30 minutes
Exemplar: Improving data model performance 10 minutes
Optimizing columns and metadata 10 minutes
Optimizing the Auto date/time feature 10 minutes
Activity: Optimizing the columns and Auto date/time 10 minutes
Additional resources: Optimize performance in a Power BI model 5 minutes
Walk-through: Optimizing a DirectQuery model 10 minutes
Additional resources: Optimize DirectQuery models 5 minutes
Exercise: Adding an aggregation 30 minutes
Exemplar: Adding an aggregation 10 minutes
How to manage aggregations step-by-step 10 minutes
Additional resources: Create and manage aggregations 5 minutes

6 assignments Total 95 minutes

Self-Review: Improving data model performance 10 minutes
Knowledge check: Optimize a model for performance in Power BI 15 minutes
Knowledge check: Optimize DirectQuery models 15 minutes
Self-review: Adding an aggregation 10 minutes
Knowledge check: Create and manage aggregations 15 minutes
Module quiz: Optimize a model for performance in Power BI 30 minutes

1 discussion prompt Total 10 minutes

How would performance and optimization impact different stakeholders? 10 minutes

In this module, you will be assessed on the key skills covered in the course. This module summarizes the course and reflects on the primary learning objectives. The module also contains the project for the course, which encapsulates the learning into a practical whole.