Excel: Working Together with Power Query and Power Pivot

Offered By: LinkedIn Learning

Tags

Power Query Courses Data Analysis Courses Microsoft Office 365 Courses Data Modeling Courses Data Preparation Courses Data Cleansing Courses Power Pivot Courses PivotTables Courses PivotCharts Courses

Course Description

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

Related Courses

Problem Solving with Excel
PwC via Coursera Data Cleansing with Data Quality Services (DQS)
Microsoft via edX Data Analytics for Decision Making
Queen Mary University of London via FutureLearn Creating Dashboards in Google Spreadsheets
Coursera Project Network via Coursera Excel 2013 Tips and Tricks
LinkedIn Learning