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@example.com.