Project :

Big data analysis, Dashboard, Analytics

Client Name :

FMCG

Honey Badger Labs was the tech implementation partner in this project for analysing performance and fraud in the sales incentive program of a leading Indian FMCG company. The project involved analysing program data involving 70 million transactions.

The transaction details were provided as CSV dumps from different departments. The data sets were cleaned, lookup tables were implemented to generate correlation between the files from different departments. Additional computed fields were added to the schema for fraud analysis scripts that used K-means clustering. The data was loaded into a relational database for analysis using R Studio. The dashboard required creation of different types of aggregations for custom visualisations added by users. ElasticSearch and Kibana were chosen for this function. A massive ElasticSearch cluster was setup on Azure to handle real time aggregations from the 70 million records. After validation of the dashboard on Kibana, a custom dashboard was implemented in Django with the ElasticSearch cluster as the backend.

fmcg

TECHNOLOGY STACK

<p>Django</p>

Django

<p>Elastic Search</p>

Elastic Search

<p>PostgreSQL</p>

PostgreSQL

<p>Azure-Blob-Storage</p>

Azure-Blob-Storage

<p>Redis</p>

Redis

<p>kibana</p>

kibana

<p>Azure-Virtual-Machines</p>

Azure-Virtual-Machines

"We brought HBL on board at a crucial time in our journey. They were able to bring our monthly costs down, improve our site performance and handle a major project for us in record time."
Joji Philip
CEO DealStreetAsia

PREVIOUS PROJECT

NEXT PROJECT