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

Creating Dashboards in Google Spreadsheets
Coursera Project Network via Coursera Подготовка и анализ данных в Tableau
Moscow Institute of Physics and Technology via Coursera Foundations of Data Analytics
The Hong Kong University of Science and Technology via edX Assessment for Data Analysis and Visualization Foundations
IBM via Coursera Data Analytics for Decision Making
Queen Mary University of London via FutureLearn