Why use SSAS Tabular when we have Power BI?

Managers, analysts, engineers and information workers, who use it, know that SQL Server Analysis Services Tabular (SSAS Tabular) is a valuable ICT asset. On the other hand, Power BI (PBI) is a great tool too that has a bit more functionality under its belt. Yet, there are cases where SSAS Tabular might prove useful which […]

Don’t fool mama Natalie!

Steve is a 14-year old, clever, young man, one of the cool guys at school. He always keeps his mobile phone at hand. As a matter of fact, he has a black belt in texting. Steve texts as soon as he’s awake. No doubt he has to address dozens of friends and girlfriends informing him […]

Four special members make your data warehousing more universal

Not everybody tends to display data warehouse information in the same way. This is why we have created four so-called special dimension members to avoid confusion and establish some uniform ground rules. Do you want to jog your memory on data warehouses, dimensions or fact tables? Be sure to read my previous blog on it, […]

Sint-Rembertziekenhuis werkt slimmer door beter te rapporteren

Als je naar het ziekenhuis gaat voor een behandeling, wil je weten hoe lang je er zal moeten blijven en hoeveel het zal kosten, niet alleen om je mentaal, maar ook praktisch te kunnen voorbereiden. Ook het ziekenhuis wil dit weten om de capaciteitsplanning, het dienstrooster en de financiële planning te kunnen inschatten. Het Sint-Rembertziekenhuis […]

How to create a date table in PowerPivot with one single value

Calculations that make comparisons to previous quarters or to the same period one year ago are very important in all business intelligence tools. DAX, the formula language in PowerPivot, allows you to define such calculations by means of Time Intelligence Functions. However, in order to use these, you need to include a Date dimension table […]

Your first data warehouse model

A data warehouse is a relational database just like any other relational database. However, the database model is designed in a different way. It should facilitate business users querying large amounts of data, but also let them explore the data from different points-of-view by means of BI applications. Six steps will guide you through the […]