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

/in /by

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.

Download the workbooks: https://datascopic.net/DM2

#DataModel
#PowerQuery
#Excel

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil

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

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2