all case studies

City of LA: Shining a light on recovery and reopening

At a glance

We helped the City of LA visualize its COVID-19 response and recovery with Tableau dashboards. Now, city leaders can communicate health information and reopening statuses to the public efficiently and transparently.

What we did

  • Data visualization
  • Data automation
  • Pro bono project
  • Tableau dashboard design and development

Tracking a path through the pandemic

The City of LA, led by the mayor’s office, wanted to deploy a quick solution to help track the city’s path through the COVID-19 pandemic and share key insights with residents.

With a history of data-savvy initiatives, the city's teams already had access to robust data streams for COVID. They simply needed support to present the information in a clear and actionable way. In a project co-funded by our partners at Tableau, at no cost to LA, Slalom consultants helped the city design, build, and deploy two dashboards that are easy to navigate and richly informative.

We wanted to share this data in a transparent way. What the mayor sees is exactly what the public sees.

Jeanne Holm Chief Data Officer City of Los Angeles
see the live dashboards here
City of LA dashboards

The first dashboard (above) offers high-level statistics on health and wellness, essential city services, and new initiativeslike the senior meals program that serves over 20,000 people three times a day, every day.

The second dashboard (below) drills down into detailed health and wellness metrics, including the number of new hospitalizations and cases per day. It compares the city's metrics with the whole county of LA, offering a clear picture of the difference between rural and urban recovery trends. The numbers can also be filtered by patient ethnicity. This helps the city's teams as they strive to understand the equity impact of COVID and support vulnerable residents.

City of LA dashboard detailed view

Thanks to features like color-coding (green indicates movement towards recovery) and spark lines that show historical trends, Angelenos can see their city’s COVID numbers and understand its recovery status at a glance. And decision makers working to mitigate the effects of COVID-19 have a tool that helps them study the data, ask vital questions, and mobilize support where it's needed.

Says Jeanne Holm chief data officer for the City of LA, "Every company has an opportunity to think about what they can do in their community, to really try and make a difference, and to bridge the gap between what the government is able to provide and what they as a company can help to innovate. And this is an amazing example."

Ready to do more with data?