Microsoft Excel 2013:
Building Data Models with PowerPivot

by Marco Russo & Alberto Ferrari - Microsoft Press
Microsoft Excel 2013: Building Data Models with PowerPivot

Transform your skills, data, and business—and create your own BI solutions using software you already know and love: Microsoft Excel.

Two business intelligence (BI) experts take you inside Power Pivot 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!

Your guide to quickly turn data into results

  • Understand the differences between Power Pivot 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 (DAX)
  • Optimize data models for navigation with PivotTable and Power View embedded in Excel
  • Share your results effortlessly across your organization using Microsoft SharePoint®




Previous course book:

PowerPivot for Excel 2010: Give Your Data Meaning

by Marco Russo & Alberto Ferrari - Microsoft Press
PowerPivot for Excel 2010: Give Your Data Meaning

Transform your skills, data, and business—with the power user’s guide to Power Pivot for Excel. Led by two business intelligence (BI) experts, you will 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 Power Pivot 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 Power Pivot functionality, and 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 Power Pivot patterns. Learn how to create your own, "self-service" BI solutions, and then share your results effortlessly across your organization using Microsoft SharePoint.

View on Amazon
Download sample chapters (pdf)

More than 10,000 readers can't be wrong!