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