The problem
Weekly reports were assembled by hand from five spreadsheets, taking about 6 hours each week and often containing errors.
What I did
- Designed the data model and ETL jobs
- Built reusable chart components and role-based access
- Ran usability sessions with 8 stakeholders