Category: SSAS
21
Jul
Data Modeling for Mere Mortals – Part 2: Dimensional Modeling Fundamentals
by Nikola
4 Comments
Do you know what is PROBABLY the best data model in business intelligence world? Curious to learn 4-step dimensional design process? This article will provide...
29
Jun
Hidden little gem that can save your (Power BI) life!
by Nikola
3 Comments
Power BI is full of hidden gems! This one can literally make you a real Power BI hero out of nowhere!
09
Jun
Mastering DP-500: Power BI XMLA Endpoints Demystified!
by Nikola
No Comments
There were many "game-changers" during the Power BI evolution! XMLA Endpoint availability is definitely one of Top 3 of all the time!
02
Feb
Hybrid tables in Power BI: extending beyond time-related scenarios!
by Nikola
2 Comments
Hybrid tables are one of the most powerful features in Power BI! And, it's not (just) about separating "hot" and "cold" data...You can basically leverage...
22
Jun
What is a Power BI Desktop mode and what does it tell you?
by Nikola
No Comments
Have you ever wondered what does Power BI Desktop "tells" you with a short message in the bottom right corner? Let's find out!
31
Mar
Power BI – How to fit 200 million rows in less than 1GB!
by Nikola
15 Comments
Extraordinary tasks request extraordinary solutions! Check how to pack 200 million rows in 18 MB of Power BI!
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...
24
Feb
Partitioning – why you need to consider it
by Nikola
No Comments
Partitioning can save you lot of time and resources, if handled with care.
05
Feb
Kill stuck SSAS Cube Processing
by Nikola
2 Comments
Sometimes your cube processing can stuck in the middle of nowhere. But, there is a solution other than restarting Analysis Services.
16
Jan
Time Intelligence in SSAS
by Nikola
No Comments
Time Intelligence gives your multidimensional data model much more power and flexibility