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’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®.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O’Reilly Media’s Digital Distribution services. To download this content, please visit O’Reilly’s web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [email protected].

Table of Contents

Chapter 1: First Steps with PowerPivot
Chapter 2: PowerPivot at Work
Chapter 3: Introduction to DAX
Chapter 4: Data Models
Chapter 5: Loading Data and Models
Chapter 6: Evaluation Context and CALCULATE
Chapter 7: Date Calculations in DAX
Chapter 8: Mastering PivotTables
Chapter 9: PowerPivot DAX Patterns
Chapter 10: PowerPivot Data Model Patterns
Chapter 11: Publishing to SharePoint
Appendix: DAX Functions Reference