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?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk

🙋‍♂️ Let's connect on social
Twitter:   / theexceltrainer  
Facebook:   / theexceltrainer  
LinkedIn:   / thomasmik  

#excel #powerpivot #datamodel