Dashboard Overview

Last 7 days ยท Bella Cucina Restaurant

Live Data
๐Ÿ’ฐ
$591.50
โ†‘ 12.4% vs last week
๐Ÿงพ
8
โ†‘ 3 more than last week
๐Ÿ“‹
$73.94
โ†‘ 5.2%
๐Ÿ’ธ
$62.00
โ†‘ 8.1%

Revenue by Day Last 7 days

Revenue by Category All time

Peak Hours Orders by hour

Payment Methods Distribution

Customers

RFM segmentation and loyalty

Customer Segments RFM model

Top Customers By total spend

CustomerOrdersSpentPointsSegment

Orders

Recent and active orders

All Orders Last 7 days

OrderTableCustomerWaiterItemsTotalStatusTime

Database Schema

All tables ยท Normalized to 3NF ยท PostgreSQL

SQL Queries

Complex queries, views & stored procedures