Overview
Self-hosted Redash instance querying the client's Oracle ERP and two POS systems — giving category managers, buyers, and the MD a single SQL-powered BI layer without a dedicated data engineer.
The challenge
Category managers and buyers relied entirely on the IT team to extract data from the Oracle ERP. Every ad-hoc question — which SKUs haven't moved in 90 days, which stores are below target on soft furnishings — took two working days to get back as a spreadsheet. Slow-mover inventory was costing OMR 420k per year in tied-up capital.
The solution
We deployed Redash (self-hosted OSS edition) with a read-only PostgreSQL mirror of the Oracle ERP populated via a nightly Python ETL job — avoiding any direct production query risk. We built a library of 60 parameterised queries and dashboards covering sell-through rates, days-on-hand, and inter-store transfer opportunities. A scheduled Redash alert fires a WhatsApp message to the buying team every Monday morning listing any item over 90 days no-sale.
Outcomes
Buyers gained self-service analytics — IT data requests dropped to near zero
Slow-mover clearance programme drove a 29% reduction in 90-day no-sale inventory
Tied-up slow-mover capital released: OMR 122k in the first 6 months
MD's weekly performance review now runs from a Redash dashboard, not an Excel deck
Key metrics
Tech stack
Services
Client testimonial
“I used to wait two days every time I needed a number. Now I open Redash and the answer is there. The slow-mover alerts alone have already paid for this project many times over.”
— Chief Buyer, Basateen Retail · Muscat
Related work
SME lending platform · Riyadh
Daily 07:30 AST credit-portfolio briefing: 12-rule anomaly engine flags early-delinquency signals, auto-generates SAMA Fintech Unit-compliant risk summary PDF, and pushes WhatsApp alert to credit committee. Portfolio review prep 4 h → 19 min; delinquency early-detection rate rises from 41% to 89%.
Result:Portfolio prep 4h → 19min; early-delinquency detection 41% → 89%
Full-service digital marketing agency · Riyadh
Automated weekly client performance report: aggregates Google Ads, Meta, TikTok, and GA4 data, applies 9-rule anomaly engine, and delivers a branded Arabic PDF plus WhatsApp voice-note summary to each client. Report prep 3.5 h → 14 min per client; client churn drops 22%.
Result:Report prep 3.5h → 14min/client; client churn −22%
Long-haul trucking company (42 trucks) · Dammam–Riyadh corridor
Daily fleet-pulse report: GPS telematics anomaly engine (harsh braking, idle-excess, route deviations), automated SFDA waybill-compliance checks, and WhatsApp driver-alert system. Fuel cost per km drops 14%; SFDA compliance violations fall from 22/month to 1.
Result:Fuel cost/km −14%; SFDA violations 22 → 1/month
Book a free 30-minute audit, or message us on WhatsApp. We'll send a fixed-price proposal in two days.