Dirty Data Samples - Suggested Solutions

Take this limited time offer before 22 January 2024

Take 80% off the full Power Query for Power BI course when you use coupon code: EIGHTY at checkout.

Data Preparation, Transformation & Cleaning with Power Query
Course
5.0 average rating (8 reviews)

Unlock the full potential of Power BI with a deep dive into Power Query. Perfectly curated by a 4-time Microsoft MVP and Certified Trainer. In this course, you will learn how to perform ETL and clean dirty data with Power Query.

$15

Cleaning Dirty Data Samples

This course playlist provides a suggested approach to cleaning the datasets posted on the article on https://foresightbi.com.ng/microsoft-power-bi/dirty-data-samples-to-practice-on/. The solutions are delivered with Power Query.

Enroll for free

Course curriculum

1. Download Data Files
2. Introduction
3. Brief Introduction to Power Query
4. Badly Structured Sales Data 1 - The Problem
5. Badly Structured Sales Data 1 - The Suggested Solution
6. Badly Structured Sales Data 2 - The Problem
7. Badly Structured Sales Data 2 - The Suggested Solution
8. Badly Structured Sales Data 3 - The Suggested Solution
9. Jumbled Customer Details - Suggested Solutions
10. Invoices with merged categories and amounts - The Suggested Solution
11. Assignment - Clean Badly Structured Sales Data 4