Power BI Master Class - Data Modeling and DAX Formulas
4.4 (449 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.
2,135 students enrolled

Power BI Master Class - Data Modeling and DAX Formulas

Prepare and learn for the Microsoft MCSA BI Reporting Exam 70-778 Analyzing and Visualizing Data using Power BI Desktop
Bestseller
4.4 (449 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.
2,135 students enrolled
Created by Ian Littlejohn
Last updated 3/2019
English
Current price: $11.99 Original price: $99.99 Discount: 88% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 15 articles
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ 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 calculated 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

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

This course is presented by Ian Littlejohn - who with over 23000 students is one of the most popular 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.

Please note that this course is the second course in a series of three courses for the Power BI Master Class that cover the key outcomes of the Exam 70-778.

  1. Course 1 - Consume and Transform Data

  2. Course 2 - Data Modeling and DAX Formulas

  3. Course 3 - Visualizations and The Power BI Service

Ian Littlejohn is a professional trainer and consultant. Ian has been working and training users on Microsoft Power BI since the release of Power BI. In this series of courses Ian teaches and prepares users for the Microsoft Exam 70-778 Analyzing and Visualizing Data by using Microsoft Power BI.  

The Microsoft MCSA BI Reporting is a valuable  certification for every Excel and Power BI user. The certification consists of two exams.  Exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI and Exam 70-779 Analyzing and Visualizing Data with Microsoft Excel. Ian has created a series of courses that will assist all users to prepare for these exams.

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.

In this second course - Data Modelling and DAX Formulas using Microsoft Power BI Desktop we 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

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

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 51 lectures 03:27:59
+ Introduction to the Course
1 lecture 03:47

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

Preview 03:47
+ Overview of the MCSA BI Reporting Certification
2 lectures 04:11

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

Preview 04:00

Links to the MCSA BI Reporting Microsoft certification

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

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
01:01
+ Creating Calculated Columns
12 lectures 42:17

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.

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

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

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

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

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

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

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

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

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

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

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

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

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