Customer Story

Washington State Department of Health Analyzes Data for a Healthier World

 

Washington State Department of Health Key Stats


Industry: Government

Data Stack: Microsoft Azure, Designer Cloud, Databricks, Python

Region: North America

25%

Reduced time spent by analysts

Self-Service

Created data pipeline without having to rely on IT

 

Core Challenges

COVID-19 forced the Washington State Department of Health to speed up efforts to move analytics to the cloud. The scale of data coming in from legacy transactional systems and reference tables from hospitals, schools and clinic sites overwhelmed their traditional processes and virtual machines did not resolve the problem. Public Health has been underfunded for the past 50 years and our data systems reflect that. Nearly every data system had been built for a single purpose, overly customized and is not interoperable with other systems. Public health response requires a rapid data analysis to inform decision-making and public health action. Consequently, before one can analyze data they have to conduct long and painstaking work to clean, transform, standardize and restructure data before it can be queried. The tools to simplify or centralize this process were not available, causing both a long time to insight and a great amount of duplicative work done by agency analysts.

How Designer Cloud Solved this Problem

Designer Cloud sits within the internal CEDAR (Cloud Environment for Data Analytics and Reporting) platform on Microsoft Azure. Here, data scientists can access the raw data and create analytics-friendly tables for program analysts. Program analysts can then access these usable data sets and rapidly explore, clean, standardize, and transform data in the cloud for analytics. Designer Cloud has been intuitive for analysts and allows them to perform familiar functions much more easily in Designer Cloud than in R or SAS. Data quality epis love the easy standardization, the different clustering algorithms and the ability to turn free text into categorical data quickly.

 

Benefits

Data Quality

Clean consumable analytics-ready datasets allows for the ability to extract insights from massive data that was being collected, but not analyzed.

Collaboration

WA DoH built workflows that updated tables for complex analysis across a number of teams and has reduced time spent by analysts working independently on data prep by 25%.

Increased Productivity

Established data pipelines that teams can create, share centrally and manage themselves without IT has created a self-service culture. Breaking the dependency on IT.

 

Company Background

The Washington State Department of Health is a state agency of the state of Washington. Headquartered in Olympia, WA, the agency was created by the state legislature in May 1989 after splitting from the Washington State Department of Social and Health Services. It’s programs and services help prevent illness and injury, promote healthy places to live and work, provide information to help people make good health decisions and ensure the state of WA is prepared for emergencies.

 

“One of the biggest challenges with public health data systems is finding the right tools to invest in that can meet us where we are – in both skills and infrastructure – and help us transition to new methods and flexible and scalable environments. Experienced epidemiologists have survived countless attempts to address gaps with tools that don’t benefit the analyst or fix the problem. Our workforce is exhausted from COVID and we need to invest in tools that make their lives easier. Designer Cloud has been the easiest tool to introduce to epidemiologists. The interface is intuitive, and the visual profiling allows them to quickly dive into the data faster than ever before.”

 

 

15 MINUTES OR LESS

Assess Your Analytics Maturity

Get a better understanding of where you stand on the analytics maturity scale – and where you want to be.


Get Started
 
 

Recommended Resources

 
E-Book
How are enterprises using technology to make decisions?
Download the report to learn how how decision intelligence will impact the future of decision-making.
Read Now
 
Customer Story
Nielsen Reboots Its BI Process with Alteryx and AWS
How Nielsen used AWS and Alteryx to modernize its analytics stack in less than 90 days.
  • Analytics Automation
  • BI/Analytics/Data Science
  • Alteryx Analytics Cloud
Read Now
 
Whitepaper
Private Data Handling
It starts with transparency. Learn about the security controls, architecture, and governance practices utilized to secure an Alteryx Analytics Cloud private data plane.
  • IT
  • Information Technology
  • Alteryx Analytics Cloud
Read Now