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

Excel: Working Together with Power Query and Power Pivot

via LinkedIn Learning

Write review

Great Learning

Advanced Techniques in Data Visualization - Self Paced Online

Financial Edge

The Private Equity Associate Certification

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off

One annual plan covers every course and certificate on Coursera. 40% off for a limited time.

Get Full Access

Learn how to combine Power Query and Power Pivot, two robust features of Microsoft Excel, to analyze data.

Syllabus

Introduction

Getting the most out of your data
What you should know

1. Understanding Power Query and Power Pivot

How Power Query and Power Pivot work together

2. Using Power Query

Select your data
Prepare your query
Use a query to cleanse data
Enhance your query
Prepare data for Power Pivot

3. Using Power Pivot

Create your data model
Import additional data
Build relationships
Create lookups as new fields
Analyze data using PivotTables
Analyze data using PivotCharts

4. Using Power Query with Power Pivot

Scenario 1: Refresh source data
Scenario 2: Updating queries
Scenario 3: New reports
Scenario 4: New source data
Scenario 5: Finessing reports

Conclusion

Next steps

Taught by

Joshua Rischin

Reviews

4.7 rating at LinkedIn Learning based on 1296 ratings

Start your review of Excel: Working Together with Power Query and Power Pivot