Data Analysis

Part 1 – Data Preparation (Using Power Query Editor)

You must perform the following steps:

Import the dataset

Clean the data (remove nulls, duplicates, errors)

Rename columns properly

Change data types correctly

Create calculated columns if needed

Handle missing values

Apply transformations (split columns, merge columns, grouping, etc.)

Part 2 – Dashboard Creation

Create a professional dashboard that includes:

KPIs (Key Performance Indicators)

At least 4–6 meaningful visuals

Clear layout and design

Business insights