By the end of this course, you will be able to
Explore the Power Query interface and learn how to access it from Excel files and Power BI.
Apply data quality checks and handle blank rows and incorrect values.
Clean text using Trim and Clean and format numbers and dates for analysis.
Remove duplicate data and resolve date formatting issues using Power Query tools.
Create conditional columns to apply specific rules and process data efficiently.
Course Details
- 2h 55min / 25 lessons
- 21 learning resources
- Course completion certificate
Course Content
Introduction
Open Power Query from a Blank Excel File
Open Power Query from an Existing Excel File
Open Power Query from Power BI
Power Query Editor User Interface
Use First Row as Table Headers
Check Column Quality
Remove Blank Rows
Replace Values
Trim and Clean Text
Text Format
Number Format
Column Profile
Case Study – Excel Sheet Problems
Case Study – Resolving Data Cleaning Problems
Remove Duplicates
Date Format Problems
Date Tools
Unpivot Columns
Create Conditional Columns
Append Queries
Merge Queries
Append Queries vs. Merge Queries
Case Study – Column Tools
Course -Wrap up
About this course
This course is designed to help you develop practical skills in cleaning and transforming data using Power Query in Excel and Power BI. You will learn how to import data and assess its quality, handle blank rows and duplicate values, and address text, number, and date formatting issues. You will also explore Unpivot, Append Queries, Merge Queries, and Conditional Columns, applying them through case studies to transform raw data into organized, analysis-ready datasets.
Course requirements and prerequisites
No advanced prerequisites are required. A basic understanding of Excel and a willingness to develop your data cleaning skills using Power Query are all you need.
Instructor
Abdelrahman Hashem
Organizational Skills Trainer
29,871 Learners
9 Courses