Power BI Master Class-Data Models and DAX Formulas 2020
4.5 (2,718 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.
10,009 students enrolled

Power BI Master Class-Data Models and DAX Formulas 2020

Learn how to create data models, relationships and use DAX formulas in Microsoft Power BI
Bestseller
4.5 (2,718 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.
10,009 students enrolled
Created by Ian Littlejohn
Last updated 7/2020
English
English [Auto], French [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 11 articles
  • 7 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

**** Updated June 2020 this bestselling Udemy course has been updated to the new Microsoft Power BI user interface ****

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 75 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 course  you will learn:

  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, Time Intelligence, Customer Segmentation and many more

  4. Creating Relationships between tables and using relationship calculations

  5. Creating Virtual Tables and Calculations between Tables

  6. Creating and using hierarchies and data groups

  7. Case Studies on DirectQuery, Star Schemas and Quick Measures

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
Course content
Expand all 56 lectures 04:17:58
+ Introduction to the Course
3 lectures 04:15

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

Preview 01:44
Please download the Training Data Files
00:04
+ Overview of the Power BI Data Model
2 lectures 11:15

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

Introduction to Overview of the Data Model
01:09

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

Overview of the Data Model
10:06
+ Creating Calculated Columns
14 lectures 01:01:42

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

Introduction Calculated Columns
01:01

An overview and explanation of the Power BI Data Model.

What is a Calculated Column?
03:37

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

Preview 09:55
What is DAX?
00:52

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:18

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
08:43

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

Practical Activity - Calculated Columns with Date Fields
00:11
Weekday and Weeknum Formulas
08:07

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:52

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

Practical Activity - Formatted Date Names
00:25

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
09: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.

IF Function
04:18

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

Switch Function
06:39
+ Creating Power BI Measures
8 lectures 36:16

Introduction to the section on Measures

Introduction to the Measures Section
01:13
What is a Measure?
03:25

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

Creating Measures
08:48

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

Practical Activity - Creating Measures
00:10
Practical Activity - Measures
07:16

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:47

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

Practical Activity - =Calculate Formula
00:16

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

The All and AllExcept Function
06:20
+ Time Intelligence Functions
3 lectures 25:32

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
09:35

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

Time Intelligence - Part 2
09:52
Time Intelligence - Part 3
06:05
+ Additional Measure Calculations
6 lectures 29:02

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
05:01
Practical Activity - Find the Highest Sales Day
00:05

The conclusion to the Measures section.

Example SUMX Functions using Values function
06:02

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

RANKX Function
05:48

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

Customer Segmentation - SWITCH Function
04:40

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

What If Parameters
07:26
+ Virtual Tables
5 lectures 17:40
Introduction to Virtual Tables
01:10

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

Creating Virtual Tables
05:42
Customer Segmentation
05:08
Performance Analyzer
04:58

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 - Virtual Tables
00:42
+ Creating Relationships in Power BI
6 lectures 25:31

Introduction to the Relationship Section

Introduction to the Relationships Section
00:48
Download the Training Data Files
00:02

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

Relationships between Tables
08:06

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

Relationship Calculations
06:28
USERELATIONSHIP Function
09:18

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

Practical Activity - Create Relationships and Calculations
00:48
+ Hierarchies and Data Groups
3 lectures 15:27

Introduction to the Key Performance Indicators section.

Introduction to Hierarchies
00:44

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

Creating Hierarchies
05:56

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

Creating Data Groups
08:47
+ Case Studies
5 lectures 30:36

Introduction to the Hierarchies section

Introduction to Case Studies
02:03

Introduction to star schemas

Introduction to Star Scemas
02:24

Conclusion to the hierarchy section.

Creating Star Schemas
07:49
Using DirectQuery Mode
08:47
Creating Quick Measures
09:33