For two years, the operations team spent almost 2 days per week just merging and formatting Excel reports. This manual process was error-prone and slow.
I identified the main pain points: data scattered across various sources, no single source of truth, and each department had different report formats.
Analysis Process
The first step was in-depth interviews with stakeholders. From there I mapped the data flow and determined which KPIs were truly needed vs those that were just "nice to have".
Second step: data architecture design. We chose Laravel as the backend with MySQL for a simple data warehouse, and Vue.js for the dashboard frontend.
Results
Reporting time dropped from 16 hours/week to real-time. Stakeholders can now see current metrics instantly without waiting for the weekend.