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 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.

Syllabus

End-to-End SQL Server PowerPivot

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.