Excel Power Query
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.
$595 per Student
8 CPE Credits
- 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
1 Day
- What is Power Pivot, Power Query, Power View and Power Map
- The Power Suite Workflow
- Power Query Examples
- Power Pivot Examples
- Power View Examples
- 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
- Basic Data Transformations
- Text Data Transformations
- Number Data Transformations
- Date Data Transformations
- Indexes and Conditional Columns
- Grouping and Summarizing Data
- Transposing Data
- Pivoting and UnPivoting Data
- Updating Workbook Queries
- Combining Multiple Queries
- Appending Queries
- Utilizing a Folder of Data Files
- Columns From Examples
- Custom Columns
- M Language Overview
- Parameters in Power Query
- Maintaining Parameters
- Custom M Function Overview
- Custom M Functions with Parameters
- Custom M Functions using Advanced Editor
- Grouping Queries
- Query Dependency View
Excel Power Query Schedule
In-Person Classes Schedule
Date | Location | Price | Registration |
Live Online Classes Schedule
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.
Public Classes
Contact Us
Phone
817-841-9560
Office Address
2601 Scott Avenue
Suite 107
Fort Worth, TX 76103
Mailing Address
Aledo, TX 76008