Overview
Combined Redash analytics layer and self-hosted Appsmith operator console replacing spreadsheets and aggregator portals — giving kitchen managers real-time order flow, prep-time SLAs, and AI-predicted demand spikes visible on a single screen.
The challenge
Three dark-kitchen sites ran 6 brands across Jahez, Hungerstation, and Talabat. Kitchen managers toggled between three aggregator tablets and a WhatsApp group to track order status, leading to a 24% prep-time SLA breach rate and chronic over-ordering of perishable ingredients. There was no demand forecasting — ingredient waste averaged 19% of food cost monthly.
The solution
We built the operator console on self-hosted Appsmith, normalising real-time webhook feeds from all three aggregators into a single PostgreSQL orders table. A Node.js bridge translates each aggregator's webhook schema into a canonical order event. The Redash layer sits on the same PostgreSQL instance, providing shift-end analytics on prep times, brand-level order mix, and ticket size. Gemini powers a demand-forecasting model trained on 14 months of historical order data, surfaced in Appsmith as a 4-hour ahead ingredient staging recommendation.
Outcomes
Prep-time SLA breach rate dropped from 24% to 4% in the first month
Gemini demand-spike predictions achieved 81% accuracy at the 4-hour horizon
Ingredient waste down 19 percentage points from food-cost baseline
Kitchen managers reduced aggregator screen-switching from 3 tablets to 1 console
Key metrics
Tech stack
Services
Client testimonial
“My kitchen managers were literally juggling three tablets. Now one screen tells them everything — what's cooking, what's at risk, and what to prep for the dinner rush. The waste savings alone cover the project cost.”
— CEO, Jood Dark Kitchen · Riyadh
Related work
Cloud accounting firm (55 SME clients) · Manama
Custom Xero add-on with VAT-return automation for Bahrain NBR format, anomaly flagging, and Arabic client-summary PDF. VAT prep per client 2.8 h → 17 min; NBR submission errors drop to zero.
Result:VAT prep 2.8h → 17min/client; NBR errors → 0
Regional courier & last-mile operator · Riyadh
Self-hosted Appsmith workspace with 14 custom apps covering dispatch, driver ledger, and SLA breach alerts — replacing a patchwork of spreadsheets and a legacy VB system.
Result:Dispatch cycle 22min → 4min; SLA breach rate 18% → 3%
Digital news & lifestyle media group (4 titles) · Kuwait City
Self-hosted Directus instance as the content backbone for four Arabic-first digital titles — enabling editorial teams to publish bilingual articles, photo galleries, and newsletters without touching code.
Result:Publishing cycle 4h → 18min; dev dependency for content changes 0%
Book a free 30-minute audit, or message us on WhatsApp. We'll send a fixed-price proposal in two days.