01. The Challenge
Executive decision-making was hindered by fragmented data sources and slow query times for aggregated analytics across the ministry's various departments.
02. The Solution
Implemented a data lakehouse architecture. Data is ingested from various sources into ClickHouse for real-time analytics. Laravel acts as the API layer, serving aggregated data to a custom dashboard protected by strict role-based access control. Visualizations are rendered with high-performance charts.