Excel Data Model: How to Model Data in Excel

If you don't know anything about data modeling in Excel, this video is for you. In this video, you are going to learn how to create a data model from Excel tables and build a pivot table with the data model.
Dataset used in this video for your own practice:
tinyurl.com/2p8jp2kt
My Course: Data Analysis with Excel: tinyurl.com/5n86tcpz
Also Watch
How to Merge Excel Worksheet with Power Query
• How to Merge Multiple ...
How to Create a Pivot Table from Multiple Excel Sheets
• How to Create a Pivot ...
Join my Facebook Community
tinyurl.com/hb6dh48v
Connect with me on LinkedIn
/ josephokon
Dax and date model
create a data model in excel
Data model with power pivot
Excel database modelling
What is dax
What is power pivot
data model excel
data modeling in excel
building a data model in excel
excel data model
power pivot excel
#powerpivot #exceldatamodel

[@billminckler6550]

So very well done. Excellent pace. Excellent clarity. Much thanks! 👏👏👏

[@prathvisingh8288]

So simply and elegantly explained! Thank you sooo much!!!!!!

[@jamescompton7607]

You are great man, i hope you keep the content coming and good prayers!

[@michawnuk8114]

That was a great video. I was following Microsoft tutorial and could recreate most of the steps. Your tutorial is very helpful

[@tarikuwodajo1019]

Thank you bro. This video answered my questions searching to know for about a month.

[@anthonyfernandezgonzalez8262]

Thank you friend, lesson completed. Greetings from Costa Rica.

[@user-nv6ok8pm1u]

this is very useful. Thank you for the clear instructions! nicely done!

[@sadathsharieff18]

Well Done, Nice functionality with short video. Thank you Sir..

[@ibrahimbasioni8897]

This a great actually Mr.Joseph , thanks for this valuable information and your simple way of instructing is actually amazing

[@selormaniwa6550]

Please did you catch how he created the tables?

[@iancarr3923]

Very helpful, thank you!

[@omoabuganemmanuel3642]

This is educative well done sir

[@shivagoel6576]

really amazin' bruh!

[@ryantan9425]

Well done bro

[@ukemematthew1895]

Love this

[@dalskiBo]

Thanks, I'm finding it hard to distinguish the difference between Access & Excel nowadays. Excel is becoming more like a database.

[@paravej]

Exactly... After understand the Data model... Excel is seem to a RDBMS now and now it's not a wide spreadsheet only....

[@peculiarinana4667]

Thank you

[@ssjkyzer]

ty

[@hemanthtendulkar628]

just want to suggest one thing , if you are applying shortcuts for certain things then how can a viewer can able to understand the content

[@rohithmallampati9320]

👌🏻👌🏻👌🏻👌🏻👌🏻

[@olaworetaofeek7955]

You applied a shortcut that actually created the table, you should do well and let us know

[@selormaniwa6550]

How did you create the table? It was too fast i didn't see how.

[@kevinmahernz]

Select the range that's got the data in it including the headers, then press Ctrl T. Look to see if the "my data has headers" box is ticked, then click OK

[@the_suss_gang]

Not good

[@the_suss_gang]

Not good