The Power Pivot Data Model

with Gasper Kamesek, Founder of Excel Olympics | 4x Microsoft MVP

The Power Pivot Data Model

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
KPI’s
Unpivot Command
Handling Data Types
Creating/BulletProofing Dimension Tables
Dynamic Calendar

Part 2: PowerPivot
Creating Model Connections
Sort-By Column command
Date Table
DAX
Measures
Disconnected Slicers
Time Intelligence
All-In-One Measures

Part 3: Excel
End Report utilizing all that the perfect Data model Offers

Who Is This For?

This masterclass is for anyone who has to deal with larger and more complex data sets on a regular basis. Customer Service Reps, Sales Assistants, Marketers, Event Planners, Analysts, etc.

Skills Requirements

Prior Power Query and Power Pivot experience is recommended for this masterclass.

About Your Instructor

Gasper Kamensek is an Excel MVP from Slovenia, Trainer, and Consultant at Excel Olympics and owner and Lead Author at Excel Unplugged. He has dedicated his work to the noble goal of helping people enjoy working with Excel by helping them master it. As we all know, we love doing what we excel at (no pun intended).

 

$ 200 USD per class

Buy Masterclass

Masterclass Series
$ 600 USD