of activity tracker data loaded into BigQuery
of genomic data [vcf files] loaded into BigQuery using Healthcare API
Reduced querying time
A non-profit biotechnology research organization, focused on finding treatments for amyotrophic lateral sclerosis (ALS), wanted aggregated patient data in BigQuery that could be queried using a unique patient ID.
Quantiphi built a secure and scalable data lake on Google Cloud with the following features:
– A bronze layer to store the raw data
– A silver layer to store aggregated data via scheduled SQL queries on the data received from the bronze layer. The aggregated layer is then utilized as a consumption layer for analytics