Forum Discussion
powerbiexpert22
Impactful Individual
Impactful IndividualSnowflake schema
i need to convert snowlfake schema into star schema, the only way i can think is by denormalizing tables however i am not sure which tables i should consider for denormalization, also is there any ot...
Prince0011
Solution Sage
Solution SageHi,
Denormalizing is the right approach, snowflake to star is basically collapsing sub-dimension chains into their parent table.
To pick candidates, look for dimensions that only exist to normalize another dimension, no fact table relates to them directly. Product → Category → Subcategory chains are classic examples, collapse into one Product table with those as columns.
Keep tables separate if they're genuinely reused across multiple fact tables independently.
Do the merges in Power Query, join sub-dimensions into parents, then drop the redundant tables.
If this helped, feel free to give it a kudos or mark it as solution, helps others find it too.