Multiple Stars in a Star Schema
Power BI developers learn that a star schema is the optimal data model design for usability and performance. However, seeing an ideal “star schema” with … Read More
Category: Data Modeling
In Power BI, Normalizing a Dimension is (NOT) Crucial for Usability and Performance
Okay, Power BI community, we have a problem. 80+ votes is already enough to confirm that we indeed have a problem. “In Power BI, normalizing … Read More
Power BI data modeling/data visualization tip: When you need a ‘chimera’, create it!
➡ Do not hesitate to append (do not merge) data with different granularity/different facts into a single table. You’ll need a column that identifies what … Read More
What is more important? Data (ETL, data modeling) or data visualization?
⚠ The visual part of business report development is often heavily underestimated (by developers and their customers – business users). Data preparation is important; data … Read More
Power BI report to analyze city (property, grocery store etc.) neighbors
In this post I want to show an example of a report that uses hierarchy bridge in the data model with recursive hierarchy. If you … Read More