Category: Data Modeling
26
Jul
How to reduce your Power BI model size by 90%!
by Nikola
10 Comments
The final part of "Brain & Muscles" behind Power BI series, shows real-life showcase of data model optimization, and emphasizes general rules for reducing data...
21
Jul
Inside VertiPaq – Compress for success
by Nikola
4 Comments
In the 2nd part of "Brain & Muscles" behind Power BI series, learn about data compression and how VertiPaq chooses the right algorithm to make...
18
Jul
VertiPaq – “Brain & Muscles” behind Power BI
by Nikola
6 Comments
Have you ever wondered what makes Power BI so fast and powerful when it comes to performance? In the 1st part of the series, meet...
11
Jul
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
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
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
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
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
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
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