The book introduces you to PowerPivot functionality, then takes a pragmatic approach to understanding and working with data models, data loading, data manipulation with Data Analysis Expressions (DAX), simple-to-sophisticated calculations, what-if analysis, and PowerPivot patterns. Learn how to create your own, “self-service” BI solutions, then share your results effortlessly across your organization using Microsoft SharePoint®.

From the Author
We have been working with PowerPivot since its early releases and, as all the new products, it requires some training to be used to its full potential. We wrote a book for end users who want to master PowerPivot, providing many examples and patterns to solve the typical business problems, which sometimes require solutions that are not easy to implement. You will be able to use this book both as a quick reference for common patterns and to learn how PowerPivot works and how to model your data in the good way.

About the Author
MARCO RUSSO is a software consultant and trainer based in Italy who focuses on Windows development and Business Intelligence solutions, including data warehouse relational and multidimensional design. He is the coauthor of Introducing Microsoft LINQ and Programming Microsoft LINQ (Microsoft Press), along with several other books about Microsoft .NET and SQL Server Analysis Services.

ALBERTO FERRARI is a consultant and trainer for the BI development area with the Microsoft suite for Business Intelligence. His main interests are in the methodological approaches to the BI development and works as a trainer for software houses that need to design complex BI solutions.