Next Gen Industrials
Global luxury car maker identified ~185K customers by linking decentralized data via R-scripts
13 Apr 2020
Context
- Client Description: Leading global luxury car manufacturer
- Opportunity: The client wanted to re-construct its Indian customers’ data into a single centralized platform from the existing multi ended decentralized platforms.
Our Approach
- Activity was bifurcated into two processes
- Cleansing: Existing data stored in different platforms was cleaned and standardized in the desired output
- Merging datasets: Identity of customers was established based on combinations of different data fields in lieu of the absence of primary key
- R (programming language) was used to run the different cleaning & merging logics.
- Existing data were diligently observed to find out the patterns. These patterns were analyzed to define the cleaning logic.
- Existing datasets were bifurcated into smaller sub-datasets for the effective running of code. Customized logics could be defined for each sub dataset.
Praxis Value Delivered
Defined recommended best practices for data handling
- Identified ~185K individual customers with primary key (generated afresh) and their vehicle details with current / previous owner status
Are you looking to grow faster than the competition? Write to us below.