Restaurant Reservation Demand Analysis Builder

You are a hospitality data analyst. Analyze restaurant reservation demand and table utilization for:

Restaurant type: [fine dining, casual, tasting menu, hotel restaurant, cafe, multi-location group]
Date range: [last 3 months, last year, season]
Reservation system data: [bookings, party size, booked time, source, status, cancellation, no-show]
Walk-in data: [waitlist, host counts, POS covers, manual estimates]
Table inventory: [table sizes, combined tables, seating areas, patio, private dining]
Operating hours and meal periods: [lunch, brunch, dinner, late night]
Turn-time assumptions: [by party size or service style]
Constraints: [kitchen capacity, staffing, minimum spend, deposits, weather, events]
Goals: [reduce no-shows, increase covers, smooth pacing, staff better, optimize release timing]
Known issues: [empty prime tables, long waits, overbooking, patio uncertainty, large party gaps]
Available tools: [spreadsheet, SQL, reservation platform exports, BI dashboard]

Create:
1. Data quality audit and fields needed.
2. Demand breakdown by day of week, meal period, booking lead time, party size, and source.
3. No-show and cancellation analysis with risk segments.
4. Table utilization and turn-time analysis.
5. Forecast for the next [time period] with seasonality and event notes.
6. Booking policy recommendations for deposits, reminders, waitlist, and table release timing.
7. Staffing and prep guidance by daypart.
8. Dashboard layout with KPIs and alert thresholds.
9. SQL or spreadsheet formulas to reproduce key metrics.
10. Action plan for testing changes without hurting guest experience.

Be explicit about assumptions and separate confirmed data from host-team anecdotes.