As a state Government, the customer approached Google and Cloudreach knowing they had a wealth of information, but without the ability to make rational decisions about this data due to the sheer volume and velocity. They engaged with Cloudreach to leverage Google Cloud’s big data products to bring together this data, from multiple agencies and sources, into a central visualization platform.
The objective was to enable customer's teams to provide insights so they can make more accurate projections on the progress of the pandemic. Thus allowing them to reallocate supplies and resources as hotspots emerged across their State. It was imperative for this platform to respect the privacy of citizens, whilst also helping the state better respond and adapt to rapidly changing circumstances.
After rapidly assembling a data pipeline into BigQuery, we were able to leverage Looker to produce a series of visualizations and analysis addressing several three key use cases and challenges:
- Current and projected COVID-19 cases (contracted and morbidity) by state, county, zip code;
- A comparison of multiple popular projection models at the same time to monitor the effectiveness of Executive Orders and the public’s compliance;
- Understand their healthcare supply and utilization levels to provide an insight into utilization and projections - informing resource allocation;
Through bringing together both private datasets owned by the State’s entities, along with Google’s Public Data Sets, we were able to correlate and understand the public response. For example, Waze API integration enabled the State to understand vehicle traffic flow with the spread of the disease, as well as current and projected inbound flight data from Google Flights.
Through working with their epidemiologists and infectious disease experts, we provided them with the ability to adapt variables to test various theories - and the associated outcome - to enable policymakers to make the right decisions.
The key Google Cloud Products used included Cloud Dataflow, Dataprep, BigQuery, Waze API and Looker.
Whilst containing the spread of the COVID pandemic requires a response across all sectors and agencies, enabling key government stakeholders to leverage their data allows them to better inform and respond. Google Cloud was able to support in this endeavour due to the strength of their big data products.
We built for the State a comprehensive data analytics and visualization platform showing their current pandemic status and enabling a variety of state-specific projections modeling the effectiveness of executive orders and public response. Most importantly, we were able to assist in safeguarding the citizens of this state, without risking their privacy.
Through leveraging Google Cloud, we were able to remove the operational hurdles associated with data analytics through implementing a serverless approach, to enable the State to make decisions more quickly and efficiently.
Following this engagement, we distilled the repeatable assets and architecture to be able to aid other local and central government entities to aid them in their own responses, and hopefully enable them to leverage data to flatten the curve.
Our customer is one of the largest States in the South with a population of over 20 million citizens. It is one of the top three largest States by population and has a triple digit GDP. The Governor's Office reached out to understand what assistance we could offer to better inform the State’s response to the COVID-19 Pandemic.