Data Mozart

Month: June 2020

27 Jun
Data Modeling Data Visualization DAX Power BI TIQ

TIQ Part 2 – Your Majesty: Date Dimension

by Nikola
No Comments
What is so special about Date dimension in Power BI data model? Find out in the second part of TIQ series
22 Jun
Data Modeling Data Visualization DAX Power BI TIQ

TIQ Part 1 – How to destroy your Power BI model with Auto Date/Time

by Nikola
4 Comments
In the first part of TIQ Series, find out why using Auto Date/Time is a bad idea
14 Jun
Databases SQL Server T-SQL

Azure Data Studio or SSMS – which should I use?

by Nikola
2 Comments
Azure Data Studio or SSMS? Why can't be Azure Data Studio AND SSMS? Check how you can take the best from both worlds
10 Jun
Data Visualization Power BI

Push Card visuals to a new level in Power BI

by Nikola
4 Comments
Bring new life to traditional Power BI visuals and learn how to achieve expand/collapse functionality with simple workaround
07 Jun
Data Modeling Data Visualization Power BI

Power Query tips for every Power BI Developer

by Nikola
2 Comments
Use these 3 powerful techniques to speed-up your Power BI development
05 Jun
Databases SQL Server T-SQL

How (not) to kill your SQL Server performance with implicit conversion

by Nikola
No Comments
Learn how to avoid performance killer and help SQL Server choose optimal execution plan for your queries