// 01 — context
context
6-person medical secretariat, weekly reporting hand-built in Excel.
// 02 — problem
problem
8 hours per week spent on reporting, data outdated by decision time.
// 03 — solution
solution
Automated data pipeline, real-time dashboard, automated weekly recap email Monday 7am.
// 04 — result
result
Reporting cut from 8h to 5 minutes. Weekly decisions taken on Sunday-night data.
// tech stack