Clickstream De-normalization

Client Challenges
Project Scope
Our client is a US E-Commerce company who wanted to perform analytics on the clickstream data in real time and ad hoc.
Solution
Big Data layer
Datametica built a foundational big data layer to enable analytics on the clickstream data. The data is ingested in real time. Then the data is cleansed and a single unified and denormalized layer is built using different lookup tables and files. This denormalized layer is accessed to carry out analytics.
Benefits

Real-time
Delivers summaries in real time

Streaming data analytics
Ability to run analytics on streaming data

Relevant recommendations
Able to send relevant and targeted recommendations to customers
