Data Mozart
Data Mozart

Category: Data Modeling

11 Jul
Data Modeling Data Visualization DAX Power BI TIQ

TIQ Part 4 – Being Time intelligent

by Nikola
2 Comments
In the final part of TIQ series, learn what is Time Intelligence, and neat differences between various DAX Time intelligence functions
06 Jul
Data Modeling Data Visualization DAX Power BI

Use aggregate functions on rows in Power BI

by Nikola
8 Comments
Using aggregate functions on columns is fine, but doing same on rows is - pure beauty! And all this with a single line of DAX...
04 Jul
Data Modeling Data Visualization DAX Power BI TIQ

TIQ Part 3 – Ultimate Guide to Date dimension creation

by Nikola
3 Comments
In third part of TIQ series, learn all available methods for creating proper Date dimension in Power BI
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
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
31 May
Data Modeling Data Visualization Power BI

Display Totals in Stacked Column chart

by Nikola
No Comments
Bug or a "feature"? Whatever it is, use this simple trick to achieve common request in Power BI
28 May
Data Modeling Databases Relational Databases SQL Server T-SQL

Datetime2 – Why you should (not) use it

by Nikola
5 Comments
Choosing right data type is not so straightforward as you might think at first sight
21 May
Data Modeling Data Visualization DAX Power BI

Drillthrough like a PRO in Power BI

by Nikola
No Comments
Use dynamic formatting of the buttons to create awesome user experience for your Power BI reports
29 Apr
Data Modeling Data Visualization DAX Power BI

Override date filter in Power BI

by Nikola
2 Comments
Overriding standard date filtering can be trickier than you can imagine