Clickstream Analytics – Visualisation Project


Client challenges

Project scope

Our client is one of the biggest retailers in Europe and the US. The client wanted us to build a visualization platform to analyze their e-commerce data.


Enterprise Data Hub

The client's Coremetrics platform generates 16 aggregated data files which capture clickstream data from the e-commerce channel. The objective of this project was to build the Enterprise Data Hub (EDH) and enable daily feed post production date. Based on the available data sets, KPIs are represented on a custom built dashboard and the data sets are made available through a web interface for ad-hoc analysis.


Custom KPI

Custom KPI dashboard for weekly management report

Results validation

Experiments with various models and validation of various results using the data available for analytics

Conversion rate growth

Deeper analysis with additional data sets within the Data Warehouse, leading to 2% growth in Order Conversion Rate

Website experience

Improved website experience and page layouts

Tools / Technologies
  • Hadoop Ecosystem
  • Hive / HBase
  • PIG
  • Flume
  • Oozie
  • Shell Scripting
  • Spring MVC
  • Java
  • JQuery / Angular JS / Bootstrap