YoVDO

PowerPivot - A Cool Reporting Tool

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Business Intelligence Courses Data Analysis Courses Data Exploration Courses PivotTables Courses PivotCharts Courses

Course Description

Overview

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.

Syllabus

PowerPivot - A cool reporting tool!


Taught by

PASS Data Community Summit

Related Courses

Learn Excel 2016 Intermediate Level - Beyond the Basics
Udemy
Microsoft Excel - Improve your skills quickly
Udemy
Access 2016: Building Dashboards for Excel
LinkedIn Learning
Cert Prep: Excel 2013 Microsoft Office Expert Part Two (77-428)
LinkedIn Learning
Excel 2010: Pivot Tables
LinkedIn Learning