Diaspora AI Dashboard

Diaspora AI Dashboard is a comprehensive analytics and operations dashboard for the Diaspora AI travel booking platform. Monitor bookings, revenue, customer support, and business metrics in real-time.

The Problem

Running a travel booking platform requires constant visibility into:

• Revenue & Profit - Are we making money? Where are the losses?
• Booking Health - What's our success rate? Why are bookings failing?
• Customer Support - How do we handle inquiries at scale without hiring a team?
• Visa Guidance - How do we answer the same visa questions 100 times a day?

I needed a single dashboard that answered all of these questions in real-time.

What I Built

📊 Analytics Dashboard

Revenue Metrics: Real-time tracking of total revenue, profit, and refunds with period-over-period comparison.

Booking Analytics: Visualize ticketed vs failed bookings over time with VisActor-powered charts.

Conversion Tracking: Monitor booking conversion rates and identify drop-off points.

Channel Analysis: Track customer inquiries across WhatsApp, web, and other channels.

Customer Satisfaction: Gauge-based visualization of satisfaction scores.

✈️ Flight Booking Management

Booking Overview: View and manage all flight bookings in one place with status indicators.

Multi-Currency Support: Handle bookings across 100+ currencies with automatic conversion.

Payment Gateway Integration: Track Stripe and Paystack transactions with fee calculations.

Profit Calculation: Automatic markup and fee calculation per booking:

• Stripe: 2.9% + $0.30 per transaction
• Paystack: 1.5% + ₦50 per transaction
• Custom markup tracking per booking

💬 WhatsApp AI Support System

This is where it gets interesting. I built a fully autonomous AI support agent:

AI-Powered Auto-Replies: OpenAI GPT-4o-mini handles customer conversations intelligently.

Secure Booking Lookup: AI verifies email/phone before sharing any booking details 🔐

Multi-Layer Verification:

1. Customer asks about booking
2. AI requests email verification
3. AI cross-checks email + WhatsApp number + passenger name
4. Only then shares booking details

Function Calling: AI uses OpenAI function calling to query the live database - not canned responses, real data.

Human Handover: Seamless transition from AI to human agents when needed. Customer says "I need a human" and mode switches instantly.

Bidirectional Mode: Agents can switch any conversation between AI and Human mode from the dashboard.

🛂 Visa Guide System

Natural Language Queries: "Do I need a visa for UK?" → AI provides complete requirements.

12+ Destinations Supported: UK, USA, Canada, France, Germany, Netherlands, UAE, Turkey, South Africa, Kenya, Nigeria, Rwanda.

Comprehensive Information:

• Embassy addresses, phone numbers, websites
• Required documents checklist
• Processing times and fees
• Destination-specific travel tips

Tech Stack

Core Framework

• Next.js 15 - React framework with App Router
• TypeScript - Full type safety throughout
• Tailwind CSS - Styling
• Shadcn UI - Component library

Data & Visualization

• VisActor - Advanced chart library for analytics
• Supabase - PostgreSQL database (shared with main platform)
• Jotai - State management

Customer Support

• Twilio WhatsApp API - WhatsApp Business messaging
• OpenAI GPT-4o-mini - AI-powered support with function calling

Dashboard Features

Main Dashboard (/)

• Revenue metrics with period comparison
• Booking trends bar charts
• Conversion funnel visualization
• Channel distribution gauges
• Real-time satisfaction metrics

Flight Bookings (/ticket)

• All bookings with status indicators (ticketed, failed, refunded)
• Search by passenger name or booking reference
• Detailed view: routes, dates, passengers, payment method
• Markup and profit calculations per booking

WhatsApp Support (/support)

• Real-time conversation management
• WhatsApp-style chat UI
• AI/Human mode toggle per conversation
• Full conversation history with context
• Smart duplicate message filtering

AI Support Flow

Customer: "Can you check my booking ABC123?"
     ↓
AI: "I'd be happy to help! For security, please confirm 
     the email address used for this booking."
     ↓
Customer: "john@example.com"
     ↓
AI: [Verifies email matches booking + WhatsApp number]
     ↓
AI: "Great! I found your booking. You're flying from 
     Lagos (LOS) to New York (JFK) on December 28th 
     with EgyptAir. Your booking is confirmed and 
     ticketed. The total was £1,926.49..."

All verification happens automatically. No human needed for 90%+ of inquiries.

Integration Architecture

This dashboard connects to the main Diaspora AI platform:

Shared Database: Same Supabase instance as the booking platform

• booking table - Flight booking records
• conversations table - WhatsApp support threads
• messages table - Individual messages
• agents table - Support agent records

Real-Time Sync: Changes in the main platform reflect instantly in the dashboard.

Consistent Calculations: Same profit/fee logic across both systems.

Why It Matters

Building this dashboard taught me:

• Real-time data systems - Live updates across multiple dashboards
• AI agent design - Building autonomous systems that handle edge cases
• Security in AI - Never trust user input, always verify before revealing data
• Multi-channel support - Same backend, different interfaces (WhatsApp, web, future: voice)

The WhatsApp AI support alone saves hours per day that would otherwise go to answering "What's my booking status?" questions.

Deployment

Deployed on Vercel with:

• Twilio webhooks for WhatsApp
• Supabase for real-time database
• OpenAI for AI responses
• Automatic scaling for traffic spikes

Part of the Diaspora AI ecosystem. Built by Travis Moore (Angelo Asante).

Main Platform · Dashboard