Data Architecture Reorganisation For A Leading Pharmaceutical Company
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.