Category: Data Modeling
01
Oct
Mastering DP-500 Exam: Direct Query in Power BI – What, When & Why?
by Nikola
5 Comments
Everything you wanted to know about DirectQuery, but were afraid to ask! The ultimate guide to Power BI alternative for Import mode
22
Sep
Power BI 101 – Go, get’em, Sherlock! Doing Data Profiling like a PRO
by Nikola
3 Comments
Being a "data-detective" doesn't sound appealing to you? Check why you should reconsider your stance
17
Sep
Understanding Explicit vs Implicit measures in Power BI
by Nikola
8 Comments
Check important differences between implicit and explicit measures in Power BI data model, and why you should consider avoiding easier path
07
Aug
Period comparisons in Power BI
by Nikola
4 Comments
Comparison over different time periods in Power BI made easy!
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