Category: Data Modeling
Mastering DP-500 Exam: Design and Build Composite Models!
Do you need to combine the data from multiple different Direct Query data sources? Or, mix imported data with DirectQuery? Composite models feature in Power...
Mastering DP-500 Exam – Design and Build a Large Format Dataset!
What is the recommended way to handle large datasets in Power BI? Check the list of "DOs" and "DON'Ts" before designing your Power BI solution!
Mastering DP-500 Exam: DAX variables, virtual relationships and iterators!
"DAX is simple, but not easy!" Let's see some of the DAX nuances needed to get you ready for passing the DP-500 exam!
Mastering DP-500 Exam: Creating Calculation Groups!
Calculation groups are one of the most powerful features to reduce the data model complexity and measure redundancy!
Mastering DP-500 Exam: External Tools in Power BI!
External tools provide additional functionalities and features, that will make your life as Power BI developer much easier!
In the Power BI whirlpool – understanding circular dependencies!
Circular dependency error is one of the most annoying things in Power BI data modeling! Learn why this is happening and how to avoid it
How I transformed Excel “monster” into Power BI “beauty”!
How would you call going from 380 tables in 18 Excel sheets, to one table on a single report page in Power BI?! Magic? Miracle?...
Hybrid tables in Power BI: extending beyond time-related scenarios!
Hybrid tables are one of the most powerful features in Power BI! And, it's not (just) about separating "hot" and "cold" data...You can basically leverage...
Cardinality – Your Majesty!
Do you know who is the biggest "enemy" for the optimal data model size? Meet the Cardinality, and learn how to boost the report performance...
Killing me softly…Bi-directional relationships in Power BI!
You've heard that bi-directional relationships are "evil"? Is it true? Check why it's not (100%) true and how to avoid potential "road to hell"