Transform your skills, data, and business—with the power user’s guide to PowerPivot for Excel. Led by two Business Intelligence (BI) experts, you will learn how to create and share your own BI solutions using software you already know and love: Microsoft Excel.
Discover how to extend your existing skills, using the PowerPivot add-in to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required.
The book introduces you to PowerPivot functionality and 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, and then share your results effortlessly across your organization using Microsoft SharePoint.
Buy the book
» Download Sample Chapters
Excellent Professional ResourceA user wrote:
This is simply the best book out there to understand the great power that is behind this tool. If you take short time to sit down and read it, it can save you endless hours of work and thousands of dollars – not to mention an enhanced understanding of databases.
Yes, there are some parts that take a little work to follow, but its worth it trust me. I ‘ve read all the other books – many are good – but if I had to choose one, this is it.
It is now required reading for all my staff and coworkers. It saves time, money and allows us to do things we were never able to do before.» Read more
The “Ferrari” of PowerPivot BooksRob Collie wrote:
When I decided to dive into DAX shortly thereafter, it wasn’t long before I discovered Marco Russo. That name was familiar to my colleagues on the Analysis Services team, as he and Alberto Ferrari (and Chris Webb) had long been recognized as elite authorities and authors on Analysis Services.
… On net, I’d recommend this book to one of two audiences: BI/SQL pros starting their PowerPivot journeys from scratch, and Excel/SharePoint pros who have read one or both of the other books (or have a decent amount of hands on experience already) and are ready for some more advanced techniques.» Read more