From the course: Excel Power Tools for FP&A: Power Query and PowerPivot
Join today to access over 24,900 courses taught by industry experts.
Introduction to data modeling with Power Query
From the course: Excel Power Tools for FP&A: Power Query and PowerPivot
Introduction to data modeling with Power Query
- Bringing data from backend systems into Power Query and then into an Excel model is great. But what if we had the ability to integrate data across multiple sources across multiple dates, essentially building a relational model inside of Excel? Well, that's what we can do with a technique called data modeling. We have the ability to connect Power Query into a data model that lives within an Excel workbook, not separate from it. This opens up an entirely new way of working with data. Instead of stacking everything in one giant table or manually performing VLOOKUPs and index match formulas to stitch things together, we let Excel handle the relationships for us behind the scenes. You bring your raw data sets, transactions, product info, employee rosters, calendar dates, and you load them into what's called a data model. Once they're in the model, you define relationships between the tables based upon shared columns and data. For example, a SKU in your sales table matches a SKU in your…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
-
(Locked)
Introduction to data modeling with Power Query3m 1s
-
(Locked)
Establishing tabular relationships and data hierarchies14m 9s
-
(Locked)
What Power Pivot is and how to access it3m 31s
-
Creating a Power Pivot report14m 7s
-
(Locked)
Challenge: Create a Power Pivot report1m 38s
-
(Locked)
Solution: Create a Power Pivot report7m 24s
-
(Locked)
-
-
-