Humphrey Intelligence App
Live web dashboard combining 8 years of Pride venue data with real-time operational metrics to support daily decision-making.
Strategic Objective
Build a unified view of Pride’s business, surfacing three critical deliverables that don’t exist today:
- Event P&L reports — revenue and costs per event, available within 24 hours of event close
- Weekly P&L summary — consolidated P&L across all events, delivered every Monday
- Cash forecasts — visibility of cash position trends, updated daily based on sales pipelines
Target user: Mat O’Keefe (venue owner) requiring high-level strategic visibility without manual data extraction.
Secondary users: Monique (Venue Manager) reviewing operational costs; Emily (Head of Programming) analysing event performance; Bookkeeper (new hire) accessing financial records.
Product Name: “Humphrey”
Naming choice: Named after Humphrey Bogart (LGBTQIA+ icon, Australian cultural reference in “Breakfast at Tiffany’s”). Reinforces Pride’s community identity while offering a neutral name for a business intelligence tool.
Core Dashboards
1. Overview Dashboard
Summary view of current week and trends:
- Key metrics: Weekly revenue (WTD), weekly costs (WTD), cash position (current balance), weekly breakeven progress
- Trend sparklines: 4-week revenue trend, 4-week cost trend, cash position over 12 weeks
- Alert zone: Red flags (Saturday underperformance, late supplier payments, cash reserves below threshold)
- Quick actions: “View event P&L”, “Check cash forecast”, “Review last week”
2. Event P&L Dashboard
Per-event profitability analysis:
- Event list: All events (past 4 weeks, sortable by date/revenue/profitability)
- Event detail view: Event name, date, attendance, revenue (tickets + bar), costs (performer, security, stock, labour)
- P&L calculation: Revenue - costs = profit margin; profit per attendee
- Comparison: This event vs average event by type (DJ, drag, karaoke, etc.)
- Trends: Best/worst performing events; seasonal patterns
Data sources:
- Square POS: Ticket and bar revenue
- TryBooking: Attendance, ticket tiers, promo codes
- Xero: Performer fees, security costs
- Deputy: Labour costs (if Xero bridge implemented)
3. Weekly P&L Dashboard
Consolidated weekly performance:
- Weekly rollup: Revenue, costs, profit by week (last 12 weeks)
- Cost breakdown: Performer fees, security, labour, stock, rent, other
- Revenue mix: Tickets vs bar vs food (when kitchen active)
- Comparison to budget: Actual vs forecast (if forecasting implemented)
- Actions: Drill into specific events, compare weeks, review notes
4. Cash Forecast Dashboard
Short-term cash position planning:
- Current balance: Cash on hand (bank balance from Xero)
- Next 30 days forecast: Cash inflows (estimated ticket sales, bar revenue) and outflows (payroll, supplier payments, rent)
- Risk flags: Runway visibility (weeks of cash at current burn rate)
- Scenarios: “What if Saturday cancels?”, “What if kitchen generates 20% food revenue?“
5. Customer Intelligence Dashboard
Customer acquisition and retention analysis (Phase 3+):
- Audience growth: Total attendees, repeat attendees, new vs returning
- Channel analysis: Ticket sales by acquisition channel (TryBooking, walk-in, email, word-of-mouth)
- Loyalty programme: PinTuna members, engagement rate, spend correlation
- Segmentation: By event type, by frequency, by spend
6. Operations Dashboard
Daily operational status:
- Rostered staff: Today’s team, scheduled shifts, expected headcount
- Supplier status: Pending invoices, payment due dates, stock levels
- Incident log: Recent incidents (if integrated from incident reporting system)
- Quick links: Deputy scheduling, Xero P&L, TryBooking event management
Design Overhaul
As of April 2026, a UI/UX overhaul is planned to evolve Humphrey from its initial AI-generated aesthetic to a distinctive, premium product. The strategy adopts a three-layer approach: shadcn/ui + Radix for accessible component primitives, a deeply customised semantic token system built on Humphrey’s brand, and Motion (Framer Motion) + Next.js 16 View Transitions for interaction design. The visual direction evolves from “synthwave glow” to “theatrical dark” — retaining the dark-first palette and brand colours while replacing glow effects with restrained, layered surfaces. See Humphrey Design System for full specification.
Technical Architecture
Framework: Next.js 16 (App Router, React Server Components, Server Actions, React 19)
Database: Supabase PostgreSQL with Row Level Security
Hosting: Railway (app server) + Supabase Cloud (database, auth, storage)
ORM: Prisma (type-safe database queries, migrations, schema management)
Charts: Recharts v3 (React charts library, CSS custom property theming)
Authentication: Supabase Google OAuth (team already uses Google Workspace)
Styling: Tailwind CSS v4 + shadcn/ui + Radix UI primitives
Animation: Motion (Framer Motion) for component-level; View Transitions API for route-level
Background jobs: Railway cron jobs for nightly data pulls from Square, TryBooking, Xero, Deputy
AI integration: Anthropic API for:
- Email triage (summarise customer enquiries)
- Event discovery (scan community calendar for upcoming venues and trending events)
- Regulatory monitoring (track government correspondence and licensing deadlines)
Implementation Phases
| Phase | Deliverables | Timeline | Data Sources |
|---|---|---|---|
| Phase 1: MVP | Overview + Event P&L dashboards; event list | Weeks 1–2 | Square, TryBooking |
| Phase 2: Financial | Weekly P&L, cash forecast; Xero integration | Weeks 3–4 | Xero (post-cleanup) |
| Phase 3: Operations | Labour costs, customer segmentation | Weeks 5–6 | Deputy, PinTuna, Instagram |
| Phase 4: Intelligence | Integrated analysis, scenario planning, alerts | Weeks 7+ | All data sources |
Key Success Metrics
- Dashboard deployed and running within 2 weeks (MVP)
- Event P&L available within 24 hours of event close (automation)
- Weekly P&L delivered every Monday (reporting)
- Historical data (8 years) queryable for trend analysis (data retention)
- User adoption: Mat checking dashboard 5+ times/week within month 1
User Roles and Access Control
Supabase Row Level Security policies:
- Admin (Mat): Full access to all data (events, financials, staff, customer info)
- Operations (Monique): Access to roster, incidents, costs, venue operations (no customer PII or financials)
- Events (Emily): Access to event P&L, attendance, customer feedback; no staff costs
- Bookkeeper: Access to financial records (P&L, invoices, reconciliation); no operational data
- Viewer (stakeholder): Read-only access to overview dashboard only (no drill-down)
Cost and Infrastructure
Monthly cost estimate:
- Railway app server: $5–15
- Supabase database: $0 (free tier, 500MB; upgrade to Pro ($25) if database grows >500MB)
- Anthropic API (email triage, research): $5–15
- Total: $10–30/month
Scalability: Free tier supports 4–5 concurrent users; adequate for current team. Pro tier ($25/month) supports 100+ concurrent users if expanded during multi-venue rollout.
Risks and Mitigations
| Risk | Impact | Mitigation |
|---|---|---|
| Xero data quality | Dashboard shows garbage | Audit + cleanup before Phase 2; bookkeeper oversight |
| TryBooking attendance loss continues | Incomplete event analysis | Implement attendance scanning immediately |
| User adoption (Mat doesn’t check dashboard) | ROI zero; decisions remain manual | Personalised onboarding; weekly P&L email; alerts for key metrics |
| Scope creep (adding unnecessary features) | Delays MVP, bloats tech debt | Strict PRD discipline; monthly reviews; cut features if timeline at risk |
Custom Dashboard Validated (April 2026)
The Perplexity tech stack research evaluated all off-the-shelf analytics/BI platforms for entertainment venues and confirmed: no platform integrates with all four of Pride’s core systems (Square, Xero, TryBooking, Deputy). Entertainment venues are an underserved niche — every off-the-shelf product is restaurant-first with no event/ticketing analytics.
The Humphrey Intelligence App (Next.js + Supabase) remains the only path to a fully unified view across all data sources. This validates the build-vs-buy decision.
Complementary addition: Fathom ($65/month) for polished, board-ready P&L reports from Xero — visual dashboards, budget vs actual, scenario modelling. Does not replace Humphrey but fills the financial presentation gap.
See Tech Stack Optimisation for full stack assessment.
Related Pages
- Tech Stack — technology platform decisions enabling dashboard
- Humphrey Design System — design system and aesthetic direction
- Data Integration Architecture — ETL pipeline feeding dashboard
- Strategic Plan — dashboard as enabler for daily decision-making
- Automation Opportunities — automation tasks supporting data pipeline
- Tech Stack Optimisation — build-vs-buy validation
- Melbourne Venue Tech Stack Research — source: BI platform evaluation