Overview
Microsoft Power BI gives you a wide range of methods to analyze your data and generate insights to support business decisions.
In this course, you will learn how to write DAX expressions to create calculated Tables, Calculated columns and measures.
You will also learn how to perform complex analysis and computations using DAX.
 Perform Time intelligence calculations such as running totals, year over year growth, month over month growth and prior period analysis.
 Create tables using Table functions such as VALUES, DISTINCT, FILTER and ADDCOLUMNS
 Create Date Tables using CALENDAR and CALENDARAUTO.
 Master DAX Concepts such as Evaluation Context, Filter Context and Row Context.

Perform HR Analytics using DAX.
Who should take this course
This course is perfect for all Power BI users who want to take their data analysis in Power BI to the next level. This course is recommended for both beginners and advanced Power BI users.
Benefit of this course:
 Highly practical and handson.
 Q and A section to ask questions and get feedback
 Lifetime access to course and materials
 Certificate of completion
 Downloadable exercise files and DAX guide
Course Content
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
 Introduction to calculated tables (2:46)
 Using the VALUES Function (4:11)
 Using the VALUES Function with Table Input (3:44)
 Using the DISTINCT Function (2:51)
 Combine multiple Tables with the UNION Function (3:22)
 Create Date Table with the CALENDAR Function (3:06)
 Create Date_Table with CALENDARAUTO (4:27)
 Add Columns to a Table with ADDCOLUMNS Function (6:24)
 Create a Table with the FILTER Function (4:59)
 Using the FILTER Function with Logical operators (5:55)
 Summarize Data with the SUMMARIZE Function (10:36)
 Calculated Tables Review (1:08)
Available in
days
days
after you enroll
Available in
days
days
after you enroll
 Introduction to Measures (6:33)
 Creating Measures Table (3:47)
 Introduction to AGGREGATE Functions (1:59)
 Using the SUM Function to aggregate values (6:55)
 Using the COUNTROWS Function (2:35)
 Using the AVERAGE Function (3:55)
 Aggregate values using the MIN and MAX Functions (2:26)
 Difference between Measures and Calculated Columns (2:18)
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
 Introduction to the CALCULATE Function (1:00)
 Understanding the CALCULATE Function (3:59)
 Using the CALCULATE Function Demo 1 (7:54)
 Using the CALCULATE Function Demo 2 (4:48)
 Using the CALCULATE Function Demo 3 (5:10)
 Creating a virtual table with the FILTER Function (11:51)
 Introduction to Filter Modifiers (0:53)
 Introduction to REMOVEFILTERS (2:58)
 Using REMOVEFILTERS with CALCULATE (8:32)
 Introduction to the ALL Function (2:24)
 Using the ALL Function with CALCULATE (6:33)
 ALLSELECTED Introduction (1:41)
 ALLSELECTED Demo (7:26)
 ISINSCOPE Function (8:00)
 CalculateTable Function (2:03)
 Calculated Table Demo 1 (4:11)
 Calculated Table Demo 2 (7:26)
Available in
days
days
after you enroll
Available in
days
days
after you enroll
 Introduction to Time Intelligence (3:46)
 Using the PREVIOUSYEAR Function to perform YoY Analysis (6:36)
 Using the PREVIOUSMONTH Function (3:37)
 Performing MoM Analysis (3:10)
 Using the PREVIOUSDAY Function (2:42)
 Using the DATEADD Function (5:21)
 Using DATEADD for MoM Analysis (6:28)
 Using SAMEPERIODLASTYEAR Function (4:41)
 Calculating Running Total with TOTALYTD Function (4:20)
 Running Totals with different Fiscal Year (3:23)
 Using the TOTALMTD Function (2:35)
 Using the DATESYTD Function (4:20)
 Using the DATESMTD Function (4:26)
 Continuous Running Totals Method 1 (6:02)
 Continuous Running Totals Method 2 (4:11)
 Time Intelligence Review (1:20)
Available in
days
days
after you enroll
Available in
days
days
after you enroll
 Datasets
 Business Requirement (4:06)
 Dataset walkthrough (3:41)
 Data connection and cleaning (4:26)
 1. # of Male and Female Staff (10:04)
 2. % of Males and Females Staff (7:15)
 3. Staff promoted in 2020 vs 2021 (2:38)
 4. % of Staff promoted in 2020 vs 2021 (3:37)
 5. % of Male and Female promoted in 2020 vs 2021 (11:37)
 6. Staff promoted from Managers to Senior Manager in 2021 (3:58)
 7. % of directors promoted in 2021 (4:53)
 8. Directors who resigned in 2020 (4:10)
 9. # of males and females who resigned in 2020 (2:52)
 10. Turnover rate in 2020? (1:33)
 11. Impact of new Salary Review (8:55)
 12. Impact of new Salary Review (2:57)
Available in
days
days
after you enroll