The client needed a tool to facilitate tracking and visualization of costs related to the cloud platforms used within the company, such as AWS and Azure.
The project’s goal was to create a Power BI dashboard that allowed for monitoring all costs incurred for each individual application used, enabling the company to quickly identify applications that required cost optimization.
Hermes’ Intervention and Involved Talents
After conducting a process analysis and technological assessment, since the client did not have the necessary in-house skills to develop the project, Hermes proposed the FLY mode. The company needed comprehensive and flexible digital consultancy that would enter its internal processes for the necessary time but would also be able to take complete control of the project.
The talents involved, a business analyst and an Microsoft Power Platform developer, worked following the Agile methodology.
Programming and implementation of Microsoft Power Platform (Power Automate and Power BI). Based on a series of files received periodically via email, through automation with Power Automate, the files are moved to a SharePoint folder. At this point, using Power BI, all KPIs and trends can be viewed on a dashboard with daily updates.
Thanks to Hermes’ intervention, the following results were achieved:
- Effort saving: only 2 days per month spent on processing files.
- 100% improvement in data quality.
- 10% cost avoidance through the creation of the dashboard.
- Speed in implementing the application (1 week from the start of work to delivery).
Autonomy in the evolutionary maintenance of the application thanks to the delivery of technical and functional resources.