Classroom Instructor Led Microsoft Excel Training 817-841-9560

Excel Power Query

Overview

Power Query is a data connection technology that comes with Excel that enables you to discover, connect, combine, and refine data sources to meet your analysis needs. Features in Power Query are available in Excel and Power BI Desktop. With Power Query you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs. Once you’ve shaped your data, you can share your findings or use your query to create reports. This class is designed to teach Power Query from the ground up and assumes you have not used Power Query in the past. Once we have covered the foundational topics of Power Query, then we will move on to the Power Query M language (code) that is used to create queries in Power Query.

Price

$595 per Student

 

CPE Credits

8 CPE Credits

Who this course is for
  • New to Power Query or never been formally trained in Power Query
  • Users who utilize often the VLOOKUP and INDEX/MATCH Functions
  • People performing Data Analytics in Excel, Power Pivot, Power BI, Tableau, Python, R
  • Business Intelligence Specialists using Excel, Tableau, Power Pivot, Power BI, Python, R
  • Data Analysts / Financial Analysts using Excel, Tableau, Power Pivot, Power BI, Python, R
  • If you or your team needs to fetch data from different sources and transform it so that it can be used in Excel for further analysis, then this course will help you master Power Query features from scratch
  • IT specialists who performs Extract Transform & Load (ETL) activities for business
Duration

1 Day

Class Outline
Power Suite Overview
  • What is Power Pivot, Power Query, Power View and Power Map
  • The Power Suite Workflow
  • Power Query Examples
  • Power Pivot Examples
  • Power View Examples
Data Loading Options
  • Common Usage Patterns
  • Load to a Table
  • Load to a Pivot Table
  • Load to a Pivot Chart
  • Only Create Connection
  • Add to the Data Model
Standard Transformations
  • Basic Data Transformations
  • Text Data Transformations
  • Number Data Transformations
  • Date Data Transformations
Advanced Transformations
  • Indexes and Conditional Columns
  • Grouping and Summarizing Data
  • Transposing Data
  • Pivoting and UnPivoting Data
Merging, Appending, and Updating Queries
  • Updating Workbook Queries
  • Combining Multiple Queries
  • Appending Queries
  • Utilizing a Folder of Data Files

 

Custom Columns
  • Columns From Examples
  • Custom Columns
M Language and Advanced Query Editor Concepts
  • M Language Overview
  • Parameters in Power Query
  • Maintaining Parameters
  • Custom M Function Overview
  • Custom M Functions with Parameters
  • Custom M Functions using Advanced Editor
Query Organization and Dependencies
  • Grouping Queries
  • Query Dependency View

Excel Power Query Schedule

In-Person Classes Schedule
No Events
Date Location Price Registration
Live Online Classes Schedule
No Events
Date Location Price Registration

Don't see a Class Date that works for you?

Let us know when you would like to take the class and we will see if we can add a new class date to our schedule.

Contact Us

Phone

817-841-9560

Office Address

2601 Scott Avenue
Suite 107
Fort Worth, TX 76103

Mailing Address

PO Box 712
Aledo, TX 76008

Communication Preference

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.