DATA ARCHITECTURE AND PLATFORM FOR AN E-TAILER

THE CHALLENGE

Our client, a mid-sized e-commerce retailer with 10 years history, had a legacy technology infrastructure that was not geared for advanced analytics. They approached Tatras to help them transform their technology platform, and develop an analytics strategy plan across their data sets and business issues.

THE SOLUTION

Upon understanding the client’s datasets and business requirements, Tatras proposed a database architecture capable of handling myriad analytics requirements.

All the data was consolidated in a Central Data Store

• Connectors were developed to pull data from Google and Bing marketing channels, Google Analytics, third party email marketing vendors, telephone calling systems, order management and content managements systems.
• New systems were brought in to collect and store clickstream data.
• Customer centric views of the data were created.

TECHNIQUES, TECHNOLOGIES, TOOLS

MySQL, Hadoop, Divolte, R, Java, Kettle

RESULT/IMPACT

We partnered with our client to put in place a data science roadmap.

In 4 months, the client had a scalable infrastructure platform capable of handling and processing multi-source big-data, used for advanced analytics across business functions.