Who is this training for?
Data analytics professionals and BI experts who want to deepen Microsoft Excel and Power BI data models with DAX to transform data, optimize data models within their organization
Training objectives
- Modify data models using DAX language
- Deepen basic DAX functions
Summary
The goal of this course is to enable advanced users of Microsoft Excel and Microsoft Power BI to use Data Analysis Expression (DAX) to perform transformations and calculations to tailor their datasets for reports and dashboards.
Course outline
Chapter 1 - Confirm the DAX fundamentals
- Use the DAX (Data Analysis eXpression) language
- Discover the differences between Excel and Power BI
- Understand the concepts of DAX context
- Review the calculated measures and columns
- Set up naming conventions
- Use variables
Chapter 2 - Review the main functions
- Manipulate the text
- Set up logical functions
- Use temporal functions
- Exploit information functions
- Creating Data Tables
- Manipulating Table Structure
- Formatting Blocks of Operations
Chapter 3 - Setting Up Filters and Sorting
- Setting Up a Filter
- Learning to Undo Filters • Applying Calculations with Filters • Following Existing Relationships Between Tables • Understanding How to Set Up Filter Tests
Chapter 4 - Counting with DAX
- Using Counting Functions
- Counting Table Rows
- Using Single Count Functions
Chapter 5 - Working with Loops
- Understanding the Use of Iterative Functions
- Building Complex Iterative Functions
- Creating Measurements with DAX
- Manipulating Filters with the CALCULATE Function
- Working with Time Functions
Chapter 6 - Optimizing the Data Model
- Examining Data Model Performance
- Using Variables to Improve Performance
- Reducing Cardinality
Chapter 7 - Applying the Right Ones
- Use error functions
- Apply the right references
- Define your best practices
Approach and methodology
- Lectures
- Demonstrations
- Guided and individual exercises
Prerequisites
Have access to the Power BI service (Pro License) or equivalent content. Power BI app installed on the desktop or equivalent content.
Recommendations
Have at least completed the Power BI - Building Reports and Dashboards or equivalent content
