Case Study

A custom guest intelligence dashboard to improve restaurant operations

Client: The Log Cabin
Type of engagement: Business analyticsData systems

Project gallery

01The Atrium, a public demo build of the guest-management system, running on synthetic data.

02Dashboard: visit frequency, spend distribution, and where guests travel from.

03Guest profiles: field completeness, celebration calendar, and the searchable profile record.

04Guest behavior: visit frequency, per-cover spend, recency, and booking reliability.

05VIP scoring: adjustable weights across frequency, spend, recency, and reliability.

06VIP tiers: ranked membership produced by the saved scoring model.

07Retention: at-risk guests by tier and risk level, with predicted return windows.

08Trends: year-over-year acquisition, retention, and cohort composition.

09Marketing: mailing-list subscribers matched against the guest database.

01 · Problem

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.

02 · 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.

03 · 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.