Fact & Dimension tables in Power BI | Data Modelling

In this video we will cover how to create FACT & DIMENSION tables in Power BI. We will define what Fact & Dimension tables are and how we can go abouts creating them from out Data.
-
-
0:00 Introduction
0:27 Star Schema Theory
2:54 How to build a model
-
-
-
-
-
-
-
-
Search Tags: Microsoft PowerBI, Microsoft Power BI, PowerBI, Power BI, PowerBI for Desktop, PowerBI Pro, PowerBI Online, PowerBI Tutorial, Power BI Tutorial, The Best PowerBI Design, Inspiring and Amazing PowerBI Design, PowerBI Dashboard, PowerBI Data Visualization, Power BI Data Analytics, Power BI Analysis, PowerBI Report and Dashboard Design, Easy PowerBI Design, Easy PowerBI Data Visualization, Easy PowerBI Tutorial, Power BI End to End Tutorial, PowerBI End to End Design, Quick and Easy, Power BI Tutorial From Beginner to Pro Desktop to Dashboard, PowerBI Data Modeling, PowerBI Measures, What is PowerBI, How to use PowerBI, Is PowerBI easy to learn, PowerBI vs Tableau, PowerBI Online vs Tableau Online, Power BI Tutorial for Beginners - Basics and Beyond, Power BI Tutorial for Beginners - Getting Started, Creating a Power BI report in under 5 mins, Analyze & Visualize Data with Power BI, Mastering Microsoft Power BI - Introduction to Power BI, Power BI Tutorial For Beginners | Introduction to Power BI, PowerBI Navigator, PowerBI Navigation, Data modelling in Power BI Desktop, Power BI Tutorial Videos, Power BI Advanced Tutorial, PowerBI for Freelancers, Power BI Slicers vs Filters, Drilling into drillthrough in Power BI Desktop, Power BI - Dashboards vs. Reports, Power BI Bookmarks, Selections and Toggles, Power BI Beginner Tutorial, How to build Power BI Dashboards, Design, Publish and Share a Sales Dashboard in Power BI, Power BI Desktop for Beginners: Create your first Power BI report and dashboard in 10 minutes, PowerBI For Newbies, PowerBI Ninja Tutorial, How to Design Visually Stunning Power BI Reports, PowerBI Basic Dashboard and Design, Microsoft Power BI: Building spectacular Power BI dashboards, PowerBI Infograph, Easily create infographics in Power BI with infographics desginer, Power BI Dashboard & Reports - Sales Analysis, Top 5 DAX tricks for super effective Power BI dashboards, Power BI visualization best practices, How to create PowerBI Dashboard Reports, Top 10 Most Effective Power BI Dashboard Tips & Tricks In, Design, Publish and Share a Sales Dashboard in Power BI, Power BI - Dashboards vs. Reports, How to Create Beautiful Power BI Dashboards Using the Power Pattern, PowerBI Tips & Tricks for Stunning Power BI Reports!, Power BI Dashboard & Reports - Inventory Analysis, PowerBI for Sales and Marketing, PowerBI for Supply Chain, PowerBI for Inventory, PowerBI for Supply Chain, PowerBI for Purchasing, PowerBI for Warehouse, PowerBI for Logistics, PowerBI for HR, PowerBI for Team Performance and Dashboard, PowerBI for Managers, PowerBI for Employees Team Performance, PowerBI for Excel Users, PowerBI PowerPivot, Import Data to PowerBI, PowerBI to Stores, The Best PowerBI Design, Build Top Amazing PowerBI Design, How to Design Visually Stunning Power BI Reports, Power BI Report Design Tips And Inspiration, Design a Navigation Panel - Power BI Desktop, Power BI Tutorial | Creating Landing Page using Dashboard and Tiles, Power BI Custom Visuals - Infographic Designer, Basic Dashboard in PowerBI, The Best PowerBI, PowerBI Design, Microsoft PowerBI, Free PowerBI Design and Downloads, Free download PowerBI PBIX File, The Microsoft PowerBI Desktop, Power BI App Navigation, Designing Impactful Reports in Power BI (Free Webinar), Free Download, Free Design, PowerBI Template and pbix, Power BI - Do it Yourself Tutorial - Dashboard Design, Create a custom KPI Card in a Power BI report, Introduction to Power BI Designer, 7 Worst Power BI Dashboard Mistakes & How to Avoid Them [PBIX examples included], Data Modeling with Power BI and Power Query, PowerBI M Language, PowerBI Best Practices, PowerBI Desktop, User and Developer, Visually appealing powerbi, PowerBI Trending

[MD-cuwq]

This is the best demo - nobody explains that the original values need to be removed from the master data table. This is not obvious to newbies. I am working with non financial data so need to add my own measures. Thank you!!!

[kristinajensen]

Thank you, and just for this video but for the whole channel. I stumbled upon it yesterday (looking for non-pretensions explanation of variables in DAX measures) and I am a fan! I watched all your videos, some more than once - and you brought back some joy, enthusiasm and HOPE that I could understand and learn Power BI. Thank you a million again and please keep up the fantastic job!

[amid]

The best demo I've ever listenned. Thank you so muchh! God bless ya!

[sluxhid]

Thank you Power BI Guy, this video is helping more than you can imagine :)

[RedCouchChess]

I hope your day is filled with laughter and joy. Thank you for the service you provide to us unqualified data analysts :)

[tlee]

Thank you! This is what I was looking for !

[krishnakantapanda]

That was super super super helpful.... finally I could confidently say that I have clearly understood fact vs dim, foreign vs primary key and star schema concept❤

[alimirazimzadeh]

I have seen over 100 videos, and this is my favorite

[solomonidowu]

Hi. You did a wonderful job here. Thank a lot.

[houseandhobby]

New terminology for classical db concepts. I'm so old. We just covered the concept of normalizing a database in this video. The original term for dim table is parent table. For fact table, child table was the original term, but a specific type of child table that stores observations rather than child entities (in turn pointing to parent entities). Foreign key term still lives on. I would have used Excel (old school, manual, slower). Dim tables are about entities. Fact tables about data observations of the entities. Good normalization results in a hierarchy of dim tables (entities) thanks to common attributes across entities. Nice vid, just chatting some here. Thx

[JackWebb-pddy]

Thankyou for the video, really well explained and great demonstration of the model in effect. At the end you mention a custom date table but then video cuts out - do you have one explaining this or a video you'd recommend?

[nathanmutala]

merci, ce video m'a beaucoup aidé.

[MegaAbgt]

What a fast and elegant tutorial.
I try to find a power bi job but very hard to find one as a newbie.

[bchi]

Thank you. Just was what I was looking for. I have one to many table relationships, I can do the same on the many side.

[anthonyceze]

Excellent job, you just gave me the best lecture and gift of the month...thanks a lot bro

[asaravana]

Very insightful information sir thank you now i am getting some clarity on this concepts

[akthar]

its a great video showing how the the context data is moved to a dimension table where a key is created in the dimension table and added to the fact table as a foreign key.
A question of concern, should i be doing that to flattened sql server table (the main raw data source) with over 10 million rows ? - this is how the data comes to us from another team - 1 single flat table s that needs to split into several fact tables and dimensions.
As I plan to do all etl in the sql server, should i materialise the fact and dimension tables (create physical static tables ) or just create views ?
Should i be creating the key in the dimension table or view and then updating it or joining it to the fact table ? The processing may become a little too much for the Azure sql server capacity ?
I hope my question is not too confusing . Thanks you

[fahadamir]

superb brother, MashaAllah you did a great job its really helpful

[ishneetsinghcheema]

You are the mannn!! Thanks so much. Wish you all the best for futures releases.

[sidharthmandal]

Hey man, really loved this tutorial. Learned a lot. Can i have the data set plz? I want to have handson on it.