The Power Pivot Data Model

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

Gasper Kamensek

May 25th & 26th 2022 | 17:00-20:00 BST

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:

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