Cloud Based - KPI Admin Panel
Building a cloud-based data landscape connected with Power App to allow approval-based reporting to executives
- Challenge
- Data Uniformity was missing as each department was following different reporting formats, and different reporting periods and Projects master data was not maintained at a single source
- Some Projects are linked to KPI & must be reported to KPI Owner.
- Project Manager may be on leave and Project Members must provide updates.
- Manual reporting to the Executive without consistent frequency.
- Solution
- Conducted business workshops with business units reporting frequently to Client’s leadership, to identify and prioritize business KPIs
- Power Apps, Power Automate, SharePoint, and Power BI are selected technology options
- Provided User management within Power App
- Provided Role-based data entry within Power App
- Maintained Data linkage to KPIs
- Provided Role based SLA reminders for different Projects having different SLAs
- Provided System based SLA missed actions to keep the process ongoing
- SharePoint acted as a source for the power bi dashboard. The executive report got produced directly out of Project Progress data stored on SharePoint Lists
- Provided merged weekly reporting data for all projects on Power BI
- Executives can see the weekly update from anywhere on their desktop or mobile