Excel: Data Models | Add to Data Model | Power Query

After working with data in Power Query there is the option to "Add to Data Model." What is that?
A Data Model is helpful when it's necessary to bring multiple datasets into one. The data can be used in a single pivot table without having to physically merge the datasets into one place.

This video shows how to create a Data Model using the diagram view in Power Pivot. I also show one warning about backward 1-to-many relationships.

#DataModel
#PowerQuery
#Excel

For a list of my Excel courses at Lynda/LinkedIn:

There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

My book: Guerrilla Data Analysis 2nd Edition

[snoresbores]

EXACTLY what I needed. Great content and video!! THANK YOU!

[PJTarver]

Coolest IT guy on the Internet. Clear, concise, and well communicated. Thumbs up dude. I liked it.

[danielmain]

Thanks for the the great Data model explanation Oz! You're the most engaging Excel Guru around.

[jamief]

First one I’ve watched knowing nothing! Already have established how useful this might be. Thank you!

[Yeneney]

I never knew I needed a sheriff to teach me excel but I do, and he's awesome :D

[rupomExcel]

You are simply awesome! I haven’t seen such a simplified version of Data Model tutorial. Wonderful explanation. Thanks Oz!

[suhaimiabdazais]

Love it your explanations.. Thanks Oz...

[cdventer]

This was so helpful - thanks for breaking it down and making it so clear and easy to follow! Smooth production too - can't wait to check out your other videos

[romulusmilea]

Oz, I really love your style. The original way you present any piece of information makes it really easy to understand. You are an Excel...lent teacher ! There are many Excel, Power Query, DAX, Power BI (you name them) specialists all over the world, but only several of them are really good teachers. You are one of the Teachers !

[CaptianInternet]

First comment after a few seconds - I love this guy!

[wayneedmondson]

Thanks Oz. Nice to see this vid in general release. I first viewed it inside the Tips by the Experts course. But, I think access lasts for only 6 months. So, glad to know I can refer to it again at your channel. Thumbs up!!

[michaelbecker]

Thanks Oz Another great video, enjoying learning these snippets from you. THANKS Again

[sergeyvasylyev]

Love your style. Finding it very helpful to understand relatively complex concepts. I've been a user of power query for a while but not using data models yet. Got very intrigued to learn more about using data models with power query.

[davidclearwater]

That's some good stuff. I've wanted to do this kind of data management/analysis before but never been able to figure it out. So thankful to you for making/posting this video.

[tammyaingworth]

Love Oz! Fully explained and understandable!

[dietricha.schmitz]

Seriously love your videos! Quick, accurate and provide me with the info I need.

[kaitang]

Man, you are my hero! Really want to know what you did before You Tube!!!!

[timdowden]

Excellent, thanks for a very informative tutorial - I was a few minutes to being productive after your training VDO

[SimX]

Thanks man, super helpful and thanks for not making it take forever

[ericaleverson]

I love how you teach! I'm just getting started in data and have subscribed!