Category: Data Modeling
Zip, Zip, Hurrah! Using Power Query to split multi-lined cells!
Power Query everything! Learn how to leverage List.Zip function to solve one of the most common data transformation challenges!
Dynamic filtering with Field parameters in Power BI!
Field parameters are amazing! Learn how to use this feature for data modeling purposes and enable users to have full flexibility in the way they...
Cache me if you can! Understanding different cache types in Power BI
Did you know that Power BI relies on two different cache types? In this article, we'll demistify how each of them works in real life
Power BI Hybrid tables for poor people!
No Premium - no problem! What do you do if client asks for performance optimization, and there are no premium features available? You improvize and...
Mastering DP-500: Performance Tuning of Power Query and Data Sources
Performance tuning is usually a complex and iterative process. This article provides an insight on the most common scenarios and how to leverage various concepts...
Looking through the WINDOW – Calculating customer lifetime value with new DAX functions!
New window functions are one of the most important enhancements to the DAX language ever! Learn how to leverage them to calculate a customer lifetime...
Power BI Dataflows -Everything you need to know!
What are Dataflows and how they fit into the big Power BI data modeling picture? This article will demistify everything about the Power BI dataflows!
Mastering DP-500: Identify Data Loading Bottlenecks in Power BI!
Slow data refresh process? Check this article to learn about the most common bottlenecks in the data refresh workflow!
Mastering DP-500 Exam: Dedicated vs Serverless SQL in Synapse – Which should I use?!
Which Synapse pool should I use in different business scenarios? If you've asked yourself this question, keep reading and by the end of this article...
Finding the right PATH – Understanding parent-child hierarchies in Power BI!
Different data source systems store the data in different ways! Parent-child hierarchies may be a decent challenge to solve in your data modeling workflow