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: Performance
Star Schema The Complete Reference
A data model is not a feature; it’s the core of a Power BI report. You can create a great report without using additional features … Read More
Power BI Report Refresh Performance Analyzer
To understand why a Power BI report refresh takes too much time, we can use SQL Server Profiler. SQL Server Profiler can be connected to … Read More
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
My YouTube Channel
Welcome to my YouTube channel. First video has been published. Subscribe to see the upcoming videos. [youtube video=”https://www.youtube.com/watch?v=7pFXZU9xNHs&list=PL6qbun6zBOG2d9Ui2iq4Rl6Rj6-TAXMry”]
Floral Cartogram – How Do We Govern Our World?
This data visualization was included into the World Data Visualization Prize 2023 poster longlist. The poster displays Worldwide Governance Indicators for 170 countries. Each flower … Read More
Backup/restore all calculation groups (workaround required for some visuals)
I needed to add a gantt chart into a report. I tried multiple visuals, but they didn’t work because they all require at least one … Read More
100% Stacked Column Chart – Bad and Good Charts in Power BI
One more pair of good and bad charts created in Power BI. Why the chart on the left is bad, it’s so colorful?! Color in … Read More
The Big Picture: How to Use Data Visualization to Make Better Decisions Faster
I’ve already read many data visualization books, including The Big Book of Dashboards. And I was expecting high quality book from Steve Wexler. But this … Read More