The adoption of DAX is slowly growing and we can see that from comments to article, blog posts, web site traffic (including DAX Formatter usage). For this reason, the demand for more advanced training about DAX is also increasing. We…  Read more

If you think that the end of the year would have been a quiet time because the Power BI team will skip their monthly release (but are we sure?), you might be reassured (or disappointed depending on your perspective) looking…  Read more

First of all, a praise to Ralph Kimball: in the last days I read for the second time his The Data Warehouse Toolkit and this second read has been very inspiring to me. This time I’ve had the perspective of Analysis…  Read more

Next week I will finally start the roadshow of the SSAS Tabular Workshop, a 2-day seminar about the new BISM Tabular model for Analysis Services that has been introduced in SQL Server 2012. During these roadshows, we always try to…  Read more

SQL Server Analysis Services is a product that does not have its own product code, being sold as part of SQL Server. I think that also Microsoft does not know (and cannot know) the exact number of users. For this…  Read more

This is a tool I would have mentioned in the Expert Cube Development with Microsoft SQL Server 2008 Analysis Services book I wrote last year. Unfortunately, the ResMon sample cube has been published just a few days before PASS Summit…  Read more

This year is going to end, Maya failed their predictions and while this is bad for predictive industry, it’s also good for all of us! We’ve seen many news in Microsoft BI stack: Excel 2013 has been RTM’d – its…  Read more

With the release of Microsoft SQL Server 2016, there are several options to use Analysis Services Tabular. SQL Server Standard: it includes Analysis Services Tabular, and it is available in two licensing models: Server + Client Access License (CAL) and…  Read more

Reference dimensions let you create a relationship between a measure group and a dimension using an intermediate dimension to act as a bridge between them. In the Adventure Works demo, for example, they are used to link reseller sales and…  Read more

Following my last post about parent/child hierarchies in PowerPivot, I worked a bit more to implement a very useful feature of Parent/Child hierarchies in SSAS which is obviously missing in PowerPivot, i.e. unary operators. A unary operator is simply the…  Read more