Synthetic Fooddelivery Dataset

By shrijeetverma13 · March 13, 2026

Data source:

The Ayam (Chicken) category dominates both metrics — it generates the highest total revenue at Rp 539,703,000 and also has the highest average order value at Rp 178,120 per order. A grouped bar chart and data table have been generated to compare all menu categories side by side.

The bar chart shows the order cancellation rate (percentage of orders with 'Dibatalkan' status) for each menu category (Kategori Menu). The visualization ranks categories from highest to lowest cancellation rate, making it easy to spot which menu types have the most and least cancellations.

The bar chart shows how average waiting time (Waktu Tunggu Menit) varies across different complaint severity levels (Tingkat Keluhan). Each bar represents the mean wait time for customers at each complaint level, making it easy to spot which levels experience longer or shorter waits.

The bar chart shows the distribution of order statuses (Status Pesanan) across all complaint levels (Tingkat Keluhan): Tidak Ada, Rendah, and Tinggi. The highest complaint level identified in the data is 'Tinggi'. The visualization clearly compares how many orders at each complaint level ended up cancelled (Dibatalkan) versus other statuses.

Here are the analysis results. Check the visualizations and data below.

A box plot has been generated comparing customer ratings (Rating Pelanggan) between promo and non-promo orders. The visualization shows the distribution of ratings for each group, allowing you to visually compare whether promo orders tend to receive higher ratings than non-promo orders.

Martabak has the highest proportion of severe (Tinggi) complaints among all menu categories, with 13.29% of its orders resulting in severe complaints — that's 219 out of 1,648 orders. A bar chart has been generated showing the full ranking of severe complaint proportions across all Kategori Menu categories.

A data table has been generated showing order volume broken down by hour of the day from the Waktu Transaksi field. You can review the table to identify which hours have the highest number of orders throughout the day.

The average Harga Pesanan for promo vs non-promo orders differs significantly across menu categories. A grouped bar chart and summary table have been generated to visualize these differences clearly.

Yes, longer delivery distances do tend to receive slightly lower customer ratings, but the effect is modest. The correlation coefficient of -0.2478 indicates a weak negative relationship — meaning as delivery distance increases, ratings decrease slightly, but distance alone is not a strong predictor of customer satisfaction. Two visualizations were generated: a bar chart showing average ratings across distance ranges (0-25 KM) and a scatter plot with a trendline confirming the mild downward trend.

The 'Mie' (Noodle) category has the longest average Waktu Tunggu Menit at 23.2 minutes, making it the top priority for operational improvement. A bar chart and data table have been generated showing the full ranking of all menu categories by average wait time.

The analysis reveals two different winners depending on the metric. Monday has the highest order volume with 1,037 orders, while Friday generates the highest revenue at Rp 141,691,500. A bar chart and full breakdown table have been generated to visualize both metrics across all days of the week.

The customer rating distribution varies notably across order statuses. Completed orders (Selesai) have the highest average rating of 4.23, while cancelled orders (Dibatalkan) score the lowest at 3.66, and refunded orders (Refund) fall in between at 3.84. Two histogram and box plot visualizations were generated, along with detailed percentage breakdown tables.

Promo orders are marginally MORE likely to be cancelled compared to non-promo orders, though the difference is very small. The grouped bar chart and data tables clearly show the breakdown of order statuses for both promo and non-promo orders.

High Harga Pesanan (order price) orders do NOT consistently outperform lower-priced orders. While the Very High price tier has the best average rating (4.21), the difference across all tiers is minimal — ranging only from 4.12 to 4.21. Interestingly, high-price orders actually have a slightly higher complaint rate, with only 67.8% reporting no complaints compared to 70.2% for Very Low price orders. The charts generated show these patterns clearly across both metrics.

The analysis shows that the 0-3 KM delivery distance range delivers the best combination of high customer ratings and low complaint scores. A bar and line chart was generated showing how average ratings and complaint scores vary across different distance ranges, making it easy to compare performance visually.

Based on the analysis, complaints (Tingkat Keluhan) significantly increase at the 22-24 KM delivery distance range, where the complaint rate jumps by 40 percentage points. The overall complaint rate across all deliveries is 31.4%, but complaints begin exceeding the average (120% threshold) as early as the 8-10 KM range. A visualization was generated showing complaint rates across all distance bins.