Case Study Details
Data Pipeline & Dashboard
Focus
Creation of a dashboard to understand statistics of purchase orders, scheduled services and staff performance for data driven business insights and decisions.
Approach
After agreeing on a wireframe design of the dashboard, Kuaba constructed a custom data pipeline to extract data from various sources, including on premises databases, APIs from the client's CRM, and cloud data storage.
We then configured a cloud database where the extracted data was transformed and uploaded each day by the data pipeline service. The pipeline also recognised discrepancies in the data to notify relevant personnel.
A Power BI dashboard was created to display multiple metrics, charts and trends within the daily refreshed data, with the ability to drill down into specific variables with slicers.
Outcome
- Automated daily data feeds from multiple sources
- Data driven decision making & service forecasting
- In depth understanding of staff performance
- Early notification of data issues
This dashboard has given our organisation unprecedented capability to make data driven strategic and operational decisions.
Project information
- Sector Non-Government Organisation
- Client Community Care Client
- Technology Stack
- Data Engineering
- Analytics