Retail Sales Data Cleaning & Simple Dashboard

Data Cleaning in Power Query

Perform only the following step:

Check & Correct Data Types

Transaction ID → Text

Date → Date

Units Sold → Whole Number

Unit Price & Total Revenue → Decimal Number (currency format applied after loading)

Region & Payment Method → Text

Rename Columns

Ensure clear and consistent names (e.g., ProductCategory → Product Category).

Fix Formatting Issues

Remove leading/trailing spaces in text fields.

Capitalize each word in Product Category and Region

Handle Missing or Incorrect Data

Replace blank/null values with "Unknown" for text and 0 for numbers

Remove duplicate rows

Sort & Reorder Columns

Order: Transaction ID, Date, Product Category, Product Name, Units Sold, Unit Price, Total Revenue, Region, Payment Method

Simple Dashboard Requirements

After cleaning the data, load it into Power BI and create:

Column Chart – Revenue by Product Category

Map (Filled Map) – Revenue by Region

Pie Chart – Revenue by Payment Method

Table – Columns: Product Name, Units Sold, Total Revenue