CREATE FACT & DIMENSION TABLES FROM A SINGLE DE-NORMALIZED TABLE
Create a NORMALIZED TABLE with Fact & Dimension Tables from a SINGLE DE-NORMALIZED TABLE using just POWER BI DESKTOP
Timestamps
0:00 Sample De-Normalized Table
0:19 Overview of Steps to create Dimension Tables
0:32 Creating Country Dimension
1:18 Creating rest of dimensions
2:34 Creating Date Dimension
3:03 Fact Table - Duplicating existing table
3:16 Fact Table - Adding Country Key using Merge Query
3:56 Fact Table - Adding other Foreign Keys
5:25 Close & Apply
5:55 Manage Relationships
6:15 Star Schema