Power Query lets you import, clean, reshape and combine data in Microsoft Excel and Power BI without complex formulas or macros. This beginner-friendly 60-minute Power Query webinar explains the Extract, Transform and Load (ETL) process and what Power Query does behind the scenes.
You'll see how queries relate to source data and output tables, find your way around the Power Query Editor, and try the transformation techniques used most often in everyday reporting.
Practical demonstrations and real-world examples help you prepare clean, reliable datasets for analysis, so you leave with the core concepts you need to start using Power Query with confidence.
WHY SHOULD YOU ATTEND?
If you spend time each week or month cleaning spreadsheets, copying data between files or repeating the same preparation steps, Power Query offers a faster and more reliable way. It automates repetitive transformations, cuts manual errors and creates repeatable processes that improve data quality.
The session suits Excel users, business, financial, operations and other analysts, finance professionals, office administrators, and Power BI or BI beginners who prepare or clean data.
AREA COVERED
- Introduction to ETL concepts
- How Power Query works
- Source data vs query vs output tables
- Importing data with the Navigator
- Previewing data before loading
- Load vs Transform Data options
- Tour of the Power Query Editor
- Queries pane and Query Settings
- Applied Steps explained
- Managing data types
- Creating basic custom columns
- Merge vs Append explained
- Query dependencies
- Refreshing queries
- Connection Only vs loaded tables
- Close & Load options
- Beginner best practices and common mistakes
LEARNING OBJECTIVES
- Explain the Extract, Transform and Load (ETL) process
- Tell source data, queries and output tables apart
- Navigate the Power Query interface and import data with the Navigator
- Apply common transformations and see how Applied Steps record each one
- Choose and manage the right data types
- Distinguish Merge from Append operations
- Refresh queries when the source data changes
WHO WILL BENEFIT?
- Excel Users
- Business Analysts
- Data Analysts
- Reporting Analysts
- Financial Analysts
- Operations Analysts
- Sales Analysts
- Supply Chain Analysts
- HR Analysts
- Project Coordinators
- Finance Professionals
- Office Administrators
- Management Information (MI) Analysts
- Business Intelligence (BI) Beginners
- Power BI Beginners
- Professionals responsible for preparing or cleaning data in Excel
- Anyone new to Power Query who wants to automate repetitive data preparation tasks
If you spend time each week or month cleaning spreadsheets, copying data between files or repeating the same preparation steps, Power Query offers a faster and more reliable way. It automates repetitive transformations, cuts manual errors and creates repeatable processes that improve data quality.
The session suits Excel users, business, financial, operations and other analysts, finance professionals, office administrators, and Power BI or BI beginners who prepare or clean data.
- Introduction to ETL concepts
- How Power Query works
- Source data vs query vs output tables
- Importing data with the Navigator
- Previewing data before loading
- Load vs Transform Data options
- Tour of the Power Query Editor
- Queries pane and Query Settings
- Applied Steps explained
- Managing data types
- Creating basic custom columns
- Merge vs Append explained
- Query dependencies
- Refreshing queries
- Connection Only vs loaded tables
- Close & Load options
- Beginner best practices and common mistakes
- Explain the Extract, Transform and Load (ETL) process
- Tell source data, queries and output tables apart
- Navigate the Power Query interface and import data with the Navigator
- Apply common transformations and see how Applied Steps record each one
- Choose and manage the right data types
- Distinguish Merge from Append operations
- Refresh queries when the source data changes
- Excel Users
- Business Analysts
- Data Analysts
- Reporting Analysts
- Financial Analysts
- Operations Analysts
- Sales Analysts
- Supply Chain Analysts
- HR Analysts
- Project Coordinators
- Finance Professionals
- Office Administrators
- Management Information (MI) Analysts
- Business Intelligence (BI) Beginners
- Power BI Beginners
- Professionals responsible for preparing or cleaning data in Excel
- Anyone new to Power Query who wants to automate repetitive data preparation tasks
Speaker Profile
Markus Ehrenmueller-Jensen
Markus Ehrenmueller-Jensen is a Microsoft Data Platform expert, trainer, and consultant specializing in Power BI, Microsoft Fabric, SQL Server, and data analytics solutions. With many years of international consulting and training experience, Markus helps organizations and professionals better understand modern data technologies and turn data into actionable insights.He is well known in the global Microsoft data community as an international conference speaker, author, and educator, regularly presenting at events, user groups, and technical conferences worldwide. Markus focuses on making complex technical topics understandable and practical, helping attendees bridge the gap between theory and real-world implementation.His areas of expertise include Power …
Upcoming Webinars
Medical Device Cybersecurity Following FDA’s 2026 Premarket…
Managing Toxic Employees: Strategies For Leaders To Effecti…
California Meal and Rest Breaks: What You Don't Know Can Co…
Human Error Reduction Techniques for Floor Supervisors
Unlock Employee Loyalty: Stay Interviews Will Keep Them Eng…
Performance of Root Cause Analysis, CAPA, and Effectiveness…
Your AI Advantage: How HR Professionals Can Use Claude to S…
The Anti-Kickback Statute: Enforcement and Recent Updates
Empowering Conflict Resolution: Letting Go to Gain Control
Wage & Hour Laws: Ensuring Compliance with the Fair Labor S…
Using Copilot to Format Legal Documents in Microsoft Word
Dealing With Difficult People: At Work & In Life
Using Stay Interviews To Improve Employee Retention & Engag…
AI in Word - Smarter Writing and Document Creation with Cha…
FDA Current Trends in Compliance and Enforcement for FDA-Re…
Zero Acceptance Sampling to Reduce Inspection Costs
Why EBITDA Doesn't Spell Cash Flow and What Does?
Mastering Tough Conversations: Turn Conflict into Clarity, …
Enhancing Pivot Tables with Images: Visualize Your Data Lik…
Discover how Emotional Intelligence turns AI from a technic…
Understanding Financial Statements for Non-Financial Profes…
SOPs - How to Write Them to Satisfy those Inspectors
Managing Projects When AI Joins the Team: Human Judgment, A…