Using DAX in Microsoft Power BI
Published by Pearson
Learn how to enrich your Power BI reports by using DAX calculations
- Take your Power BI skills to the next level by using DAX to solve common calculation problems
- Create time intelligence reports such as year-over-year comparisons more easily
- Get your questions answered and see DAX in real time with Power BI expert instructor Daniil Maslyuk as your guide
Microsoft Power BI is an essential tool for many analysts, but to really get the most out of your data, you need to use DAX (Data Analysis Expressions). In some cases you can create insightful visuals in Power BI without writing DAX, but for more sophisticated analysis, you might need to enrich your model with measures, calculated columns, or calculated tables. DAX can do this and more. In this course, we’ll review the basics of DAX so that you are equipped with enough knowledge to solve the most common data analysis problems.
What you’ll learn and how you can apply it
By the end of the live online course, you’ll understand:
- When to create a measure, calculated column, or calculated table
- When DAX is a good fit to solve a problem, and when it isn’t
- How DAX calculations are different from Excel and SQL
And you’ll be able to:
- Write time intelligence calculations, such as year-on-year comparison or month-to-date aggregation
- Follow best practices when writing DAX
- Solve the most common calculation problems by using DAX
This live event is for you because...
- You are a data analyst
- You create business reports
- You’re an experienced BI developer who is new to Power BI
Prerequisites
- Basic familiarity with Microsoft Power BI
- Data analysis skills
- Experience with Excel (desirable)
Course Set-up
- Course set-up resources will be uploaded to GitHub
Recommended Preparation
- Attend: Analyzing and Visualizing Data with Microsoft Power BI by Daniil Maslyuk
- Attend: Advanced Microsoft Power BI by Daniil Maslyuk
Recommended Follow-up
- Read: The Definitive Guide to DAX by Alberto Ferrari, Marco Russo
- Read: Analyzing Data with Power BI and Power Pivot for Excel by Alberto Ferrari, Marco Russo
Schedule
The time frames are only estimates and may vary according to how the class is progressing.
Segment 1: Introduction (60 minutes)
- Course overview
- Creating measures, calculated columns, and calculated tables
Q&A/break (15 minutes)
Segment 2: CALCULATE (60 minutes)
- The use of CALCULATE
- Adding, removing, modifying filters with CALCULATE
- Using CALCULATE modifiers
- Evaluation contexts and context transition
Q&A/break (15 minutes)
Segment 3: Time Intelligence and Other Concepts (80 minutes)
- Time intelligence
- SWITCH
- Table functions
- Window functions
Course wrap-up and Q&A (10 minutes)
Your Instructor
Daniil Maslyuk
Daniil Maslyuk is an independent business intelligence consultant and trainer who specializes in Microsoft Power BI. Daniil is the author of the official Microsoft Power BI exam reference books. For his community contributions, he has been recognized as a Microsoft Most Valuable Professional (MVP). Daniil blogs at xxlbi.com and tweets as @DMaslyuk.