Overview
Explore the capabilities of SQL Server PowerPivot in this comprehensive conference talk. 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 analytics 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 extended functionality provided by 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 a combination of theory, demonstrations, and discussion, gain insights into effectively leveraging these add-ins for your own data analysis requirements.
Syllabus
End-to-End SQL Server PowerPivot - Peter Myers
Taught by
PASS Data Community Summit