Using the Data Model to Create Pivot Tables: 1-Hour Tutorial!

Download the free demo file and follow along here

In this Microsoft Excel tutorial, we'll walk you through creating PivotTables in Excel using the Data Model. We'll teach you what a data model is all about and discuss the Power Query editor. You will also learn how to add data to the data model, create a Pivot Table and Pivot Chart from the data model, and so much more!

Check out our FREE 300+ hour training course playlist here ➡️

💻Watch more popular tutorials from Simon Sez IT:

✅Excel 2021 Tutorials for Beginners playlist

✅Microsoft Excel Long Tutorials for Beginners, Intermediate, and Advanced Learners playlist

💬Stay in touch!

🔔Subscribe to our channel:

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)

[kamleshchandel]

You are Amazing Deb and Ur voice is Mind blowing.. ur teaching style is Unique ....❤❤ I Love Ur teaching style

[panduislami]

Thank you Miss Deb, that's really helpful

[ivicapetrovic]

Thank you for great tutorial, it will save me time in future, you have new subscriber 😀

[neccomputercenter]

So Nice to Explain the Data Model to Create a Pivot Table. I say "Wow"

[PhuongNguyen-sfdx]

Its really helpful for self-taught.Thank you so much 😍😍

[matthewchu]

Thank you for sharing. two quick questions - 1. What if we moved the folder or file location? would this data model lost connection? 2. What if the columns of the new transaction data file are in different sequence / format, would the data model still be able to capture the respective column? i.e. need to be in the exact same format to add new files?

[onsenguy]

Another awesome video. 👍 Question.. assuming cleanup steps were performed in power query for the 2019 data, will those same steps automatically cleanup 2020 and 2021 as well?

[trevordaniels]

Very useful tutorial. Perhaps it would have been better to use different data for the 2021 file as the figures are the same for 2020.

[dwarfusinterruptus]

the link for the "FREE" downloads takes me to a login page and then a pay to register page, and not a page to download files.

[SurooTheDiscipl]

Can we have the datasets for practice because I don't find it in the link you provided below.

[jeripangaribuan]

May I ask? How to show Data Model in pivot if not there please, thank you

[surajagasti]

Can I add this to my resume as a project?

[remuslupinhp]

Can we do the same thing using merge queries? I did merge query today on another dataset but not sure if it is the same or something different. Please help me by confirming, thanks 👍

[SUR-NI-VARA]

Excellent Practicle way of Teaching !! I follow many Excel MVP since long, However this is the first session, which has explained me the entire process of Creating a Data Model from scratch. 💯👌Defenately userful for excel ethusiast like me. Actively seeking assistance on Multi Level Pie chart overlapping of Labels, I could find the solution by adding values from cell range! and moving the labels outside the Circle ! on by one, its a time consuming effort, Is there a vba code, which can automate this process! Kindly guid me on this. Thank you in advance for your support !

[loose.electricity]

Any way to actually get the free demo file and follow along? The link goes to a paid subscription page now :/

[beingrishi]

Exceptional but we need datasets please do share Google drive

[emilytran]

Thank you for the video ! How do you call pivot field from data model... let's say I want to date filter between range for "DATE" but error 1004: Unable to get PivotFields property of the Pivotable class.
Can you please advise. Thanks !

Private Sub Target As Range)

With
.ClearAllFilters
.PivotFilters.Add Type:=xlDateBetween, Value1:=Range("D2").Value, Value2:=Range("F2").Value
End With

End Sub