Regional Operations Quiz Analysis

Tools: Tableau, Google Sheets, Google Slides, Excel, AI-assisted analysis Dataset: Mock dataset mirroring real regional operations data

Overview

This project is based on real operational analytics work I led over the course of one year, during which I produced five complete regional analyses that were presented to leadership to support operational improvement initiatives across the West Region. The mock dataset presented here mirrors the structure, scope, and methodology of that work, with all proprietary data replaced to protect confidentiality.

The analysis evaluated quiz performance across 25 cafe locations in California, Oregon, Washington, and Nevada, covering 206 participants across two roles: Ambassadors and Coaches. The goal was to assess operational readiness, identify performance gaps by location and role, and surface actionable insights for regional leadership.

Methodology

Data was consolidated from multiple locations and audited for consistency before analysis began. Participation gaps were identified prior to running any performance metrics to ensure the integrity of the findings. Five Tableau visualizations were developed to communicate results across four dimensions: regional performance, completion rates, role-based score comparison, score distribution, and cafe-level participation.

Each visualization was built to answer a specific operational question rather than simply display the data. The role comparison chart, for example, was designed to surface whether performance gaps existed between Ambassadors and Coaches at the same locations, which would point to a coaching issue rather than a knowledge issue.

AI-assisted analysis was used to support data exploration, formula refinement, and visualization design throughout the project.

Key Findings

Washington led the region with an average score of 83.4, while Nevada trailed at 63.6, a gap of nearly 20 points pointing to a regional disparity in operational readiness. Oregon achieved 100% quiz completion, the only state to do so, raising the question of what practices their managers were applying that others were not.

The Ambassador vs Coach gap of 11.1 points indicated that Coaches, despite higher scores, were not fully transferring that knowledge to their teams. 19% of participants scored below 60, flagging a segment requiring immediate attention. Coral Springs showed the lowest participation rate at 37.5%, a signal worth investigating at the leadership level.

Impact

The real project behind this mock produced five complete analyses over the course of one year. Those analyses informed targeted coaching conversations, participation improvement initiatives, and regional performance discussions at the leadership level. The consistent reporting structure allowed leadership to track trends across multiple cycles rather than relying on one-off snapshots.

The mock dataset presented here demonstrates the same analytical methodology and visualization approach applied in that work.

Lessons Learned

Operational data is most actionable when it asks a question, not just reports a number. The most valuable insight from this project was not the regional average score. It was the gap between what Coaches knew and what their teams demonstrated, because that gap pointed directly to a behavior, not just a knowledge deficit.

Participation rates also proved to be as telling as scores. A cafe with low participation is not just a data gap. It is a signal about engagement, culture, or leadership that deserves follow-up.

Live Dashboard

View the full Tableau Public dashboard here: West Region Operations Quiz Analysis