Project Spotlight: Custom Querying for Operational Decision Support
Project: Relational Database Reporting & Query Development
Role: Operations Support
Company: Subway Development of SC
Industry: QSR Operations | Data Analysis
Tools Used: Microsoft Access, Relational Databases, SQL (Basic), Multi-Table Queries
The challenge
Our leadership team often required highly specific data insights to support equipment planning, remodel prioritization, and other operational decisions. These needs couldn’t be met by standard reports and required targeted queries to extract and filter data from internal relational databases—without the luxury of dedicated business intelligence tools.
my role
With limited formal training in SQL or database systems at the time, I took initiative to fill the gap. I quickly became the go-to resource in the office for:
Translating ambiguous requests into actionable data solutions
Writing and adjusting custom queries in Microsoft Access
Filtering data across multiple related tables
Clarify which offerings were available at specific times or locations.
What i did
Built custom queries to support recurring and ad-hoc requests (e.g., identifying drive-thru locations without headsets and not scheduled for remodel).
Used relational logic to pull data across equipment, location, and scheduling tables.
Delivered clean, filtered datasets to leadership to support decision-making.
Developed documentation and repeatable processes for frequently requested data views.
The outcome
Empowered regional leadership with precise, actionable insights for equipment and planning decisions.
Enhanced the efficiency of decision-making processes with timely, targeted reports.
Gained foundational experience in relational database structures and query logic.
Sparked a lasting interest in database management and operational data systems—now a core part of my career path.