Turn Excel Table into Power BI Data Model in 3 STEPS

In this Power BI Tutorial for Beginners, you will learn how to do data modelling in Power BI! Power BI Data Modelling has never been easier.
Data set: fromzero2bihero.ck.page/dc4ab...
Watch next: Power BI Data Model Selection Simplified. - • SIMPLE Technique for C...
Behind the Scenes of Data Modelling in Power BI: End-to-End Project. (MS Access) - • Data Modeling in Power...
Create stunning visuals: • UPGRADE the Power BI L...
Power BI for Beginners Playlist - • Power BI for Beginners
The data model is the foundation of every successful report. Get any of it’s parts wrong, and your report will crumble under its own weight.
In this Power BI Data Modelling Tutorial, you will learn how to create the data model from an Excel file in 3 easy steps.
By the end of this video, you will be able to do all the basic operations of data modelling.
⌚ TIMESTAMPS
00:00 Intro
00:15 Step 1
01:44 Step 2
09:00 Step 3
10:32 What next?
👍 Thank you for watching! If you found this video helpful or insightful, don't forget to like, comment, and subscribe! Your support means the world. Ready to explore the full potential of Power BI? Remember, you're awesome-catch you later! 🌟 #PowerBI #BIforBeginners #DataMagic #TechTutorial

[@cvdung06]

Excellent instructions. Thanks🎉

[@MMS-PowerBI]

I'm glad it was helpful! Thank you for watching, and I hope you'll enjoy more tutorials from me.

[@xyclos]

Excellent. Thanks.

[@MMS-PowerBI]

You are welcome! I'm glad you liked it 😊!

[@kennethstephani692]

Great video!

[@MMS-PowerBI]

Thank you very much! I'm glad you enjoyed it 😊

[@BoterH]

Thank you very much for the tutotrial. One of the first i don't have to accelerate X2 to follow :-). There's step I don't understand well is about value replacement. If you replace departement ID (so secondary key) how the ID HRFM, HRFH ... will link with the DimEmployee table, as the primary keys have not changed...

[@MMS-PowerBI]

I am happy you found the tutorial useful and that it has the right speed. I try to stay more to the point, than go around the bushes for nor reason :).
Now, related to you question, first of all well spotted. I have tried to add that step more like a how to do it. In real life this would create a blank result and all sort of issues.
The solution is to make the replacements in the original table or file, before duplicating, and then both the employees table and the department id table would have the same IDs.

[@saltyashiful]

When creating a dimension table, can I use references instead of duplicates?
What is the difference between the two methods?

[@MMS-PowerBI]

In theory both duplicate and reference will give you a copy of the initial query, but.... There is a but :)
With duplicate when you change/modify the initial query, the copy will not be affected. Whatever steps you make in the fact table, they will not be reflected in the dimension table.
With reference on the other hand, any changes you make to the initial query will be reflected in the copy. For example, if you use reference to create the parts dimension and then in the fact table you remove the part description column, then the description column will be removed in the dimension table as well.
I hope this answer you question. If if you have any more question please give me a shout. I'll be more than happy to help.

[@billgillaspey9036]

Ye: thank you for this video. And I, too, would like to receive the data set. Thanks in advance.

[@MMS-PowerBI]

Hello and Thank you for watching the video.
The download link was added to the description of the video.

[@MojtabaFazeli-hl8dh]

Hi and Thank you, But can ytou share data sample for use according your tutorial?

[@MMS-PowerBI]

Hello and Thank you for watching the video.
The download link was added to the description of the video.