We built an end-to-end ETL and analytics solution for a leading heavy equipment manufacturer in China. Data that sat in MS Access files and SAP is now cleaned, loaded through ADF and SQL, and shown in Tableau dashboards. The business can track production requests, inventory and shipments month by month.
The client is a leading heavy equipment manufacturer in China. Its operations generate a large volume of data, held across MS Access files and the SAP system. The team wanted one dependable place to bring it all together, so production, orders and inventory could be understood clearly and acted on with confidence.
They wanted a complete database solution that could process and clean their large volume of MS Access data. They also wanted their SAP data put to better use, and the full set of data shown through different dashboards and reports.
The client had no single database that could support detailed analytics. Data lived in separate places and formats, so getting one reliable picture of orders, production and stock meant working across sources instead of querying one trusted system.
A huge volume of data sat in MS Access files, and it wasn’t ready for analysis. Before Tableau could use it, the records had to be processed and cleaned into a Tableau-friendly format that dashboards could read reliably.
A lot of SAP data wasn’t being put to full use. To make it useful for reporting, it had to be extracted, transformed and loaded into an SQL database that analytics could draw from reliably.
The business wanted to see all its data offerings through different dashboards and reports. Without a clean, connected data layer underneath, those views couldn’t be built, and teams had nothing consistent to look at or compare.
Questions like how many orders were confirmed versus shipped, or what stock was on hand, need data that’s clean and joined up. Without it, tracking production requests and inventory month by month was hard to do with confidence.
We pre-processed and cleaned the MS Access files before anything else. That gave the client a reliable base to build on, so every dashboard and report starts from data the team can trust, not data they have to second-guess.
Cleaned MS Access data was transformed and loaded into a Tableau-friendly format. The team can open it in Tableau Desktop or Tableau Online and start exploring straight away, without reshaping files first or fixing structure on the fly.
We took the data stored in the SAP system, transformed it and loaded it into an SQL database. SAP information now sits in a structured form that’s ready for analysis and reporting, instead of staying locked inside the source system.
We designed and launched a comprehensive ETL process using ADF and SQL. It collects data from different sources, transforms it and loads it into the right locations, so the data flow stays organised from source to dashboard.
Dashboards show lead time projections across total production requests, confirmed production, shipped orders and inventory. Production requests are also broken down by model for every product group, month by month, so planning starts from the same numbers.
An inventory stock statement and monthly comparisons of confirmed versus shipped orders give the team a regular, easy way to track what has been requested, confirmed and shipped, and to see where stock stands today.
Cleaning and loading MS Access and SAP data now runs through one ETL process.
Confirmed vs shipped orders and stock levels are ready in Tableau, not rebuilt each month.
Monitor inventories in real time to replenish on time and know what's in stock without chasing separate files.
See orders shipped and products requested & confirmed, month after month, in one clear view.
Compare confirmed against shipped orders in seconds, and spot gaps between what was promised and what has left the door.
Clean, visual statistics on stored data, plus duplicate-data analysis, help the business decide how to manage and grow its data with confidence.