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

YouTube

PowerPivot - A Cool Reporting Tool

PASS Data Community Summit via YouTube

Overview

Explore the future of self-service reporting with PowerPivot in this comprehensive conference talk from PASS Data Community Summit. Learn how to leverage the PowerPivot add-in for Excel 2010 to combine diverse data sources and deliver powerful analytics. Discover techniques for integrating Analysis Services cubes, TSQL queries, stored procedures, Excel spreadsheets, flat files, Microsoft Access databases, and web data to create advanced PivotTables and PivotCharts. Overcome Excel's row limitations, utilize refreshable data sources, and experience the lightning-fast performance of the VertiPaq engine. Walk through the process of importing data, creating pivot tables and charts, implementing "slicers," and exploring relationships between data sources. Gain valuable insights into how PowerPivot can revolutionize data exploration and self-service business intelligence for you and your organization's end users.

Syllabus

PowerPivot - A cool reporting tool!

Taught by

PASS Data Community Summit

Reviews

Start your review of PowerPivot - A Cool Reporting Tool

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.