DATA-142: why repeat orders fell in September
For Customer Growth team (fictional)
The Head of Customer Growth must decide where to spend the autumn retention budget, and repeat orders fell in September. This project, ticket DATA-142, finds out whether the fall is real and why. Done means checked data, agreed KPI definitions, a plain findings memo and a dashboard review, all repeatable by another analyst.
In scope for you
- Profile the four files and log data quality problems with counts
- Reconcile the shop system against finance
- Test whether the fall is real and say so plainly if it is not
- Control the KPI definition change CR-02 and the CRM merge damage
- Hand over the method, definitions, memo and dashboard review
You hand over
- Data profile of the four source filesData profile
- Reconciliation of orders: shop system against financeSource reconciliation
- Data quality checks loggedData quality log
- Impact note for a metric change requestChange controlPremium
- Final KPI definition sheetKPI definition sheetPremium
- Analysis pack for the retention questionAnalysis packPremium



















