A sales data analysis

The problem

A shop exports a year of messy sales records. Clean them, answer which products, regions and months drive sales, and write a short report with the cleaning log.

Requirements

Technologies

Step by step

  1. Write the questions the shop wants answered and profile the raw file.
  2. Build and test the cleaning step, logging each change.
  3. Group, join and compute the summaries and the monthly series.
  4. Write the report with tables, findings and limits.

Expected result

A pipeline that rebuilds the whole report from the raw file in one run.

How it is evaluated

Ways to improve it