Microsoft PowerPivot for Excel 2010: Give Your Data Meaning

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.

Written by -
Get the book      Sample Chapters      Companion Content

The “Ferrari” of PowerPivot Books

Rob Collie (Dec 12, 2012):

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.

Excellent Professional Resource

An Amazon customer (Sep 7, 2012):

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.

Get the book

North America United States
South America Brazil
Europe United Kingdom
The Netherlands
Asia China
Oceania Australia
Other countries

 Enclose code in comments with <PRE></PRE> to preserve indentation.