Business Intelligence Dashboard

Advanced analytics, strategic insights, and data-driven decision making for restaurant excellence.

Key Performance Indicators

+18.5%
Revenue Growth

Year-over-year increase

Target: +15% ✓
24.3%
Profit Margin

Net profit percentage

Industry avg: 18%
4.7/5
Customer Satisfaction

Average rating

Top 10% in area
92%
Operational Efficiency

Overall performance

Excellent rating

Revenue Analytics & Trends

Performance Indicators
Average Order Value
Per customer transaction
£28.50
+12%
Table Turnover Rate
Tables per hour
2.8
+8%
Food Cost Percentage
Cost of goods sold
28.5%
-2%
labour Cost Percentage
Staff costs vs revenue
32.1%
0%
Customer Retention Rate
Repeat customers
68%
+5%
Strategic Insights
  • Weekend revenue 35% higher - consider dynamic pricing
  • Seafood dishes have highest profit margins (42%)
  • Lunch service underperforming - opportunity for growth
  • Customer wait times correlate with satisfaction scores
  • AI Recommendation: optimise menu layout for higher-margin items
  • Trend Alert: Plant-based options showing 28% growth
Predictive Analytics
Next Month Revenue Forecast:
£72,500 (+8.2% growth predicted)
Peak Day Prediction:
Saturday (95% confidence)
Inventory Alert:
Salmon stock low by Thursday
Smart Business Alerts
Food costs increased 3% this month - review suppliers
Customer satisfaction up 5% - great job team!
Revenue target 95% achieved this month
Peak hour staffing may be insufficient for weekend
Industry Benchmarks
Revenue per Seat £145/day
Industry avg: £120/day
Customer Satisfaction 4.7/5
Industry avg: 4.2/5
Staff Productivity £285/hour
Industry avg: £240/hour

Customer Analytics & Behaviour

Customer Demographics
Age 25-34

32%

Largest segment
Families

28%

Weekend focus
Business

24%

Lunch crowd
Seniors

16%

Early dining
Peak Hours Analysis
Lunch Peak

12-2 PM

85% capacity
Dinner Peak

7-9 PM

95% capacity
Weekend Brunch

10-12 PM

78% capacity

Menu Performance Analysis

Top Performing Dishes
Dish Orders Revenue Profit Margin Rating Trend
Grilled Salmon 342 £8,208 42% 4.8/5 +15%
Beef Wellington 198 £7,128 38% 4.9/5 +8%
Vegetarian Risotto 287 £5,453 35% 4.6/5 +22%
Fish & Chips 456 £6,384 28% 4.4/5 0%
Chicken Tikka 234 £4,212 31% 4.5/5 -5%
Menu optimisation
High Performers

Salmon and Wellington driving 35% of profit. Consider featuring more prominently.

Growing Trends

Vegetarian options up 22%. Expand plant-based menu for health-conscious customers.

Underperformers

3 dishes below 25% margin. Review recipes or consider removal.

Seasonal Insights
Summer Menu Performance:
78%
Above seasonal average
Recommended Additions:
  • Cold soups and gazpacho
  • Grilled vegetable platters
  • Fresh fruit desserts
  • Light seafood options

Financial Reports & Forecasting

Upload Financial Data

Upload your revenue forecasts, budget data, and financial projections to enhance AI-powered analytics and predictions.

Revenue Forecast

Upload monthly/quarterly revenue projections (CSV, Excel)

Drag & drop files here or browse

Budget Data

Upload operational budgets and cost projections (CSV, Excel)

Drag & drop files here or browse

Cash Flow Projections

Upload cash flow forecasts and liquidity planning (CSV, Excel)

Drag & drop files here or browse

Supported File Formats
  • CSV: Comma-separated values with headers (Date, Amount, Category, Notes)
  • Excel: .xlsx or .xls files with structured data in first sheet
  • Template: Download sample template for proper formatting
Monthly P&L Report

Comprehensive profit and loss analysis with year-over-year comparisons.

Last updated: Today
Cash Flow Analysis

Daily cash flow tracking with predictive modeling for next 30 days.

Auto-generated daily
Cost Breakdown

Detailed analysis of all operational costs with optimisation recommendations.

Weekly analysis
Revenue Forecast

AI-powered revenue predictions based on historical data and market trends.

Updated hourly
Staff Performance

Individual and team performance metrics with productivity insights.

Real-time tracking
Customer Insights

Customer behaviour analysis, satisfaction trends, and loyalty metrics.

Daily updates

AI Kitchen Intelligence

Hello! I'm your AI Kitchen Intelligence assistant. I can help you analyse business data, interpret financial trends, and provide strategic insights for your restaurant operations.