.png)
Connect and transform data with Power Query
You will learn how to connect and import data from diverse sources and transform them using modern tools in Power Query.
Instructor
What Will You Learn?
About This Course
Power Query is the backbone of effective Power BI reporting. In this course, Mastering Power Query for Power BI, you will learn how to confidently connect to multiple data sources, clean messy real-world data, and build reusable, efficient data transformation workflows using Power Query.
Designed for aspiring data analysts, business intelligence professionals, finance analysts, and reporting professionals, this hands-on course will equip participants with practical skills for transforming and shaping data in real business environments.
You will start by understanding the Power Query environment, storage modes, and data sources, then progress into practical data cleaning, profiling, restructuring, and combining datasets. By the end of the course, you’ll be able to prepare high-quality, analytics-ready data that powers accurate dashboards and insights in Power BI.
Who this course is for
1. Beginners looking to build a strong foundation in Power BI data preparation2. Analysts who want to automate and optimize data cleaning tasks
3. Professionals working with messy, multi-source business data
4. Anyone who wants to move beyond manual Excel cleaning into modern BI workflows
Related Courses
Explore newly published courses and stay updated.
Curriculum Overview
This course includes 7 modules, 40 lessons, and 3:57 hours of materials.
Introduction to the course
Download Exercise Files
Introduction to the module
Data Connectors in Power BI
Import data from Excel
Data from Text and PDF
Combine data from folder
Connect to relational databases
Scrape data from the web
Select Storage modes
Introduction to the Power Query editor
Introduction to basic transformations
Setting column headers
Date types
Manage columns
Column profiling
Transform data
Manage rows
Split columns
Transform by data type
Introduction to Merge and Append
Apppend Queries
Merge queries
Introduction to Pivot and unpivot
Pivot data
Unpivot data
Group and summarize data
Add columns - General
Add Columns from examples
Add Custom column
Add Conditional Column
Add columns from data types
Duplicate vs reference query
Duplicate Queries deepdive
Reference Queries deepdive
Working with Query dependencies diagram
Loading data
Clean and transform economic data from BOG
Clean and transform economic data from BOG
Clean and transform economic data from BOG
Course Certificate
Course Specifications
.png)
.png)
Send Course as Gift
Subscribe to Our Newsletter
Contact Us
.png)
.png)
Reply to Comment