S

Spotlio Capacity Intelligence

Multi-tenant ETL · session inventory · price decisions

Local demo tenant
Total Time Slots
Total Riders
Sessions Used
Avg Utilization
Overbooked Slots
Dates
Filters
Choose one or more
Choose one or more
Admin Workflow
Uploads, ETL status, and source history now live in the dedicated Data Sources page so the dashboard stays focused on operations.
Packages
Practice (1 sess)
Rookie (1 sess)
Qualifier (2 sess)
Checkered Flag (3 sess)
Victory Lane (4 sess)
The Chase (5 sess)
Champion (6 sess)
Open Near Full Full/Over
Race Date Time Venue Riders Sessions Used Capacity (28) Packages Sold Status
Workspace Access
Not connected
Connect Supabase to enable real login, tenant isolation, import history, and database-backed dashboard reads.
Running in local demo mode. Uploads are processed in-browser until Supabase is configured.
Admin Summary
Local mode
Tenant
Local demo tenant
Active workspace used by dashboard reads and imports.
Current User
Not logged in
Admin or tenant owner currently authenticated in this browser.
Project
Not configured
Supabase backend used for auth, storage, and tenant-scoped data.
Access Mode
Local Demo
Shows whether the app is running in local-only mode or cloud-backed tenant mode.
Admin Notes
A production admin area would also include invitations, role management, source mappings, and audit trails. This version now gives those operations a dedicated place instead of mixing them into the dashboard surface.
ETL Pipeline
Ready
1. IntakeUpload XLSX or CSV from third-party sales systems.
2. ValidateDetect duplicates, missing fields, and unknown packages.
3. NormalizeMap source rows into tenants, venues, events, sessions, orders, and prices.
4. PublishDashboard reads tenant-scoped database views after acceptance.
Next accepted upload will create an import batch locally, and in Supabase when connected.
Data Upload
Upload Net Daily Bookings files to update the dashboard without editing the HTML.
Source Registry
Seed data only
Accepted files are listed here so an admin can review what fed the tenant dataset and whether duplicates were accepted.
Source File Imported Rows Duplicates Storage
No uploaded source files yet. The tenant is using embedded seed data.