The Client

The client is one of the largest European automotive suppliers selling to all leading car manufacturers. They employ more than 50,000 people and are present in 25+ countries worldwide.

Service Offerings

Services Provided

Tech Stack Used

The Problem

Their size necessitates the use of multiple tools and platforms to manage their operations. This generates a large volume of data that is spread across different applications, databases, excel spreadsheets and sharepoint. Their business team currently spends a considerable amount of time to aggregate and analyse this data. While they use PowerBI for data visualisation, they are dependent on a large number of excel macros and manual processes to clean and process the data before generating reports.
In the current scenario, they developed numerous python scripts to partially extract data from various databases, process it and save it to folders and files. PowerBI is used to load these files and data from other sources. Various transformations and other data processing operations are performed within PowerBI. This leads to complexity, performance issues and difficulty in maintaining the system. Scalability of this system and process is also a big question.

Implementation & Results

    Implementation was done in the following four phases
    • Integration of data sources to the SSIS layer
    • Building of the data warehouse
    • Creating reports and dashboards using PowerBI
    • Testing & QA
    We also implemented the following additional features along the way:
    • Data refresh after every 6 hours
    • Set up Alerts which are triggered in case of any failure in the SSIS jobs
    • Role based access control and RLS
    • Option to upload snapshots of previous data (history)

How can we help you?

Get in touch with us to schedule a consultation

Let's Talk