Examining how to combine, shape and enhance data from multiple data sources in Power BI in order to create a comprehensive data model to meet your business requirements.
Examining how to combine, shape and enhance data from multiple data sources in Power BI in order to create a comprehensive data model to meet your business requirements. The course will examine the more advanced aspects of data shaping using Power Query and the M language.
The full agenda for this 1-day workshop is: • Introductions and Overview • Module 1: Basic Data Modeling • Module 2: Getting Started with M (Power Query Language) • Module 2 Lab: Import and Basic Transform • Module 3: Advanced M Transformations • Module 3 Lab: Complex Transformation • Module 4: Variable, Parameters and Functions • Module 4 Lab: Creating Parameters and Paths • Module 5: Optimisation Techniques • Wrap Up & Questions