Microsoft Excel 2013: Building Data Models with PowerPivot

Your guide to quickly turn data into results.

Transform your skills, data, and business—and create your own Business Intelligence (BI) solutions using software you already know and love: Microsoft Excel. In this book, two BI experts take you inside PowerPivot functionality for Excel® 2013, with a focus on real-world scenarios, problem-solving, and data modeling. You will learn how to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required!

  • Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI
  • Extend your existing data-analysis skills to create your own BI solutions
  • Quickly manipulate large data sets, often in millions of rows
  • Perform simple-to-sophisticated calculations and what-if analysis
  • Create complex reporting systems with data modeling and Data Analysis Expressions
  • Share your results effortlessly across your organization using Microsoft SharePoint®
Written by -
Get the book      Sample Chapters      Companion Content

Prepare to Master PowerPivot

Oleg Gvozdenko (Apr 25, 2013):

The book has both a technical edge of thorough, complex DAX scenarios with explanations of potential errors and why the errors occur, and a more conceptual side, which goes in some depth explaining Data Modeling and thinking in Evaluation Context terms.

It is THE book if you want to master PowerPivot.

Perfect book for the right audience

Student (Mar 31, 2013):

Overall, recommended if you are an excel pro who wants a single source book to learn about PowerPivot, DAX, PowerView, and data modeling in general.

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.