Excel Power Pivot Tutorial

Excel Power Pivot Tutorial

Excel Power Pivot is an efficient, powerful tool that comes with Excel as an Add-in. With Power Pivot, you can load hundreds of millions of rows of data from external sources and manage the data effectively with its powerful xVelocity engine in a highly compressed form. This makes it possible to perform the calculations, analyze the data, and arrive at a report to draw conclusions and decisions.

This guide targets professionals with hands-on experience with Excel, to perform the highend data analysis and decision making in a matter of few minutes.

Before you proceed with this tutorial, we are assuming that you are already aware about the basics of Excel. If you are not well aware of these concepts, then we will suggest you to go through our short tutorials on Excel charts and MS Access.

Table of Contents

Excel Power Pivot - Overview
Excel Power Pivot - Installing
Excel Power Pivot - Features
Excel Power Pivot - Loading Data
Excel Power Pivot - Data Model
Excel Power Pivot - Managing Data Model
Excel Power PivotTable - Creation
Excel Power Pivot - Basics of DAX
Excel Power Pivot - Exploring Data
Excel Power Pivot - Flattened
Excel Power Pivot Charts - Creation
Table and Chart Combinations
Excel Power Pivot - Hierarchies
Excel Power Pivot - Aesthetic Reports