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®