Solving Snowflake Schemas

[1NoMansLand]

Hi All, are there any good tutorials for managing snowflafe schemas?

I'm currently reading an eBook - Exppert Data Modelling with Power BI, but the downloaded pbix file isn't connected to the Author's orighinal file path. Hence, am having some trouble following the tutorial on p49. So, in the absense of that. I thought I'd hunt down some clearer tuorials. Just wondering if anyone had any suggestions? 

In essence, Im working out how to deal with 'Merging' Product and SubProduct tables into one dimension table. 

Thanks.

[Anonymous]

Hi @1NoMansLand,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@1NoMansLand , refer if these can help

https://www.linkedin.com/pulse/can-we-convert-snowflake-schema-star-power-bi-ranjan-mohapatra

https://theexcelclub.com/easy-steps-to-convert-snowflake-to-a-star-dax-modeling/

https://www.youtube.com/watch?v=nY1iViroXBg

https://learn.microsoft.com/en-us/power-bi/natural-language/q-and-a-tooling-intro