Transform your skills, data, and business—with the power user’s guide to PowerPivot for Excel. Led by two business intelligence (BI) experts, you’ll 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, 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.
Buy the bookDownload Sample Chapters »
Rob Collie (powerpivotpro.com) said:
[...] 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. [...] My high level impression after reading the book jives with my expectations: it is, at times, quite a bit more advanced than those prior books, which is a good thing for my purposes. But it does NOT assume that you already know PowerPivot. The book starts from scratch just like the other two books. A good thing for the audience at large, for sure. The first few chapters flow a lot like the first few chapters in the other books. 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 the full review »