What is PowerPivot:
PowerPivot is an add-in for Excel 2010 / 2013.
PowerPivot is an in memory Analysis Services.
Once you have your Data warehouse ready, we can use PowerPivot to browse the data in a Cube fashion.
The data sources can be heterogenous...means the data can come for any type of data sources and we can create the relationships in PowerPivot and slice and dice the data( like Analysis Services Cube).
Download:
You can download PowerPivot from Microsoft website
http://office.microsoft.com/sites/preview/en-us/excel/download-powerpivot-HA101959985.aspx
Requisites:
Excel 2010
Office 2013 Pro Plus
Office 365 Enterprise
SharePoint 2013 Enterprise
SharePoint Online 2013 Plan 2
PowerPivot is an add-in for Excel 2010 / 2013.
PowerPivot is an in memory Analysis Services.
Once you have your Data warehouse ready, we can use PowerPivot to browse the data in a Cube fashion.
The data sources can be heterogenous...means the data can come for any type of data sources and we can create the relationships in PowerPivot and slice and dice the data( like Analysis Services Cube).
Download:
You can download PowerPivot from Microsoft website
http://office.microsoft.com/sites/preview/en-us/excel/download-powerpivot-HA101959985.aspx
Requisites:
Excel 2010
Office 2013 Pro Plus
Office 365 Enterprise
SharePoint 2013 Enterprise
SharePoint Online 2013 Plan 2
Here is a screenshot of a PowerPivot report.
We are going to walk through the process in the following video:
Intro:
We are going to walk through the process in the following video:
Intro:
Step By Step:
No comments:
Post a Comment