Star Schema versus Snowflake voor semantisch model

Samenvatting

Reading about PowerBI and optimising semantic model and I under the product is optimised for a Star schema design for the semantic model which makes sense in most cases. However, some of our heaviest reporting is around sales where we have a hierarchy of Company -> Region -> Area -> Branch with dimension tables for each. Naturally I'd lean towards a snowflake schema for that to build the hierarchy and all the slicers for Company, region, area, etc work as expected. When I've tried swapping to...