Climber Worldwide
Climber BI Improving data reporting for Babcock and the British army

customer success story:

Climber BI Improving data reporting for Babcock and the British army

Read how we helped Babcock to improve its data reporting for the British army with Qlik and Microsoft

THE CHALLENGE

Babcock International Group is a leading provider of critical, complex engineering services which focuses on three highly regulated markets: Defence, emergency services and civil nuclear.

In January 2015 it won a major 10-year contract with the British Army to maintain its vehicles and manage the supply chain of materials. Included in its winning bid was the commitment to set up a Hub that would provide central data analytics capability.

The Hub would deliver data insights to the army and enable the internal operations of Babcock Land Defence Limited to exploit available data to ensure a smooth and effective operation.

THE APPROACH

Babcock Land Defence Limited approached Acutus Consulting (now part of Climber UK) to support the implementation of the Hub by providing Business Intelligence expertise from project management to full dashboard development. This would enable it to develop its business intelligence capabilities across supply chain, asset maintenance and fleet management.

Initially our team used the ETL (Extract, Transform & Load) process within Qlik to build a data warehouse and full reporting suite using Baan data provided by the British Army. This provided engaging and insightful reports that enabled Babcock Land Defence Limited to track army vehicles anywhere in the world, monitor the performance and progress of vehicle repairs and more importantly report on their performance against a set of agreed contractual KPIs on a monthly basis.

In 2014 Babcock International Group decided to implement a new SAP ERP system across the entire Group. It also planned to move from a Qlik data warehouse to the Microsoft stack using SQL and SSIS. This was so data could be used beyond Qlik around the Group.

Because we had already helped Babcock Land Defence Limited to develop its data capabilities, we became responsible for the reporting stream and were enlisted to support the rebuild of the Qlik estate, now using SAP ERP data for SupplyChain, Asset Maintenance, Fleet Management and Finance, stored within the new SQL data warehouse that we also built.

However, Babcock Land Defence Limited continued to use Qlik for its own reporting, as Qlik’s Associative Engine helped revolutionise how it managed vehicle maintenance, from ensuring parts were available to assigning the correct staff who had the appropriate skills and training to undertake specific tasks.

As the business moved to a new SAP solution, the data structure changed, and we immediately adapted our reporting. We worked with the SAP Program team and Subject MatterExperts from the business to understand where data was, and how it could be accessed, to rebuild the reporting suite.

We maintained the visualisations we had previously built in Qlik so Babcock could continue to receive the benefits of Qlik’s Associative Engine.

 

»The team managed a pool of BI resources that have been used to deliver analysis and detailed BI requirements, dashboards and reports. All of the team are competent individuals, focused and results driven.« Adrian Palmer, SAP Program Manager

 

THE RESULT

Babcock Land Defence Limited and the BritishArmy now have a clear view of the state of theirvehicles in repair. They can track whether thereare any resource shortages and/or delays withparts getting to repair work centres. Thereporting solution helps Babcock to manage itsbusiness effectively, and successfully meet thecontractual KPIs it has with the Army.

 

We can help you!

If you want to modernise your data analytics and improve your reporting, talk to us today. Let’s start Creating Intelligent Business!

ALEX BOOTH

Business Development Manager
alex.booth@climberbi.co.uk
+44 203 858 0668

James Sharp

Managing Director
james.sharp@climberbi.co.uk
+44 203 858 0668

News archive

Cloud Data and Analytics Tour International with Climber
Event, On-Demand Webinar

Cloud Data and Analytics Tour International with Climber

Join us to navigate a path to cloud for your analytics. We’ll give you a heads up on the latest features. Hear about our customer FCG  and how they’ve started the transition leveraging Qlik Sense Saas for faster insights. See how you too can make the move, at your own pace, learn how you can enjoy the experience of Qlik as a Service with your on prem solution and in parallel get the benefits of Qlik Sense SaaS functionality – as it’s not a one fits all experience but rather a very individual one. 

>> Sign up here!
Our key take-aways from QlikWorld 2021
Blog

Our key take-aways from QlikWorld 2021

Qlik host many events throughout the year, but QlikWorld is undoubtedly the biggest. For the second year running it was held virtually with a great line-up that showcased new product features and 100 break-out sessions. If you didn’t manage to check-out the event, here’s our key take-aways from a packed agenda.

>> Read the key take-aways
Qlik Sense dashboards enabled fact based decisions at Asics
Customer Case

Qlik Sense dashboards enabled fact based decisions at Asics

We’ve helped ASICS to efficiently structure valuable sales and supply chain data by optimising clear Qlik Sense dashboards. Thanks to this solution, employees don’t have to waste hours finding the data they are looking for.

>> Read more!