project 04 Warehouse and Reporting

Turn raw data into trusted reports.

Clean business records, build a tested model and create repeatable reports.

business question

Profile raw CRM/sales records, build Silver and Gold tables in the disposable lab, explore the fact table, and publish repeatable reporting logic.

you deliver

Clean dimensions and facts, quality checks and customer, product and monthly reports. Exported as a report with your checked SQL, result evidence and written findings.

skills

Data cleaning · Data modeling · Reporting

scope

6 milestones · 6 tables · advanced

milestones

1. 01Bronze: inspect raw data before cleaningInspect incoming records before making cleaning decisions.
2. 02Silver: clean, map & deduplicateClean values, apply mappings and remove duplicate records.
3. 03Gold: dimensions, facts & quality gatesBuild dimensions and facts with checks for trustworthy data.
4. 04EDA: explore before telling the storyExplore distributions and relationships before reporting.
5. 05Monthly change & cumulative reportsMeasure monthly change and cumulative totals.
6. 06Customer & product reporting contractsProduce customer and product reports at a defined level of detail.