Office Productivity
Microsoft
Microsoft Power BI
Power BI Master Class - Data Modeling and DAX Formulas
4.5 (2,197 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
8,508 students enrolled

Power BI Master Class - Data Modeling and DAX Formulas

Learn how to create data models, relationships and use DAX formulas in Microsoft Power BI
Bestseller
4.5 (2,200 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
8,521 students enrolled
Created by Ian Littlejohn
Last updated 9/2019
English
English [Auto-generated], French [Auto-generated]
Preview this course
Power BI Master Class - Data Modeling and DAX Formulas
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 16 articles
  • 10 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Have a COMPREHENSIVE understanding of creating data models and developing DAX formulas in Microsoft Power BI
  • Enjoy CLEAR and CONCISE step by step instruction from a best selling Udemy Instructor
  • Students will be prepared for the data modeling module of the Microsoft Exam 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI
  • Create calculated FIELDS and MEASURES using DAX in Power BI
  • Perform SOPHISTICATED calculations such as Time Intelligence, Filtered Data and Creating Calculated Tables
  • Create RELATIONSHIPS between tables of data
Requirements
  • You will require Power BI desktop and access to the Power BI Service on the Internet
  • You should be able to work with data in Excel and do basic reporting
Description

Recent reviews:

"Really good crash course for Power BI. If you are just started to use Power BI and want to quickly go through the basic I highly recommend this course."

"Awesome. Focused and wll explained!"

"The course is very well structured and at the right pace. There is a very clear explanation as to what is the goal of every section and how it is accomplished. I would definitely recommend the course for anyone starting with PBI."

**** Lifetime access to course materials and practice activities.  100% money back guarantee ****

This course is presented by Ian Littlejohn - who with over 50 000 students is one of the most popular & highly rated instructors on Udemy. Ian provides world leading courses on Excel, Power Pivot, Power BI and Google Data Studio.

Skills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Microsoft Power BI is now recognized as the leading Business Intelligence tool in the world for the development of reports, data analysis and dashboards.

In this course you will learn how to perform data modeling and use DAX formulas to get the most out of Microsoft Power BI.

In this class (the second module of my 3 part "Power BI Master Class" Series), you will cover:

  1. Introduction and Course Content

  2. Creating Calculated Columns - Basic calculations, using date fields and date tables

  3. Creating Measures - Aggregation measures, the =Calculate formula, the All and AllExcept formula, Calculated Tables and Time Intelligence

  4. Creating Relationships between tables and using relationship calculations

  5. Using KPIs visualizations in the data model

  6. Creating and using hierarchies

The prized Microsoft MCSA BI Reporting Certification consists of 2 exams; Exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI and Exam 70-779 Analyzing and Visualizing Data with Microsoft Excel. This course aligns to the outcomes of the Microsoft exam 70-778.  Please see my Excel Master Class Series for content that aligns to Exam 70-779. 

Even, if you are not preparing for the exam you will find these courses a valuable resource to learn the most important and powerful features of Microsoft Power BI and Excel.

We look forward to having you on our course as we learn and explore the incredible power of Microsoft Power BI.

Please note that this course is the second course in a series of three courses for the Power BI Master Class series.  Search for my instructor profile to purchase these other courses.

  1. Course 1 - Query Editor

  2. Course 2 - Data Modeling and DAX Formulas

  3. Course 3 - Dashboards and Power BI Service

Who this course is for:
  • Excel users who want to learn how to create PROFESSIONAL reports in Power BI
  • Learners who want to prepare themselves for Microsoft Exam 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI
Featured review
Eric Tremblay
Eric Tremblay ( 35 courses, 16 reviews )
a year ago
Another great course from Ian Littlejohn. Thank you for making this ! I'm building my Power BI expertise on Udemy and great teachers like Ian Littlejohn. A Note to Udemy Administration: The X.X hours diminished the value of the certificate and does not reflect the true time investment that is actually done by students. Please remove the "X.X hours of" from the certificate.
Course content
Expand all 52 lectures 03:28:03
+ – Introduction to the Course
2 lectures 03:51

Introduction and overview to the Data Modeling and DAX Formulas course.

Introduction to the Course
Preview 03:47
Please download the Training Data Files
00:04
+ – Overview of the MCSA BI Reporting Certification
2 lectures 04:07

In this lesson we provide an overview of the MCSA BI Reporting certification and review resources that can assist with the exam.

Overview of the MCSA BI Reporting Certification
Preview 04:00

Links to the MCSA BI Reporting Microsoft certification

Links to the MCSA BI Reporting Certification
00:07
+ – Signing up for Power BI and Download the Power BI Desktop
2 lectures 04:04

In this lesson we review how to sign up for the Power BI Service and how to download the Power BI Desktop.

Signing up for Power BI Service and Download Power BI Desktop
03:07

Step by step instructions to sign up for the Power BI Service and to download the Power BI Desktop.

Sign up for the Power BI Service and Download the Power BI Desktop
00:57
+ – Creating Calculated Columns
12 lectures 42:13

Introduction to the Data Model and calculations section of the course.

Introduction to the Data Model and Calculated Columns
01:27

An overview and explanation of the Power BI Data Model.

Overview of the Data Model
05:11

In this lesson we cover how to create calculated columns within the Power BI data model.

Creating Calculated Columns
Preview 08:38

In this practical activity you will create three new calculated columns - Sales, Cost and Profit.  You will also format these fields.

Practical Activity - Calculated Columns
00:21

In this lesson we learn how to create additional time intelligence functions such as Year, Month and Day.  These fields are added to your data model.

Creating Calculated Columns of Date Fields
05:51

In this Practical Activity you will create fields for Year, Month and Day

Practical Activity - Calculated Columns with Date Fields
00:11

In this lesson we learn how to create Month Names and Week Day Names for our data model.  We also learn how to correctly set the Sort By option to make sure the names are displayed in the correct order.

Formatting Date Names
07:08

In this activity you will add the Month Name, WeekDay and WeekDay Name to the Data Model.

Practical Activity - Formatted Date Names
00:28

In this lesson we learn how to add a Date Master to the Date Model and then to create a relationship between the Date field and the master date.  

Using a Date Master Table in the Data Model
08:23

In this practical activity you will load and configure the Date Master file to use it for data analysis.

Practical Activity - Adding a Date Table to the Data Model
00:19

A quick review of the Calculated Columns section.

Conclusion to the Creating Calculated Columns Section
00:26

In this lesson you will learn how to use the IF function.

Bonus Lesson - The IF Function
03:49
+ – Creating Power BI Measures
18 lectures 01:42:31

Introduction to the section on Measures

Introduction to the Measures Section
03:02

In this lesson we learn how to create Measures to calculate Sums, Averages and Distinct Counts.

Creating Measures
11:18

In this activity you will add a number of Measures to the Data Model.  

Practical Activity - Creating Measures
00:37

In this lesson we learn how to use the powerful Calculate formula.  The = Calculate formula allows the filtering of an aggregation.

Using the = Calculate Formula
08:44

In this practical activity you will practice using the =Calculate formula.

Practical Activity - =Calculate Formula
00:16

In this lesson we cover how to use the X functions - SUMX, COUNTX, AVERAGEX,MAXX and MINX.  We also review how to manually enter data.

Using the SUMX function
07:27

In this practical activity you will enter a table and create SUMX, AVERAGEX and MAXX functions.

Practical Activity - X Functions
00:18

In this lesson we review how to return the entire total for a column and how to ignore the evaluation context.

The All Function
09:43

Practical Activity to understand the ALL and ALLEXCEPT formulas.

Practical Activities - All and AllExcept Functions
00:37

In this lesson you will learn how to create a datesbetween calculation, trailing number of days, Year to Date, Quarter to Date and Month to Date calculations.

Time Intelligence - Part 1
13:14

In this lesson we will create Previous Month and Previous Year calculations

Time Intelligence - Part 2
07:57

In this practical activity you will create a number of Time Intelligence functions such as Year to Date, Quarter to Date and Previous Year

Practical Activity - Time Intelligence Calculations
00:49

In this lesson you will learn how to create a Calculated Table.  A Calculated Table aggregates detailed data into summary tables.

Creating Calculated Tables
12:35

In this practical activity you will create two calculated tables.  The first table summarizes the Model field and the second the Customer information.

Practical Activity - Calculated Tables
00:34

In this lesson you will learn how to use the What If Parameter.

What If Parameters
09:15

The conclusion to the Measures section.

Conclusion to the Measures Section
00:20

In this lesson you will learn how to do customer segmentation using the SWITCH function.

Bonus lesson - Customer Segmentation - The Switch Function
09:20

In this lesson you will learn how to use the RANKX function to Rank the customer data.

Bonus lesson - Ranking Customers - RANKX Function
06:23
+ – Creating Relationships in Power BI
5 lectures 15:03

Introduction to the Relationship Section

Introduction to the Relationships Section
00:37

In this lesson you will learn how to create relationships between tables in Power BI.

Relationships between Tables
07:41

In this lesson we review how to use relationships between tables to create new calculations. 

Relationship Calculations
05:41

In this lesson you will create relationships between 2 tables and also add calculations using the relationship.

Practical Activity - Create Relationships and Calculations
00:47

The Conclusion to the Relationships section.

Conclusion to the Relationship Section
00:17
+ – Performance KPIs
6 lectures 22:05

Introduction to the Key Performance Indicators section.

Introduction to KPIs
00:59

In this lesson we learn how to use the ScoreCard visualization to analyze Key Performance data.

Using the Scorecard Visualization
11:09

In this lesson we learn how to use the Gauge visualization to analyze Key Performance data.

Using the Gauge Visualization
04:50

In this lesson we learn how to use the KPI visualization to analyze Key Performance data.

Using the KPI visualization
04:23

In this activity you will create Scorecards, Gauges and KPI visualizations.

Practical Activity - KPIs
00:27

Conclusion to the KPI Section

Conclusion to the KPI Performance Section
00:17
+ – Creating Hierarchies
4 lectures 11:53

Introduction to the Hierarchies section

Introduction to Hierarchies
00:28

In this lesson you will create date hierarchies, product hierarchy and region hierarchy.

Creating Hierarchies
10:35

Practical activity for creating hierarchies in Power BI

Practical Activity - Hierarchies
00:34

Conclusion to the hierarchy section.

Conclusion to Hierarchies
00:16
+ – Conclusion to the Course
1 lecture 02:15

Conclusion to the course.

Course Conclusion
02:15