May 25th & 26th 2022 | 17:00-20:00 GMT
The Power Pivot Data Model
This Masterclass could just as well be called optimization techniques for data modeling in Excel. In this whole day Masterclass, you will use Power Query and Power Pivot to build a light, agile, fast and easily manageable data model. In other words, you will create THE data model. This Masterclass will give you clear guidelines for data modeling that you will be able to use on each model you build in Excel.
What Will You Learn?
- Optimization techniques for data modeling in Excel.
- Use Power Query and Power Pivot to build a light, agile, fast and easily manageable data model.
- Guidelines and best practices for data modeling.
Agenda Outline: The Power Pivot Data Model
Part 1: Power Query
Handling Different Currencies
Fill Down/Up and Merge commands
Handling Data Types
Creating/BulletProofing Dimension Tables
Part 2: PowerPivot
Creating Model Connections
Sort-By Column command
Part 3: Excel
End Report utilizing all that the perfect Data model Offers