Category: Data Modeling

No Premium - no problem! What do you do if client asks for performance optimization, and there are no premium features available? You improvize and...

23 Jan

Data Modeling Mastering DP-500 Power BI

Mastering DP-500: Performance Tuning of Power Query and Data Sources

by Nikola

No Comments

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...

18 Dec

Data Modeling DAX Power BI T-SQL

Looking through the WINDOW – Calculating customer lifetime value with new DAX functions!

by Nikola

3 Comments

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...

01 Dec

Data Modeling Mastering DP-500 Power BI

Power BI Dataflows -Everything you need to know!

by Nikola

5 Comments

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!

23 Oct

Data Modeling Mastering DP-500 Power BI

Mastering DP-500: Identify Data Loading Bottlenecks in Power BI!

by Nikola

No Comments

Slow data refresh process? Check this article to learn about the most common bottlenecks in the data refresh workflow!

14 Aug

Data Modeling Mastering DP-500 Synapse Analytics T-SQL

Mastering DP-500 Exam: Dedicated vs Serverless SQL in Synapse – Which should I use?!

by Nikola

2 Comments

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...

10 Aug

Data Modeling Power BI

Finding the right PATH – Understanding parent-child hierarchies in Power BI!

by Nikola

No Comments

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