Microsoft® PowerPivot for Excel® 2010: Give Your Data Meaning (Business Skills)

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 booktech@oreilly.com.

• Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016
• PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library)
• The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills)
• Microsoft Excel 2010 Data Analysis and Business Modeling (Business Skills)
• Microsoft Excel 2013 Building Data Models with PowerPivot (Business Skills)
• Learn to Write DAX: A practical guide to learning Power Pivot for Excel and Power BI
• Tabular Modeling in Microsoft SQL Server Analysis Services (Developer Reference)
• PowerPivot Alchemy: Patterns and Techniques for Excel
• Excel 2010 Power Programming with VBA
• Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library)