
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.
Category:
Cloud Solutions
Date:
2019-2020
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

Cassandra

Amazon DynamoDB
