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