When we prepared the material for the workshop (well, the slides and the demos, we already spent one year for the book) we discovered that two days are not enough to cover all the details. But there is enough time to cover many PowerPivot topics, starting from basic concepts and moving on up to complex data models and DAX formulas.

The target are Excel Power Users (Microsoft prefers to identify them as Information Workers), but this training is also useful for IT and BI professionals that are in charge of the data warehouse management of their company and need to understand how to provide support to analysts who need to extract data from PowerPivot.

Although focused on PowerPivot integration, the workshop does not cover all the SharePoint topics that are needed to install a SharePoint server. This would need a complete course by itself and should be targeted to a more technical audience.

The main goal of the course is to facilitate the use of PowerPivot in the real world.
It is designed for professionals who want to use PowerPivot full capabilities while, at the same time, it permits to identify those scenarios where its use might not be convenient.

This article describes how DAX automatically converts data types in arithmetic operations. These small details can cause and explain differences in results when using the same operations in other languages. Read more

This article describes how to use the detail rows expression of a measure to obtain the equivalent of creating table functions in DAX. This allows the reusing of a table expression in multiple CALCULATE filters. Read more