CU School of Medicine boosts research quality with Fivetran

Fivetran streamlines data delivery into Google BigQuery, enhancing UCSM's research analytics and boosting operational efficiency.
December 9, 2019

As cloud computing becomes the norm, organizations like ours, Health Data Compass at the Colorado Center for Personalized Medicine, continue to partner with innovative organizations to advance our mission of supporting research analytics. Fivetran has proven to be one of these technology acceleration organizations.

Fivetran focuses on creating easy-to-use data pipelines that are efficient and, most important to Compass, cloud-native. In 2015, Compass entered into a partnership with Google Cloud Platform (GCP) to take advantage of the managed services and scalability of GCP for our healthcare research analytics data warehouse and secure analytics platform. 

Jue Wang, Compass Lead BI Developer, researched organizations capable of providing a low-maintenance, high-value accelerator to get data from Salesforce to Google BigQuery, and found Fivetran was the most capable organization, with the tools to meet our high standards and requirements. GCP’s capabilities and security measures make the platform a scalable home for our enterprise organizational data and analytics demands. Fivetran’s automated data integration with GCP via APIs also fits within our technical direction and supports our efforts to increase efficiency and automation internally and for our customers, who are researchers seeking to advance clinical discoveries.

In keeping with the innovative mindset and mission on the Anschutz Medical Campus (University of Colorado, UC Health, Children’s Hospital and CU Medicine), Compass entered into a partnership with Fivetran to bring our researchers’ requests within Salesforce into Google BigQuery for analytics. By utilizing the Fivetran Salesforce connector, over 117 tables containing data about researches and their requests are synced every fifteen minutes from Salesforce. No other tool provided the same seamless integration between these two platforms with this level of automation.

With Salesforce data in Google BigQuery via Fivetran, Compass now gathers insights and from customer data in multiple ways. Customer data within Google BigQuery is rendered into Tableau dashboards, where researchers view the status of their Compass data requests, allowing a quick visual for progress and estimated request completion. In addition, summary data such as the frequency of requests from departments, types of requests and most requested data are used to improve efficiencies and track completions of requests within the Compass team. By using Fivetran technology, Salesforce data in Google BigQuery, and the clinical and genomics data in the Compass data warehouse, we now have the ability to deliver the most valuable data to researchers to help support grants and advance personalized medicine more efficiently, saving approximately 40 hours of work per quarter.

Fivetran contributes significantly to Compass’s overall mission to deliver quality services for research analytics by providing a product that seamlessly integrates with the heterogeneous platforms Compass already uses: GCP and Salesforce. By gathering Salesforce customer data into the same space as the other pieces of our data warehouse (Google BigQuery), we can run analytics and create dashboards to internally innovate, improve and ultimately — deliver more value to researchers.

[CTA_MODULE]

Start for free

Join the thousands of companies using Fivetran to centralize and transform their data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Data insights
Data insights

CU School of Medicine boosts research quality with Fivetran

CU School of Medicine boosts research quality with Fivetran

December 9, 2019
December 9, 2019
CU School of Medicine boosts research quality with Fivetran
Fivetran streamlines data delivery into Google BigQuery, enhancing UCSM's research analytics and boosting operational efficiency.

As cloud computing becomes the norm, organizations like ours, Health Data Compass at the Colorado Center for Personalized Medicine, continue to partner with innovative organizations to advance our mission of supporting research analytics. Fivetran has proven to be one of these technology acceleration organizations.

Fivetran focuses on creating easy-to-use data pipelines that are efficient and, most important to Compass, cloud-native. In 2015, Compass entered into a partnership with Google Cloud Platform (GCP) to take advantage of the managed services and scalability of GCP for our healthcare research analytics data warehouse and secure analytics platform. 

Jue Wang, Compass Lead BI Developer, researched organizations capable of providing a low-maintenance, high-value accelerator to get data from Salesforce to Google BigQuery, and found Fivetran was the most capable organization, with the tools to meet our high standards and requirements. GCP’s capabilities and security measures make the platform a scalable home for our enterprise organizational data and analytics demands. Fivetran’s automated data integration with GCP via APIs also fits within our technical direction and supports our efforts to increase efficiency and automation internally and for our customers, who are researchers seeking to advance clinical discoveries.

In keeping with the innovative mindset and mission on the Anschutz Medical Campus (University of Colorado, UC Health, Children’s Hospital and CU Medicine), Compass entered into a partnership with Fivetran to bring our researchers’ requests within Salesforce into Google BigQuery for analytics. By utilizing the Fivetran Salesforce connector, over 117 tables containing data about researches and their requests are synced every fifteen minutes from Salesforce. No other tool provided the same seamless integration between these two platforms with this level of automation.

With Salesforce data in Google BigQuery via Fivetran, Compass now gathers insights and from customer data in multiple ways. Customer data within Google BigQuery is rendered into Tableau dashboards, where researchers view the status of their Compass data requests, allowing a quick visual for progress and estimated request completion. In addition, summary data such as the frequency of requests from departments, types of requests and most requested data are used to improve efficiencies and track completions of requests within the Compass team. By using Fivetran technology, Salesforce data in Google BigQuery, and the clinical and genomics data in the Compass data warehouse, we now have the ability to deliver the most valuable data to researchers to help support grants and advance personalized medicine more efficiently, saving approximately 40 hours of work per quarter.

Fivetran contributes significantly to Compass’s overall mission to deliver quality services for research analytics by providing a product that seamlessly integrates with the heterogeneous platforms Compass already uses: GCP and Salesforce. By gathering Salesforce customer data into the same space as the other pieces of our data warehouse (Google BigQuery), we can run analytics and create dashboards to internally innovate, improve and ultimately — deliver more value to researchers.

[CTA_MODULE]

Learn how centralizing data improves customer and patient outcomes
Download our guide for modern data leaders
Topics
Share

Related blog posts

Fivetran named 2024 Google Cloud Technology Partner of the Year

Fivetran named 2024 Google Cloud Technology Partner of the Year

Read post
How to maximize the value of your Salesforce data
Product

How to maximize the value of your Salesforce data

Read post
SevenRooms cuts time to insights with Fivetran and Google Cloud
Data insights

SevenRooms cuts time to insights with Fivetran and Google Cloud

Read post
No items found.
SevenRooms cuts time to insights with Fivetran and Google Cloud
Blog

SevenRooms cuts time to insights with Fivetran and Google Cloud

Read post
Fivetran named 2024 Google Cloud Technology Partner of the Year
Blog

Fivetran named 2024 Google Cloud Technology Partner of the Year

Read post
Fivetran celebrates triple win with tech partner awards
Blog

Fivetran celebrates triple win with tech partner awards

Read post

Start for free

Join the thousands of companies using Fivetran to centralize and transform their data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.