Create a Durable and Scalable Multi-Tiered Data Warehouse (DWH)
Challenge
A U.S. biotech company asked us to help them simplify their convoluted multi-source, multi-consumer data pipelines, to improve data consistency and reduce manual activity.
Solution
Using Amazon Simple Storage Service (Amazon S3) and Amazon Relational Database Service (Amazon RDS) we developed a durable and scalable multi-tiered data warehouse (DWH). We also brought in a refined plate-compound-matching method to improve the computational efficiency for generating accurate dose-response curves for compounds and determining IC50/EC50.
Outcome
A 45% reduction in manual activity among the biotech’s stakeholders, and improved data consistency. In addition, by using AWS, we were able to reduce the time needed to present the required evidence for the Public Product Presentation to less than six months.