E-COMMERCE

Retail 3600 Customer View

R E T A I L  3 6 0
D E G R E E
C U S T O M E R
V I E W

 

T E C H N O L O G Y

ETL – Ideata/ Hadoop
Data warehouse – Teradata
Reporting – Ideata
Algorithms – R, Impala,
Hive and Pig

O V E R V I E W
One industry that is deriving great value from big data is online
retail sales. The existing IT infrastructures and data warehouse
made it a struggle to capture and analyze the unstructured
clickstream data together with the structured data at the
necessary speed and scale to be able to implement a real
personalized experience online for each of the retailer’s
customers. Additionally, the retailer needed a better way to
respond in terms of the volume of and speed of incoming updated
data.

A P P R O A C H
Logikview implemented a solution that involved creating a HDFS
data store that could integrate with traditional data sources such
as ERP and the enterprise data warehouse, clickstreams and
external data stores. Using the integrated data stream, the data
science team provides insights into the 360 degree views of
customer data. Additionally, Logikview created dashboards,
queries and run-through algorithms using R, Impala, Hive and Pig.

O U T C O M E
The online retail client now has a single source of customer data
for all groups to understand 360 degree views of its customers.
The company can track data to examine how many times a
customer visits the web site based on an IP address or site log-in
to determine which platform, mobile versus desktop, produces the
biggest sales. This helps them to more effectively determine
where to spend advertising dollars.
The customer satisfaction team studies data on how long it takes
a shopper to successfully make a web purchase to ensure overall
satisfaction. If trends are noticed, such as shopping cart
abandonment, the data is further examined to determine if the
reasons are because of website or server issues so they can be
immediately rectified.