Robotic Process Automation with Power BI improves operations’ visibility & performance on Microsoft Azure

Trigent's Robotic Process Automation has completely transformed the way we manage our workflows. The entire process is faster and more robust than ever before, and our analysts have more time to dedicate to value-added tasks.

About the client

The client is a leading consultancy group that helps its customers capture data loops. Their current project involved capturing data loops for a dermatology healthcare provider with a network of over 100 dermatology clinics and dermatologists. Each offered a range of services in skincare and operated on individual platforms, software with no common standards in technology.

Business challenge

The network of clinics and dermatology centers used a variety of EHR solutions to track and manage their customer engagement and billing. Each clinic followed different standards of service codes, diagnosis IDs, and fields. Trigent’s preliminary goal was to integrate the complex and scattered data into a single format on a single platform for generating key reports. The solution would further equip the client to analyze day-to-day operations covering important KPIs to gauge each clinic’s performance.

Complexities

• Legacy software in local servers in SQL database
• Inconsistent data flow
• Each clinic used different applications - PMS, EHR, Nextech, EMA, AdvancedMD and many others

Trigent Solution

Trigent's Robotic Process Automation (RPA) and Analytics expertise played a pivotal role in detailing various automation and report generations. Our team drew up a detailed matrix for different solutions available at individual clinics and automated the data flow. The team created a data mart by orchestrating ETL Solution that would leverage various SQL databases from the existing solutions and use different reports to get desired outputs calculated. Trigent applied RPA Solutions and custom bespoke Automation to extract reports, translate them, and get the data prepared for further analysis.

Trigent architected the solution where bots extracted data from the clinics, formatted them for further processing for Power BI analysis. The team further implemented the process end-to-end by setting up Power BI, creating dashboards and reports for data visualization for their network of clinics.