Start Free

Speed up your data preparation with Designer Cloud powered by Trifacta

Free Sign Up
 

Detects Outbreaks Faster with Designer Cloud powered by Trifacta

 

97 %

Reduction in time to transform data
 

Core Challenges

Understanding an unusual HIV outbreak in Scott County, Indiana called upon the CDC to quickly analyze a complex amount of epidemiological data. Traditionally, the team had used a combination of R and Excel spreadsheets to manually standardize and join together  data from multiple laboratories. But this process was extremely time-consuming, often requiring weeks or even months to have the data in an analysis-ready state. The nature of R and Excel meant that data quality issues were difficult to spot, plus these tools didn’t allow researchers the ability to access complex data. Public health surveillance data, for example, first needed to be transformed into an readable format by technical employees, which delayed analysis⁠⁠⁠ further. 

 

How Designer Cloud powered by Trifacta Solved this Problem

The CDC adopted Designer Cloud as a more sophisticated replacement for its Excel-based data transformation. With Designer Cloud, the CDC reduced total time spent transforming data from up to three months down to just three days. Designer Cloud visual data quality profiling allows researchers to spot inconsistencies or errors at first glance, as well as combine and standardize complex data without technical assistance. Best of all, Designer Cloud allowed the CDC to react to the HIV outbreak in Scott County, Indiana in record time and determine the root cause of the spread by enriching its analysis with new and increasingly complex data.

 
Faster Analysis

With Designer Cloud, the CDC was able to reduce data preparation from 3 months to 3 days.

Reduced Errors

Designer Cloud visualization surfaces errors and duplicates and provides an interactive summary of the statistics.

Advanced Insights

Enriching datasets with Designer Cloud powered by Trifacta resulted in an analysis assumption being refuted.