Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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.