Data Mozart
Data Mozart

Month: August 2022

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
1 Comment
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
06 Aug
Data Modeling Mastering DP-500 Mastering DP-600 Power BI

Mastering DP-500/DP-600 Exam: Optimize Data Model by using Denormalization

by Nikola
2 Comments
Not sure when to create redundant data in your Power BI model? Learn in which scenarios it makes sense to apply denormalization to increase the...
02 Aug
Data Modeling Mastering DP-500 Mastering DP-600 Power BI

Mastering DP-500/DP-600 Exam – Implementing Incremental Refresh!

by Nikola
7 Comments
Tired of slow and inefficient data refresh process? Learn how to leverage Incremental refresh feature to speed up and optimize the data refresh!