Explore the capabilities of SQL Server PowerPivot in this comprehensive conference talk from PASS Data Community Summit. Dive into the Managed Self-Service BI pillar of SQL Server 2008 R2, focusing on the PowerPivot for Excel add-in and its ability to revolutionize data analysis in Excel 2010. Learn how to load and prepare large volumes of data from various sources to create multidimensional models, enrich them with sophisticated calculations, and use them as sources for PivotTable and PivotChart reports. Discover the additional features of the SQL Server PowerPivot for SharePoint add-in, including cataloging Excel workbooks with PowerPivot models in SharePoint and exposing them as data sources for other Excel and Reporting Services reports. Understand how IT can manage these SharePoint-hosted models with scheduled data refreshes from original data stores. Through theory, demonstrations, and discussion, gain insights into effectively leveraging these add-ins for your own data and analysis requirements in this 1 hour and 31 minute session.
Overview
Syllabus
End-to-End SQL Server PowerPivot
Taught by
PASS Data Community Summit