Excel Table to Power BI Data Model - Step by Step. File INCLUDED

In this Power BI Tutorial for Beginners you will learn how to do data modeling in Power BI! Power BI Data Modeling has never been easier.
Data set: fromzero2bihero.ck.page/dc4ab...
Watch next: Power BI Data Model Selection Simplified. - • SIMPLE Technique to Ch...
Behind the Scenes of Data Modeling in Power BI: End-to-End Project. (MS Access) - • Data Modeling in Power...
Create stunning visuals: • Adding Layers of Infor...
Power BI for Beginners Playlist - • Power BI Tutorials for...
The data model is the foundation of every successful report. Get any of it’s parts wrong and you report will crumble under its own weight.
In this Power BI Data Modeling 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 modeling.
⌚ 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.

[@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.