BEGINNER PROJECT

Weekly KPI report from a messy database

Quick answer

Client brief: A manager wants five KPIs every Monday from a database whose tables have inconsistent keys.

Deliverables

1. SQL for each KPI
2. A short data-quality note
3. An automated weekly report

Rubric: it passes when

☐ Numbers reconcile to a manual check
☐ Edge cases are documented
☐ The report runs unattended

Skills used

SQL Data modelling Technical writing

Continue reading

BEGINNERSync a CSV export into a client's REST APIOpen →BEGINNERFAQ bot over one PDF with citationsOpen →BEGINNERWebhook receiver with retries and logsOpen →CHECKLISTHandover and documentationOpen →