Scorecard & Financial Analytics Dashboard for a Medical Courier Company
Scorecard & Financial Analytics Dashboard for a Medical Courier Company
Microsoft Power BI, Azure Data Factory, Azure Synapse Analytics, SQL Pools
The Challenge
The client wanted to automate their Performance Scorecards and Financial Dashboards in Power BI. The requisite data sets were set across multiple data sources such as application database, SharePoint, and Excel files. We also had to fetch data from third-party APIs.
The Solution
- Manual Excel files are automated via Power Automate to read data as soon as the email arrives.
- API and Database calls are integrated via Azure Synapse and the data is stored in Azure SQL Data Warehouse
- Power BI is used to build Scorecards and Dashboards based on business requirements.
The Extra Mile
- Automation of Excel files was suggested to them by us to make sure that the minimal number of manual touchpoints
- The weekly processes became daily to make the data more to make business decisions on time
