customer success story:
Enabling the retention of vital historical data in Power BI
Read how we supported a Design and Manufacturing company in the Defence and Aerospace industry to access and report on important historical data.
THE CHALLENGE
To maintain and support defence equipment throughout a long-life span, engineers, manufacturers, and technicians rely on Bills of Materials (BOM) data which lists the raw materials, sub-components, parts, and the quantities of each that are needed to manufacture the end product.
Our client had been developing and manufacturing a wide range of products for the defence and aerospace industry for decades, and in some cases were still manufacturing equipment that had been designed over forty years ago.
This meant they needed to retain BOM data for many years. However, this historical data presented a problem for the company when they had to migrate to a new ERP system.
“Back in 2013 we had an ERP system that was also used as our configuration system. We transferred the ERP element of that to SAP, leaving just the configuration part in there. In 2021, we recognised that the ERP was becoming old and difficult to maintain so we migrated across to a new configuration tool. We ran into a few problems and were unable to migrate our historic Bills of Materials data across because the data sets didn’t match.”
Engineering Services Manager
THE APPROACH
The company needed to be able to access the historical data and carry out some basic reporting in Microsoft Power BI for the configuration and manufacturing teams, so they got in touch with Climber BI.
We kicked-off the reporting project with a requirements capture day, where the company told us more about their challenges and gave us some examples of the reporting they wanted us to develop. They made it clear that, because this was reporting on historical data from an old tool, they didn’t need lots of Power BI dashboards. In fact, they wanted us to simplify the reporting as much as possible so they could access the data in a format that was easy to read. Our BI developer worked closely with the client for three days a week over six months to provide everything they required.
“Climber’s developer was able to create the databases and reporting. We had fortnightly meetings where he would show us how it was going. We’d then be able to go away and answer any of his questions and do some testing on the work that he had done. And success! He was able to deliver everything that we asked for. He gave us the reporting in a format that is simple to use: it’s easy to do searches and export the data to Excel. lt’s exactly what we wanted. I’ve found Climber very easy to work with and very transparent.”
Engineering Services Manager
THE RESULT
The reporting that we developed enables the client to access the history and improve the traceability of their products. This means that if any products are returned to them, they can use the data and reporting to understand the build and design standards of them.
At the end of the project, we provided the client with a document that explains how the reporting works in Power BI, so the engineering and quality teams can access and use it easily. The company used this to develop simple instructions for users in their common format.
We can help you!
Get in touch to team more about how we can help you transform your reporting to enable better-informed decisions. Let’s start Creating Intelligent Business today!
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
Delivering timely and accurate data for AESSEAL with QDI
Read how we helped the design and manufacturing company AESSEAL to massively reduce the time it took to feed the Oracle data warehouse from SAP, from an overnight data transfer process to just minutes with Qlik Data Integration.
>> Read more!Understanding Power BI’s Data Connection Methods
As data analytics continues to evolve, Power BI offers multiple methods to connect and interact with data: Import, Direct Query, and the newly introduced Direct Lake mode. This post explores the differences, advantages, and ideal use cases for each of these data connection methods in Power BI.
>> Read moreEva Chrona new CEO of Climber Group
As of October 1st, Eva Chrona will assume the role as CEO of Climber Group. With her extensive experience and strong leadership, we are confident that Eva will continue to drive Climber Group’s growth and innovation in the years ahead.
>> Read more