Alberto Ferrari wrote an interesting post about a “different approach” in creating a ranking measure with PowerPivot. If you know DAX or you read our book, you will find that a DAX expression can solve the issue. However, such a…  Read more

I and Alberto Ferrari will present a DAX Deep Dive training day at SQLBits 9 in Liverpool, on September 29th. The conference will continue on September 30th and October 1st. Registrations are not yet open, but you should definitely save…  Read more

On January 18th, 2012 at 12pm Eastern Time (which is 5pm GM) Alberto Ferrari will deliver a free online session for the PASS DW/BI Virtual Chapter. This is the official description of the session. Many-to-Many Relationships in DAX The introduction…  Read more

It has been a long wait, but finally our book about Analysis Services Tabular is available! Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model Amazon is already shipping it in US and it should be available soon also…  Read more

I and Alberto started a collaboration with Rafal Lukawiecki and we will publish video tutorial on the Project Botticelli web site. The first video is already available: DAX in Action shows you how the power of DAX in PowerPivot solving…  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

Apparently Excel does not offer a way to import data in Excel by using a DAX query on Analysis Services. The Data Connection Wizard seems to offers only the ability to create a PivotTable when you connect to Tabular, but…  Read more

Our new book about PowerPivot 2013 is finally available in printed edition, too! The title is Microsoft Excel 2013: Building Data Models with PowerPivot and it is a partial rewriting of the previous book about PowerPivot for Excel 2010. In…  Read more

On April 23 I will present DAX in Action in London and Cardiff at SQLLunch event.How is it possible I will be in two places at the same time?This will be a remote presentation delivered in two locations, where you…  Read more

Alberto Ferrari recently recorded a free short video introduction about what is time intelligence. When you have to perform time-related calculations in Power Pivot or in Analysis Services Tabular, you have to rely on some DAX expressions. There are specific…  Read more