line graph, bar graph, two women looking at data on a computer, large group of people walking and wearing masks in a city, and two males a manager and frontline employee checking on products in a warehouse
August 26, 2022
Data Intelligence

Using Google Workspaces to Bridge Gaps Between Meaningful COVID-19 Insights

How a web-based interface helped track COVID-19 cases, resource availability, status of testing and vaccination, and facility capacity in real-time.

Partnership with Northwest Arkansas Council

In the height of the global pandemic, Northwest Arkansas Council, a nonprofit organization established in 1990, was ready to create actionable data for local hospitals to manage the ever-changing conditions. The NWA Council is no stranger to serving its community. For over 30 years, the NWA Council has helped to shape the development of the region to advance job opportunities, infrastructure, health care, and quality of life. Most of the more than 100 members are companies, including Walmart, Tyson Foods, J.B. Hunt Transport Services, Simmons Foods, and George’s, Inc.

The Challenge 

To face the challenges of the pandemic, the NWA Council needed a way to consolidate statistics regarding COVID-19 from all of the regional medical institutions and healthcare groups. The current process was manual, with collaboration and communication facilitated through phone calls and handwritten notes. As more statistics were added, the process was becoming increasingly unwieldy, error-prone, and inefficient.

The Solution

RevUnit developed a more streamlined process for tracking critical information by leveraging Google Sheets as a collaboration tool for data capture, analysis, and reporting. Each healthcare organization designated authorized users to enter data including COVID-19 cases, PPE/resource consumption, and ventilator and bed capacity, providing a single source of truth and real-time access to data.

Solution Pillars

  • Data management
  • Productivity and collaboration
  • Smart analytics


Google Workspace:

  • Google Sheets
  • Google Docs
  • Gmail
logos of Google Sheets, Google Docs, and Gmail

The Results

Bringing almost immediate relief, the Google Workspace collaboration tool was launched to all participating regional healthcare organizations in only 12 days from the initial discussion. The data entered into the tool was captured with logged changes, then shared for visibility, collaboration, resource and facility planning, and media reporting to the public across the region for the last two years.

"This joint effort demonstrates how the Northwest Arkansas community is coming together in a powerful way to respond to an unexpected crisis. Support from these great partners will allow the region's health care providers to continue to protect staff, patients and keep our community safe."

Nelson Peacock | President & CEO, Northwest Arkansas Council

Data Studio
Google Cloud Build
App Engine
Cloud SQL
Cloud Storage
Cloud Functions
BigQuery ML

We're Google Cloud Partners

A white man with dark hair and glasses and a black woman with glasses and big hoop earrings having a positive conversation with word bubble icons overlaid

Check out all of the Google Cloud options available to your organization. 

Want to understand how to partner with RevUnit for a better data strategy or complete data overhaul? Connect with one of our data experts to ask your most important questions.

RevUnit icon
RevUnit is a technology studio that helps supply chain clients identify and implement data solutions that actually prove ROI. We help organizations across industries like transportation, freight, logistics, retail, and manufacturing achieve business results through innovative data solutions — powered by AI/ML and the cloud. We’ve done it for clients like ArcBest, J.B. Hunt, and Walmart.

Related Posts