Go Green One tree
One life
Trees
Loading...

Project Overview

The project is about developing a business intelligence and analytics application for a leading multinational, heavy equipment manufacturing company in China. They are known for their concrete machinery and are major suppliers of excavators, cranes, wheel loaders and other heavy machines.

They were keen to design and develop a complete database solution that could process and clean their hordes of data that was available in MS Access format. They also had a lot SAP related data that needed to be utilized for better use. They wished to view the entire data offerings through different dashboards and reports.

The client was finding it difficult to come up with a consolidated database that could give them detailed analytics. There was a need to process and clean data to load into a Tableau-friendly format so that it could be utilized well. Even the SAP-related data needed to be loaded into SQL format.

Diagnosing the challenges of the client, SPEC INDIA helped the customer in extracting, transforming, and loading the data into a well-organized format so that it could help them derive meaningful insights through analytical capabilities.

Key Components
  • Lead time projections – Total production request, confirmed production, shipped, inventory
  • Production request by models of all product groups/by month
  • Inventory stock statement
  • Monthly comparison of orders confirmed and shipped
  • Regular tracking of orders shipped, and products confirmed
manufacturing- company-screen 1

Core Features

The data was lying in MS Access files. We pre-processed and cleaned all the files to make it into a Tableau-friendly format. There was a lot of data that we took from the SAP system and transformed and loaded into SQL database.

We developed a comprehensive ETL process that included all major processing like extracting, transforming, and loading of data with the help of ADF and SQL. We also showcased data through meaningful, visually attractive dashboards and reports.

Key Inclusions

Preprocessing and cleansing of data

Transforming and loading data from MS Access to Tableau format

Moving data from SAP system to load into SQL

Screens

Technologies And Platform We Use

sap-logo
SAP
ms access-logo
MS-Access
Tableau-Logo
Tableau Online
MS-SQL-Logo
MSSQL

Business Benefits

Our solution enabled the business to achieve the following benefits:

Month-On-Month easy tracking of how many orders are shipped, how many products are requested and confirmed

Easy comparison of how many orders have been confirmed Vs how many are shipped

Customer to get all statistics about stored data in visualized form

Better decision-making for further data storage activities

Replication analysis for information about duplicate data

Easier for the business/marketing team to avail new business

Real-time monitoring of inventory stocks

Let’s get in touch!