CiDash
Near real-time KPI dashboard for retail management.
Case study anonymized for confidentiality — client details and internal metrics have been omitted.
Context
Managers relied on manual reports to track sales and inventory. CiDash centralizes the main ERP indicators in continuously updating views, putting information at the center of decision-making.
The challenge
Aggregating large volumes of data without penalizing the transactional database, delivering views that load fast and stay useful for day-to-day management.
Role and responsibilities
- Angular frontend with interactive charts and filters
- .NET aggregation endpoints with optimized queries
- Build and deploy pipeline with Jenkins
- Continuous improvements driven by business feedback
Stack and architecture
Angular SPA + .NET APIs on Firebird, with aggregations computed in a dedicated layer and delivered by Jenkins in versioned builds.
Highlights
- Manual reports replaced by always-visible indicators
- Filters by period, store and category for quick analysis
- Architecture that grows with new KPIs without rework
Takeaways
I learned to design APIs with aggregation in mind (not just CRUD), to measure the real cost of queries against the ERP, and to iterate quickly with direct manager feedback.