Our work

in life sciences

in tech

Case Study

Unify global user data to enable realtime analytics

Build ETL (extract, transform and load) pipelines and create a realtime unified store of analytics ready data from sources including web, social media, and app servers

Challenge

Our client, an enterprise software platform company, has more than 40,000 installations of their log management software and needed to better understand global customer software usage.

Solution

We built automated data pipelines to extract, transform and load data from multiple sources including web, social media, and application servers, creating a realtime unified store of data in S3 ready for analytics. We designed an architecture including S3 as the data lake, Athena as the query engine, cloud formation to orchestrate nightly data aggregation, and realtime visualizations on AWS Quicksight

Back to Life Sciences Case StudiesBack to tech case studies
View related case studies