Getting Started with Power Pivot in Excel [FULL COURSE]

Power Pivot is an Excel feature (Windows only at the current time) that removes many of the limitations and frustrations associated with creating Pivot Tables. Using Power Pivot you can...

Create Pivot Tables from multiple lists/tables without the need to combine them into a single list first (goodbye X/VLOOKUP and all the issues that it brings)

Create Pivot Tables from large datasets without worrying about file size, performance or needing more rows than an Excel worksheet contains

Create Pivot Tables from multiple data sources (Excel, database, text file, web-based content etc)

Pivot Tables that are based on Power Pivot can also take advantage of the powerful DAX formula language that is used to create custom calculations

Topics Covered:
- Importing data into Power Pivot - the why and how
- The importance of understanding The Data Model
- Creating Relationships Between Tables
- Creating Data Model/Power Pivot based Pivot Tables
- DAX Primer: Create a simple calculated column

⏱ Timestamps
00:00:00 Introduction
00:00:43 What is The Data Model?
00:06:36 Enabling Power Pivot
00:11:00 Loading Data into The Data Model
00:22:30 Create Relationships Between Tables
00:25:21 Create a Pivot Table from The Data Model
00:36:48 Create a Calculated Column using Power Pivot (DAX)
00:54:12 Create a Calculated Column using the Query Editor

✅ Want more FREE training?

🙋‍♂️ Let's connect on social

#excel #powerpivot #datamodel

[vijaychouhan]

Exceptional delivery of content, learned so much in this hour of course. Many thanks from your new subscriber. 👍

[teresamorgan]

this was a great tutorial. Thank you so much. I can't wait to use these new tools in my daily excel tables

[abdul_rehman]

It was easy to follow. Thanks a lot for your time and energy.

[macerface]

Hi Mike, did you end up doing a part 2 to this course? I am learning PowerPivot for my new job and would love to watch. Thanks.

[thegaffer]

GREAT TEACHER....IT WOULD BE EVEN GREATER IF WE HAD THE DATA FILES TO FOLLOW ALONG

[DataExcellency]

Hello Thomas, Can you please assist with the Practice Files, it will help out. Anticipating your kind response.

[TungPham-tbbr]

Hi everyone, I can't locate power query editor video in Mike's channel, if anybody has it saved in their list could you please share. Thanks

[chamanthawickramarathne]

Can you share the excel files used here .

[francoistheron]

I really would have appreciated the files used in the tutorial.