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

Go to class Write review

Overview

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