Net Zero Solution Provider who enables the world’s largest companies to meet their Net Zero goals. Their technologies, projects, and deployment engines enable companies and governments to take actionable steps to reduce their emissions. Ad-hoc project data capture, prioritization, and communications meant time spent collating, confirming and entering data into the existing project time keeping system. The process was manual, inconsistent and wrought with errors.
The solution needed to incorporate a standard data structure for secure, standardized and reliable historical reporting.
Reduction in time spend entering data, approving projects and change requests needed to be substantially reduced to increase PMO responsiveness while reducing PMO costs.
The solution needed to enable increased visibility into project progress for all stakeholders.
Using Microsoft Power Apps, Power Automate and Dataverse tables, Rockhop built an automated project creation and management solution that seamlessly tied into the existing project management system, Harvest. The solution leverages a data flow connector to an Azure Analysis Services Tabular Model to provide data, and the OOB connector for Harvest was used to automate the project for updating project data.
Reporting - Consistent project data that allows for deeper analytics on trends within the business.
Cost Reduction - Automation of project setup and changes in the time keeping system, Harvest, reduced data entry hours by more than 40/month.
Visibility - Standard interface and data format enable project managers to reduce errors and quickly create/update projects.