Excel – Data Analysis with Power Pivot
5 Based on 213 reviews- 157,109 Learners
- 287 Courses
Upcoming Class Schedule
$148.00
Oct 13 - Oct 13, 2026
9:00 AM - 12:30 PM America/New_York- VILT
- Dec 16 - Dec 16, 2026
- 9:00 AM - 12:30 PM America/New_York
- VILT
Upon successful completion of this course, you will be able to use Power Pivot along with Excel to analyze data from a variety of sources. You will:
- Get started with Power Pivot.
- Visualize Power Pivot data.
- Work with advanced functionality in Power Pivot.
Prerequisites for Excel – Data Analysis with Power Pivot Course
Excel – Data Analysis with Power Pivot Course Outline
- Enable and Navigate Power Pivot
- Manage Data Relationships
- Create a Power Pivot Report
- Create Calculations in Power Pivot
- Create a Key Performance Indicator
- Work with Dates and Time in Power Pivot
Resources
FAQs on Excel – Data Analysis with Power Pivot
You will learn to enable and navigate Power Pivot, manage data relationships, create Power Pivot reports and calculations, build Key Performance Indicators, and work with dates and time functions in Power Pivot to analyze data from multiple sources.
Participants should have completed Excel – Part 1 & Part 2 or have equivalent experience with Excel before enrolling in this course.
This course is designed for Excel users who want to enhance their data analysis skills using Power Pivot to work with large datasets, create relationships between data sources, and build advanced calculations and reports.
The course covers three main areas: Getting Started with Power Pivot (enabling and navigation, data relationships), Visualizing Power Pivot Data (reports and calculations), and Working with Advanced Functionality (KPIs and date/time functions).
You will gain hands-on skills in setting up Power Pivot, linking data from various sources, creating meaningful visualizations and reports, building custom calculations, developing KPIs, and effectively handling date and time data for advanced analysis.