# @udemy on YouTube

- **Type:** Video
- **Original URL:** https://youtube.com/watch?v=Gt3m-rm-pqc
- **Gondola URL:** https://gondola.cc/posts/72078178-udemy-youtube
- **Thumbnail:** https://img.gondola.cc/tr:w-,h-,fo-auto/postThumbnails/21426ea5ed.jpg
- **Posted:** 2019-03-21T21:09:12.000+00:00
- **Account Owner:** Udemy (@udemy) — https://gondola.cc/udemy

## Caption

Want to take your data analysis to the next level? Learn how to build relational data models in Excel for in-depth, efficient analytics! 

In this beginner-friendly tutorial, Excel expert Chris Dutton walks you through using Power Pivot and the Data Model to connect multiple datasets, ditch VLOOKUPs, and create dynamic, scalable pivot tables. Say goodbye to clunky lookups and hello to smoother, smarter analysis!

✨ What you’ll learn:
How to create relational models in Excel
Using Power Pivot for deeper data insights
Replacing VLOOKUPs with table relationships
Building Pivot Tables across multiple tables
Scalable, efficient analytics with DAX foundations

⏱️ Timestamps
00:00 – What is a relational data model?
00:30 – Key benefits of Excel’s Data Model
01:00 – How to add data to the model (Power Pivot tab)
01:20 – What to do if you don’t see Power Pivot
02:00 – Exploring diagram and data views
02:30 – Real-world use case for multiple tables
03:20 – Demo setup: transactions, products, customers, calendar
04:00 – Why VLOOKUP is inefficient for large datasets
05:00 – How relationships replace lookups
06:00 – Adding tables to the data model
07:00 – Creating table relationships manually
08:00 – Power Pivot in action with multi-table Pivot Tables
09:00 – Adding measures with DAX
09:40 – Final pivot demo with dynamic filtering
10:10 – Wrap-up: why the Data Model is so powerful

🔗 Resources & Related Links

📘 Full Excel Pro Tips Course:
https://www.udemy.com/course/microsoft-excel-pro-tips-for-power-users/

👨‍🏫 Chris Dutton’s Instructor Profile:
https://www.udemy.com/user/maven-analytics/

📚 Browse More Excel Courses on Udemy:
https://www.udemy.com/topic/excel/

👍 Found this helpful? Drop a like, leave a comment, and hit subscribe if you’re into learning cool Excel tricks.

#ExcelForecasting #DataTrendsAnalysis #ExcelForBeginners #ForecastToolExcel #DataDrivenDecisions

## Stats

- **Views:** 32,690
- **Likes:** 293
- **Shares:** 0
- **Comments:** 3

## Tags

datadrivendecisions, excelforbeginners, excelforecasting, datatrendsanalysis, forecasttoolexcel

---
Copyright (c) Gondola