PMO Dashboard

Overview

A medium-sized professional services company was growing and had reached a transition point where better visibility was needed over internal activities across the organization.

Information about internal activities was managed in a number of different systems including MS Office 365 Planner, MS Dynamics 365 and MS Exchange.

Solution

  • Create custom solution for MS Dynamics 365 to manage information about internal projects
  • Analyse the data sources and target users' requirements and select an appropriate platform – MS Power Apps
  • Configure custom connectors to pull in data from APIs
  • Optimize performance by offloading complex queries where possible
  • Merge task data from disparate sources in PowerApps Canvas app
  • Create a single user interface to show all tasks across all projects with appropriate sorting and filtering options
  • Enable priority setting across internal projects
  • Enable editing for project details from within the app
  • Provide links to source data from the dashboard
  • Provide links to associated Office 365 groups

Benefits

  • The management team can see all activity across the internal organisation
  • The management team can easily navigate between projects from a single interface
  • Managers can set priorities across all internal projects
  • Individuals can see all their tasks from disparate systems in one place