Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

End-to-End SQL Server PowerPivot

PASS Data Community Summit via YouTube

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

Reviews

Start your review of End-to-End SQL Server PowerPivot

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.