Power Query Workout 17 - Automated Data Cleansing Pipeline

Workouts Power Query
1

Automated Data Cleansing Pipeline

Project Description:

Create an automated data cleansing pipeline using Power Query in Excel or Power BI. This project will focus on automating the process of cleaning and transforming a raw data file into a structured, analysis-ready format.

Use the below dataset.

Automated_Data_Cleansing_Pipeline_Dataset.csv (13.3 KB)

Tasks:

  1. Import the raw data file into Power Query.
  2. Apply transformations to clean the data, including removing duplicates, correcting errors, and standardizing data formats.
  3. Merge and append data from multiple sources to enrich the dataset.
  4. Document each step of the transformation with detailed annotations.

Expected Outcome:

A Power Query script that automates the entire data cleansing process, complete with documentation for each step to explain the transformations performed.

Level:

Beginner