Reporting & Dashboards
November 11, 2023
The Challenge

A customer in Oil and Gas industry sector needed dashboards created for daily reporting of specific metrics for their Procurement and Supply Chain Team. The client currently extracts the raw data from multiple sources and then consolidates this analysis centrally and this takes over 1 to 2 business days depending on the availability of staff to clean the data and complete the analysis, every week as opposed to being able to review daily.

The Solution
  • We initially reviewed the consolidated reports and the process of compiling the data and subsequent analysis
  • We also reviewed the source data sets and checked for data quality and integrity
  • We then harmonized the taxonomies of the data being extracted from multiple sources and consolidated these extracts into a single source data warehouse
  • We deployed an automation to extract the data and consolidate it into a single BI dashboard that was designed in line with the end user requirements
The Outcome
  • The client saved on 2-3 days of 1 resource every week to prepare a report and often missing deadlines
  • The client was able to get the updates on a dashboard on a daily basis as opposed to weekly
  • The client was then able to drive activity based on the insights that were emerging through the report