BI Application: Operational Dashboard
Measure and monitor multiple key KPIs and strategic goals district-wide, through an executive dashboard that is accessible across devices.
The risk mitigation dep was frequently asked the tedious task of calculating monthly/yearly reports of absences for various departments. This information was extracted from various siloed and incompatible systems within the data warehouse. It then was curated by Appling individual departmental and district business logic to produce reports in the form of excel sheets that would get emailed to department heads accountable for managing and monitoring their attendance.
Staff attendance records and HR data was mapped to be taken out of their silos and structured to display attendance insight in real-time in a single dashboard dynamically displaying their respective staff’s attendance. Sending automated reports via email across departments. Automated Threshold notifications.