We began by developing a proof of concept (POC) to rapidly test, learn and demonstrate success through an isolated project – by this means we looked to win senior leadership confidence and stir enthusiasm for the broader task ahead.
The first specific use case chosen as a POC was to move a monthly management report populated in PowerPoint to Power BI. This use case was selected because it presented a well-defined scope (replicating existing KPIs), it was across all TEPUK’s assets and it was being delivered to the executive team.
The proof of concept was successfully delivered, winning validation from senior leaders and a green light to proceed through a wider BI and data transformation.
One of the key ambitions was to reduce manhours spent by Total staff collecting, analysing and reporting on data – streamlining processes through the creation of Power BI reports.
To achieve this, we automated the sourcing of data, processing, and outputting. Instead of Total staff manually collating data, the processes are now fully automated. We also created a centralised location for reporting where reports are based on the most up to date data and insights are ready instantly.
We moved data onto an Azure cloud tenant, which allowed multiple capabilities, such as:
- extracting data for it to be centralised for processing
- performing big data transformations
- unlocking analytical transformations - e.g. geo-referencing data to compute travel time between two geographical locations
- combining data from other sources to provide further enrichment
Throughout the work, processes were rigorously documented and can now be used to onboard new business acquisitions in an efficient manner – ensuring ongoing consistency and speed to insight for acquired organisations.