Course Information
Introduction to PowerQuery
Parking for SAO, Professional Development courses is in Garage B (1511 San Jacinto Blvd.). The Garage signage may read 1511 San Jacinto or Garage B. The elevator in Garage B is not reliable. If you are unable to walk the stairs, please contact the professionaldevelopment@sao.texas.gov for alternate parking arrangements. Handicapped parking is free at the meters around the downtown area.
A course coordinator will email you a parking permit prior to the course start date. A permit must be displayed or you will be ticketed.
Course Description
This course is designed to cover the fundamental and advanced aspects of Power Query for both Excel and Power BI users. We will cover data transformation, parameters, functions, and best practices. After completing this course, you will be able to use Power Query with confidence in either Excel or Power BI.
Course Objectives
Upon completion of this course, participants will be able to:
Overview of Power BI
Learn basic data transformation
Learn advanced data transformation
Learn parameters and functions
Learn best practices
Detailed Course Outline
Basic Data Transformation
Filtering and Sorting:
Basic filtering techniques
Sorting data in Power Query
Data Types and Type Conversions:
Data types in Power Query
Converting data types
Duplicates and Errors:
Identifying & removing duplicate values
Advanced Data Transformation
Merging & Appending Queries:
Combining data from multiple sources
Appending data tables
Grouping & Aggregating Data:
Grouping data for summary analysis
Aggregating functions in Power Query
Conditional & Custom Columns
Parameters & Functions
Introduction to Parameters:
Creating & using parameters
Dynamic data loading with parameters
Custom Functions in Power Query:
Creating and using custom functions
Parameterizing functions for reusability
Working with Date & Time
Date & Time Functions:
Extracting components of dates & times
Performing date and time calculations
Power BI & Power Query
Power BI Overview:
The Power BI Desktop interface
Importing & transforming data
Power Query in Power BI:
Leveraging Power Query within Power BI
Connecting to different data sources
Advanced Transformation Power BI
Query Folding
Query folding and its importance
Optimizing queries for performance
Final Project
Prerequisites
Basic knowledge of Excel and/or Power BI.
Instructors
With over 10 years of experience in data analysis and development, Steven Gotcher is passionate about transforming data into meaningful insights. He has a strong background in SQL, Tableau, Python, AWS, and Power Query, applying his skills across various domains. For the past 6 years, Steven has taught Business Intelligence platforms, delivering training grounded in real world Bl team use cases. His extensive focus on data transformation across multiple tools provides unique insights, making him an exceptional instructor. Steven empowers students to master the analytics workflow while fostering a collaborative learning environment that equips the next generation of data professionals with the skills needed to thrive in today's data-driven landscape.