From raw restaurant bills to decision-ready insights.
This CodeAlpha project combines exploratory analysis, statistical thinking, anomaly detection, and data visualization to uncover restaurant spending and tipping patterns.
Analysis focus
- Data cleaning and quality checks
- Descriptive & statistical analysis
- Trends, anomalies, and decisions
Interactive reporting view
Dining-time comparison
Transactions analyzed
34
Rows in current filter
Average total bill
$19.28
Customer spend per table
Average tip
$3.19
Dollar-value gratuity
Average tip rate
16.5%
26 dinner transactions
Visualization 1
Average bill by day
The chart compares daily average bills in the currently selected dining-time segment.
Visualization 2
Bill amount versus tip amount
Each point represents a transaction. Its horizontal position is the bill amount and its vertical position is the tip.
Anomaly review
Highest-value transactions
Large bills are reviewed as potential high-value group opportunities, not automatically treated as errors.
| Day | Time | Party | Bill | Tip rate |
|---|---|---|---|---|
| Sat | Dinner | 4 | $39.42 | 19.2% |
| Sun | Dinner | 4 | $35.26 | 14.2% |
| Thur | Lunch | 6 | $34.30 | 19.5% |
| Fri | Dinner | 3 | $28.17 | 23.1% |
| Fri | Dinner | 2 | $27.05 | 18.5% |
Business story
What the analysis supports
Prioritize dinner service
Dinner records contribute a substantial share of higher-value transactions, making service consistency especially important.
Plan for groups
Larger parties generally produce higher total bills and larger tips, supporting proactive table allocation.
Track percentages too
Tip percentage adds context that dollar tips alone cannot provide and can surface service-quality opportunities.