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...
Deepen your knowledge
Knowledge Base
ETL Explained — Extract, Transform, Load in plain language
What is ETL? Learn how Extract, Transform, and Load works, the difference with ELT, and which tools to use. Clearly expl...
Knowledge BaseData Lakehouse Explained — The best of both worlds
What is a data lakehouse and why does it combine the best of data warehouses and data lakes? Architecture, comparison, a...
Knowledge BaseWhat is Power BI? Everything you need to know
Discover what Microsoft Power BI is, how it works, what it costs, and why it's the world's most popular BI tool. Complet...