Introduction to PowerPivot
Session 1
PowerPivot, part of the SharePoint 2010 release, is a powerful in-memory engine that allows users to extract large amounts of data from multiple sources, including corporate databases, Excel spreadsheets and external sources, in a very quick & efficient way. It uses an in-memory, column-based storage to enable users to build models in self-service mode, “on the fly”, without having to pre-aggregate or build cubes prior to querying.
During this session you will learn main features & capabilities of PowerPivot and how Panorama extends the overall value of the this new in-memory platform.
Outline:
- PowerPivot overview
- Product goals
- Same set of tools for different data sources
- OLAP and in-memory platforms – the value of both
- Product architecture
- Enterprise scalability
- Open Platform vs. Proprietary
- PowerPivot and Analysis Services – do’s and don’ts
- Architecture discussion
- Vertipaq engine
- 64-bit
- Making PowerPivot enterprise ready with Panorama NovaView
- NovaView Architecture
- Data Level Security Layer
- Self-Service BI capabilities overview
- Complete BI suite, from ETL to data processing, to front-end applications
See Also: