CASE STUDY 02 / ANALYTICS / REPORTING
STATLINK — Analytics & Reporting Platform
A reporting platform that connects operational data, interactive dashboards and scheduled outputs.
- SOURCEData sourcesOperational data
- API & SEMANTIC LAYERSpring Boot · Cube.jsSecured APIs · semantic layer
- DASHBOARDSReact dashboardsApexCharts · dynamic filters
- OUTPUTReportsExcel · PDF · scheduled email
Problem
Operational teams needed a clearer way to explore data, build visual reports and receive recurring results without manually assembling each view.
Architecture
Spring Boot and MongoDB provide secured REST APIs with JWT and role-based access control. React and TypeScript render reusable dashboard components with ApexCharts. Cube.js serves as the semantic layer over a PostgreSQL data warehouse.
My Contribution
I worked across the API and frontend: reusable dashboard components, dynamic filters, configurable visualizations, secured endpoints, administrative interfaces and action traceability.
Reporting & Analytics
Users can filter and visualize data, then export results to Excel or PDF. Audit information helps trace actions through the application.
Scheduled Reporting
The platform supports scheduled email reports so recurring views can be delivered without repeated manual exports.
Predictive Module
A documented Python module supports failure anticipation, consumption analysis and anomaly detection. This was a focused product module, not a claim of broader ML infrastructure.
Tech Stack
NEXT PROJECT
Technical Chat
A one-to-one messaging application with persisted conversations and live delivery.