Guest Intelligence Dashboard
A five-day onsite sprint that merged 44,874 guest records from four disconnected systems into a single source of truth, with a dashboard that shows operators who their guests are, what they prefer, and when they return as regular or VIP guests.
Summary
Worked onsite with the client during a five-day sprint.
Merged 44,874 guest records from four disconnected systems into a single source-of-truth database.
Built a data dashboard to visualize and understand guest profiles.
Description
Context
A historic fine-dining restaurant had guest records spread across OpenTable, Toast, and Mailchimp. Because the systems were disconnected, the team could not easily distinguish regulars from first-time visitors.
Approach
I spent five days onsite learning how the team used each system and where the records overlapped. I then built a pipeline that matched and merged guest profiles using phone numbers, email addresses, and name similarities.
Deliverables
The team received a guest intelligence dashboard running on its own infrastructure. It brings together guest profiles, visit history, repeat behavior, VIP scoring, and email-list health, giving staff better information for daily restaurant operations.
Gallery
More projects
Mnemo Atlas
A catalog of culture built around connections: not only what we know about something, but how it relates to everything around it, and where that connection comes from.
Data · AI · 2026
Meridian Urban Metrics
A forward-deployed engineering platform for real-estate development and investment analysis, built on a reusable historical data and modeling layer.
Data · Economics · Urbanism · 2026