skip to Main Content

ALUK

Data Wrangling Tool

Our data wrangling tool greatly reduced the time needed to combine multiple systems at ALUK.

ALUK Data Wrangling Tool

ALUK

ALUK Data Wrangling Tool

Data Wrangling Tool

Our data wrangling tool greatly reduced the time needed to combine multiple systems at ALUK.

0
HOURS SAVED BY CLIENT

The Client

ALUK is one of the UK’s biggest suppliers of aluminium building systems. Their systems are used in large building projects around the world. ALUK are based in Gwent, Wales, and have facilities in Poland, Belgium, and France.

The Project

When ALUK expanded across the UK and Europe, they invested in a new stock control system. The data from their old system was incompatible with their new system. This meant it was not possible to just transfer the data from one system to the other. We developed an automated data wrangling tool to automate the full process for them.

A data conversion tool was needed to make their data ready for their new system. To convert the data several steps were needed.

Step One – Break the data down by SKUs, assemblies, and their component parts.

Step Two – Convert and clean the data.

Step Three – Rebuild the data in the new format.

With hundreds of thousands of different products and SKUs, the manual processing of the data would have taken years.

Our Solution

We developed a bespoke data wrangling tool that imported the original data and carried out several processes, including;

  • Breaking assemblies down to their component parts
  • Passing each component through a conversion process
  • Reassemble the components into their assemblies ready for the new system

As a final check, an error capture system was used to capture any corrupt data that had got through the system.

The Result

For this project ALUK saw many benefits from their data conversion tool including;

  • Simplified the preparation of data
  • Automated error capture preventing errors entering their new system
  • Saved over 3,500 hours

Since building the tool, we have helped ALUK with many other projects.

Call 02921 29 2235

Outside UK Call +44 2921 29 2235

Your Extra Peace of Mind

To keep your spreadsheets up and running, Excel-Expert offers a unique and free after-sales support package. Any snags found in the first 60 days are fixed immediately and for free. Should you find any bugs in our programming in the first 3 years they are also fixed for free.

60 Days of Free Tweaking

When you buy a new house, you get to produce a snagging list for the builder to put right before you move in. We do the same. Once you receive your completed project, you have 60 days to report any snags and we will tweak/fix them for free.

3 Years of Free Bug Fixing

Our coding carries a three-year warranty, and any bugs will be fixed free during that period. Just get in touch and will fix any issue as quickly as we can. (Just so you know, no one has ever needed to use this warranty).

Back To Top