Data Architecture Reorganisation For A Leading Pharmaceutical Company

Project Details

A leading Pharmaceutical company wanted to visualise data to get better insights and potential predictions from their under-utilised datasets. They also were looking for an optimised database architecture.

Cloud Solutions


The Challenge

Understanding the existing data architecture and the different data types and structures that were in place. Finding the best and most optimal database architecture given the structure of the company.

How London Data Consulting Helped

With 10+ years of experience, we now fully understand all required tools to successfully migrate data and structure a data pipeline to automate the whole data processing before data visualisation.

In this case we’ve used Alteryx for some parts of the data processing (ETL) and Amazon Redshift for some other parts where terabytes of data are being consumed and processed.

Eventually data would be stored in either Amazon RDS or DynamoDB databases before being displayed and filtered/manipulated using Tableau.

Some of the Data Tools We Used

Amazon AWS
Amazon DynamoDB