Who is this training for?
Professionals, data engineers, and data analysts who want to customize Power BI or Power Pivot data queries using the M language or Power Query editor
Training objectives
- Transform data with Power Query
- Use the M language
- Combine data from different sources
- Explain data refresh
- Learn how to use relationships effectively
- Distinguish the effects of active and non-active relationships
Summary
This training is intended for professionals who analyze data and BI experts who want to deepen the data models of Microsoft Excel and Power BI with the M language to connect different data sources, transform data, optimize data models within their organization.
Course outline
Chapter 1 - Confirm the fundamentals M
- Use the M language
- Discover the differences between Excel and Power BI
- Understand the Power Query editor
- Learn how to document Power Query queries
- Set up a naming convention
- Use variables
Chapter 2 - Query data sources
- Understand data access functions
- Discover the impact on data refresh
- Optimize data querying
Chapter 3 - Modify data queries
- Using the M language and the advanced editor
- Using the main binary functions
- Using the main association functions
- Using the main comparison functions
Chapter 4 - Using the advanced queries
- Using the date and time functions
- Using the DateTimeZone functions
- Using the duration functions
- Learning how to use the error functions
Chapter 5 - Using the query parameters
- Creating the parameters in your queries
- Learn how to use the Power BI model with parameters
- Learn how to diagnose errors
Chapter 6 - Create a date table
- Use variables to set bounds
- Use functions to create references
- Apply necessary transformations
- Properly document your code
Chapter 7 - Optimize the relationship schema
- Understand the impact of active and non-active relationships
- Understand the filtering direction and how to use it
- Learning to Define a Model of Optimal Relationships
Chapter 8 - Applying Best Practices
- Applying the Right References
- Defining Your Best Practices
Approach and methodology
- Lectures
- Demonstrations
- Guided and individual exercises
Prerequisites
Have at least completed the Power BI - Building Reports and Dashboards or equivalent content
Recommendations
Have at least completed the Power BI - Building Reports and Dashboards or equivalent content
