Learning Objective

Power Query is a data analysis feature available in Excel that allows you to discover, combine, and refine data.

Power Query enables users to search for and import data from a wide variety of different sources and types.

In this one-day class, you will learn how Power Query can make your work easier.

Prerequisites

Have completed the Intermediate Excel and Power Pivot training.

Target audience

This course is intended for users who are already familiar with Excel and Power BI and who need to import data into a worksheet.

Content

Power Query and when to use it / Data sources

• Connect to a web data source
• Connect to a worksheet
• Connect to a database
• Add a data source from a Wikipedia page

Data organization

• Create repeatable processes to filter, clean, aggregate, and transform your data
• Shape data in the table of contents
• Remove other columns to display only the columns of interest
• Replace values to clean up the values in a selected column
• Filter values in a column

Query

• Name a query
• Load the query into a worksheet
• Share queries and their data with other users in your organization

Resolve common issues

Power View

• Create a Power View report
• Add tabular data and charts
• Cards and Tiles
• Scatter and Bubble charts
• Play Axis

Duration :
Note :

NEXT DATE(S)