Skip links

Cloud Based – KPI Admin Panel

Cloud Based - KPI Admin Panel

Building a cloud-based data landscape connected with Power App to allow approval-based reporting to executives

  • 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.
  • 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
Renewable/Sustainable Energy
Middle East​
Systems used​
MS Power Platform
PowerApps, Dashboards, SharePoint, Power BI