PowerPivot in Excel 2010

PowerPivot in Excel 2010

Below i will show to create a Pivot Table Report Using PowerPivot in excel.This is just a simple Report.

The Reason of using Power Pivot is it extends the capabilities of the PivotTable data summarisation and cross-tabulation feature with new features such as
expanded data capacity, advanced calculations, ability to import data from multiple sources, and the ability to publish the workbooks as interactive web applications.

Below are the steps of creating Power pivot Report in Excel

Open excel 
PowerPivot Tab
PowerPivot Window
--This will open a new window
Here we will create a report using SQL Database

-Select from Database
-ServerName
DatabaseName
-Next(screenshot)

-Here you wll get two options

-Select a list of Tables
-Write Query that will specify data to import

-So i will select from table
-next
-select table --you can select multiple table and can link them
--IT will create a Report for you with selected Table
Now click on pivot table
and insert a pivot table
In the Right hand side you will see pivot table fields

--YOu can add the column which you want to display in Report also you can add Slicer Directly like in the screenshot.

This is just a sample report so that anyone can get started with Powerpivot you can create Dashobards and many Complex reports using PowerPivot.