PRACTICE PROJECT — MONTHLY SALES DATA CONSOLIDATION

Create:

Monthly_Sales_Data_Consolidation.xlsx

Source Files

Create three datasets:

Example:

Repeat similar data for February and March.

Project Tasks

Step 1 — Import

Import all three monthly datasets using Power Query.

Step 2 — Clean

Step 3 — Transform

Step 4 — Combine

Use:

Append Queries

to combine:

January + February + March

Step 5 — Merge

Merge the combined sales query with a Product Master table.

Step 6 — Create Columns

Create:

Profit

Sales – Cost

and:

Sales Category

High / Normal / Low

Step 7 — Group By

Create:

City-wise Total Sales

and:

Product-wise Total Sales

Step 8 — Load

Load the final cleaned dataset into:

Clean_Sales_Data

Step 9 — Refresh Test

Add a new April record to the source and refresh the query.

Verify that the consolidated dataset updates.

FINAL PROJECT OUTPUT

Your workbook should contain:

Final Summary