PowerPivot: Powerful Data Analysis and Data Modelling in Microsoft Excel

With PowerPivot, Microsoft brings the dynamism of Business Intelligence tools to Excel, transforming enormous amount of data/records into meaningful information. It helps to generate rich and interactive analysis solutions. It is an extension to things you already know about Excel and it comes FREE with the software (Excel 2010 and above).

• Data from Different Sources: With PowerPivot, you can import data virtually from any data source e.g. from SQL Server, XML and even web based data. These mixed and mashed up data from different data sources are combined. Relationships of data from these different data sources can be easily be created and be generated into a single report or a data model. There is no need to use any Excel Functions e.g. VLookup to `join’ these data.
• Large Volume of Data: Microsoft Excel 2010 has a maximum of about 1 million rows of data. PowerPivot can store and process unlimited capacity of data.
• Create Visually Appealing Analytical Models: Analysis will be made easier by presenting the output in variety of visual forms. You can present your data in PivotTable and PivotCharts. PowerPivot allows further enhancement of data analysis into Business Intelligence Dashboards.
• Use the powerful new analytical capabilities, the Data Analysis Expressions (DAX)

In this training you will learn:

• Introduction to PowerPivot
• Load Data into PowerPivot
• Table Relationships
• PowerPivot Windows
• Calculated Column
• PivotTables
• Create Measures (DAX)
• Case Study