Publishing data from Omniture to Sharepoint 2010 using Power Pivot slice and dice features

Just started a new project to create a dashboard using Power Pivot for MS-Office 2010 and integrate a dashboard in Sharepoint 2010. The data is again coming from Omniture API Soap calls.

PowerPivot is a free add-in to the 2010 version of the spreadsheet application Microsoft Excel. It extends the capabilities of thePivotTable data summarisation and cross-tabulation feature by introducing the ability to import data from multiple sources. As such, PowerPivot falls under Microsoft’s Business Intelligence offering, complementing it with its self-service, in-memory capabilities.

Prior to the release of PowerPivot, Microsoft relied heavily on SQL Server Analysis Services as the engine for its Business Intelligence suite. PowerPivot complements the SQL Server core BI components under the vision of one Business Intelligence Semantic Model (BISM), which aims to integrate on-disk multidimensional analytics previously known as Unified Dimensional Model, or UDM, with a more flexible, in-memory “tabular” model.

As a self-service BI product PowerPivot is intended to allow users with no specialised BI or analytics training to develop data models and calculations, sharing them either directly or through SharePoint document libraries.

 

Publishing data from Omniture to Sharepoint 2010 using Power Pivot slice and dice features