US Vet Care Chain Leverages MS Power BI for One Click Business Data Reporting
INDUSTRY
Veterinary
REVENUE
< $10 Million
EMPLOYEES
< 500
The client is a US-based veterinary service provider. With the help of pet care specialists i.e. doctors, medical staff, pet trainers and stylists, they offer healthcare, day-care, style and documentation services. Spread across the country, they enhance pet parenthood through their special packaged services.
The day to day operations of their centers generates diverse data including – inventory, clinical, billing, hospital, lab, accounts, events & customer appointments. Reports from this data had to be generated manually.
One challenge branched into many
The client had stored data related to customers, pets, accounting, marketing, sales and more in their existing ERP system and spreadsheets. To create reports and gain insights, they needed to collate this data, create spreadsheet-based reports and make them easily accessible. The main challenge in this entire process was the extent of manual effort involved. It became difficult to get data analytics as they continued to grow and expand into additional markets. With accumulated historical data since 2013, it was clear they required a complete reporting and visualization solution to:
Multiple challenges, one solution
The client’s data was primarily stored in a third-party ERP system and spreadsheets. The Emtec Digital team built a custom architecture for data processing and visualization leveraging the Azure ecosystem. The data, extracted using GraphQL, was ingested into an Azure Blob Storage within Azure Data Factory. It was then processed through Azure Function App and modelled using Azure SQL Database & Azure Analysis Service. With this foundation, data visualization and analytics was enabled using MS Power BI to create custom reports for every business function, stakeholder and service.
