The verdict in three sentences
For a Dubai distributor turning over more than 20 million USD, a custom data warehouse costs between 40,000 and 80,000 USD and ships in 10 weeks. The main gain is next-day consolidation of sales, inventory and collections, instead of an Excel file rebuilt by hand every Monday. With PostgreSQL and Metabase, two open source building blocks, you pay no per-user licence and you keep full ownership of your data.
The problem: six sources, one Excel file, one week late
The managing director of a consumer goods distributor in Dubai gets the weekly report on Tuesday at noon. In the meantime, the financial controller has exported the ERP (SAP Business One or Odoo), the warehouse system, payment gateway reports, the field sales spreadsheet, bank statements and delivery tracking. Six sources, six formats, and gaps nobody can explain before the management meeting.
A data warehouse fixes this in three layers: connectors that extract data from each source every night, a PostgreSQL database that cleans and reconciles it according to rules written once, and Metabase dashboards readable on desktop and mobile.
| Indicator | Before (manual Excel) | After (warehouse + Metabase) |
|---|---|---|
| Data freshness | D+7 to D+8 | D+1, refreshed at 6 am |
| Consolidation time | 2 days per week | 15 minutes of checks |
| Reconciled sources | 6, by hand | 6, automatically |
| Unexplained stock gaps | 3 to 5% | under 1% after rules |
| Mobile access for management | None | Dashboards on phone |
| Usable history | 12 scattered months | 5 years in one database |
2026 budget: what each component costs
The budget depends mostly on the number of sources and the quality of existing data. A clean customer master halves the cleansing work. Here is a 2026 order of magnitude for a mid-sized distributor in Dubai.
| Item | Range (USD, excl. VAT) | Share of budget |
|---|---|---|
| Scoping, mapping of the 6 sources, KPI dictionary | 4,000 to 8,000 | 10% |
| Connectors: ERP, WMS, payment gateway, bank | 12,000 to 24,000 | 30% |
| PostgreSQL modelling and reconciliation rules | 10,000 to 21,000 | 26% |
| Metabase dashboards (executive, sales, stock, cash) | 8,000 to 16,000 | 20% |
| Acceptance testing, training, documentation | 6,000 to 11,000 | 14% |
| Total project | 40,000 to 80,000 | 100% |
| Monthly hosting and maintenance | 600 to 1,400 / month | recurring |
For comparison, Power BI Pro with an integrator costs around 14 USD per user per month, plus an integrator billed by the day. For 40 users, the licence alone exceeds 6,700 USD per year, plus lock-in to a proprietary ecosystem. Self-hosted Metabase carries no licence fee.
Typical 10-week plan
Weeks 1 and 2 cover scoping: KPI list, exact definition of "net revenue" or "stock-out", access to sources. Weeks 3 to 6 cover connectors and modelling. Weeks 7 and 8 deliver dashboards by role. Weeks 9 and 10 run acceptance testing in parallel with the old Excel file, then switchover.
Mini case study
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Omar, managing director of a beverage and grocery distributor in Dubai (28 million USD revenue, 3 warehouses), ties up his financial controller 2 days a week on consolidation. Fully loaded cost of that role: about 9,000 USD per month, so 3,600 USD per month spent on the Monday file alone, or 43,000 USD per year. The chosen project costs 55,000 USD with 1,000 USD monthly maintenance. Time savings alone pay back most of the investment within 15 months. The real return comes from elsewhere: by spotting at D+1 a warehouse whose stock-out rate exceeded 8%, Omar recovered about 240,000 USD of lost sales over the year, paying back the project in under 3 months.
FAQ
Do we need to replace our ERP before launching a data warehouse?
No. The warehouse plugs into the existing ERP, whether SAP Business One, Odoo or a regional package. In 80% of cases, a read-only database connection or an automated nightly export is enough.
Why PostgreSQL and Metabase rather than Power BI?
Both are open source, with no per-user licence, and run on a server costing about 100 USD per month. Power BI remains relevant if you already run Microsoft 365 and have fewer than 10 users.
Can payment gateway transactions be reconciled automatically?
Yes, through merchant exports or provider APIs. Matching with invoices uses reference and amount, with an automatic match rate of 90 to 95% after tuning.
How long before management actually uses the dashboards?
Allow 4 to 6 weeks after switchover. Stopping the Excel file after one month speeds up adoption noticeably.
Is our data protected?
Hosting can be in the UAE or in Europe, with encryption and role-based access. The UAE Personal Data Protection Law (PDPL) is addressed from scoping.
Let's scope your project. Send us your list of sources and key indicators and we will price a data warehouse between 40,000 and 80,000 USD, delivered in 10 weeks. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
