Develop a Power BI Data Model | Dimensional Modeling concepts and practices | Part 2
The data models developed in the Power BI Desktop are at the center of Power BI service. They expose the curated datasets to support the data exploration and drive the analytic. We develop visuals and reports and dashboards to deliver insights throughout the organization. In this tutorial we cover how to develop a data model in the Power BI. We cover the concepts of dimensional modelling and put these concepts into practice.
Link to GitHub: https://github.com/hnawaz007/PowerBIA...
Link to previous video: • What is Power BI? Power BI Architectu...
Subscribe to our channel:
/ haqnawaz
-----------------------------------------
Follow me on social media!
GitHub: https://github.com/hnawaz007
Instagram: / bi_insights_inc
LinkedIn: / haq-nawaz
-----------------------------------------
#powerbi #datamodeling #datamodel
Topics covered in this video:
0:00 - Introduction to Data Model
0:25 - Data Modelling Concepts
1:22 - Fact Table
2:16 - Dimension Table
2:36 - Primary & Foreign Keys
2:59 - Table relationships
3:56 - Power BI Data Model Workflow
4:33 - Data Model Overview & Relationships
6:08 - Active vs Inactive Relationships
7:20 - Model Role Playing Dimensions
9:23 - Denormalization - Combine multiple tables
12:24 - Denormalization using M Language