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

Passion Driven Statistics
Wesleyan University via Coursera Machine Learning With Big Data
University of California, San Diego via Coursera Big Data - Capstone Project
University of California, San Diego via Coursera Data Science at Scale - Capstone Project
University of Washington via Coursera Анализ данных: финальный проект
Moscow Institute of Physics and Technology via Coursera