PowerPivot is a free new add-on for Excel 2010 that is used to enhance pivot tables and pivot charts. PowerPivot brings self-service business intelligence to the desktop by allowing you to connect to a variety of data sources. This functionality is used to enhance data analysis in Excel. The purpose of PowerPivot for Excel is to help Excel end users access data in multi-dimensional databases without having extensive training and knowledge of this type of data modeling.
Additionally, PowerPivot has a new programming language called Data Analysis Expressions (DAX). This language adds data manipulation functionality to Excel formulas, including analysis and complex grouping that is above the formula capabilities that are available in Excel. DAX takes the formulas that you are use to creating for pivot tables and pivot charts in Excel to a whole new level. In a user friendly, step-by-step way, you will learn the following: How to use the Table Import Wizard, How to import data into PowerPivot, How to create pivot tables and pivot charts using data in PowerPivot, How to create DAX formulas and much more.
show more show less