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