Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power Query: Clean & Transform data with PowerBI Power Query
Highest Rated
Rating: 4.8 out of 5(29 ratings)
1,090 students

Power Query: Clean & Transform data with PowerBI Power Query

Unlock the full potential of Power BI with a deep dive into Power Query. Real-World Data Cleaning & Shaping Techniques
Highest Rated
Created byAhmed Oyelowo, Foresight BI & Analytics. 100,000+ Learners
Last updated 3/2025
English

What you'll learn

  • Apply essential Power Query transformations to clean, reshape, and prepare data for Power BI and Excel reporting
  • Combine multiple datasets using merge and append queries in Power Query
  • Analyze column quality, column distribution, and column profiles to detect errors, missing values, and data issues
  • Transform messy datasets using split column, fill, replace values, transpose, unpivot, pivot, and group by operations
  • Create custom columns, conditional columns, index columns, and calculated fields in Power Query
  • Build repeatable Power Query workflows that refresh automatically when source data changes
  • Troubleshoot common Power Query problems and prepare clean datasets for dashboards, reports, and analysis

Course content

5 sections • 42 lectures • 3h 44m total length

  • Introduction3:01
  • Download the course files0:08
  • Getting Data into Power Query6:33
  • Understanding how Power Query works8:24
  • Previewing Empty and Error values with Column Quality3:37
  • Previewing Distinct and Unique with Column Distribution4:15
  • Previewing Columns Statistical Summaries with Column Profile3:20
  • Setting Data Preview checks for entire dataset1:29
  • Chapter 1 Quiz

Requirements

  • You should have Power BI Desktop installed on your computer
  • Power BI beginner level experience

Description

Course Overview:

Power Query: Clean & Transform data with Power BI Power Query:

Harness the capabilities of Power BI to its fullest! Power BI is a formidable tool, but its efficiency heavily depends on the quality of data it processes. With Power Query, you can ensure your data is cleaned, optimized, and ready for any visualization or analytics task.

This course, crafted by a 5-time Microsoft MVP, a Microsoft Certified Trainer, and Microsoft Certified Educator, is designed to offer you the hands-on skills you need to master data preparation, transformation, and cleaning in Power BI.

What You Will Learn:

  1. Combining Queries - Master the techniques of appending and merging data to maximize your analytical reach.

  2. Data Preview Tools - Dive deep into Column Quality, Column Distribution, and Column Profile to understand your dataset at a glance.

  3. Data Shaping Techniques - Unleash the power of operations like Transpose, Unpivot, and Group By to shape data as per your requirements.

  4. Calculated Columns - Delve into creating impactful columns with operations like Duplicate, Index, Conditional Column, Custom Column, and the revolutionary 'Column from Example'.

  5. Real-World Data Cleaning - Practical hands-on exercises where you'll clean up 6 sets of dirty data, transforming them into pristine, actionable datasets.

Who Is This Course For?

  • Power BI enthusiasts who wish to level-up their data processing skills.

  • Data analysts and professionals who deal with large or complex datasets regularly.

  • Anyone aspiring to master the art of data cleaning and transformation in Power BI using Power Query.

Why Choose This Course?

  • Expertise - With a seasoned Microsoft veteran at the helm, you're not just learning Power Query, you're mastering it with an expert.

  • Hands-On Approach - Beyond just theory, engage with practical exercises that give you real-world data cleaning experience.

  • Certified Knowledge - Leverage the insights from a Microsoft Certified Trainer and Educator, ensuring the quality and relevance of the content.

Wrap-Up:

Step into the world of Power Query with confidence. With each module of this course, you'll be better equipped to transform any dataset into a goldmine of insights. Whether you're just starting out or seeking to hone your Power BI skills, this course is the key to unlocking your data's true potential.

Equip yourself with the skills to turn raw data into refined insights. Enroll today and revolutionize your Power BI journey!

Who this course is for:

  • Power BI and Excel users who want to clean, transform, and prepare data using Power Query
  • Data analysts and BI professionals who work with messy datasets and need repeatable data cleaning workflows
  • Report developers who need to prepare clean, structured data for dashboards, reports, and business analysis
  • Professionals in finance, HR, sales, operations, and administration who use Excel or Power BI for reporting
  • Learners preparing for Power BI roles or the Microsoft PL-300 certification who need strong data preparation skills
  • Anyone who wants to turn dirty data into clean, structured, analysis-ready datasets using Power Query
  • Power BI learners preparing for the Microsoft PL-300 Power BI Data Analyst certification
  • Aspiring data analysts who want practical skills in data cleaning, data transformation, and data preparation

Report abuse