The verdict in three sentences
For a Dubai headquartered distribution group operating in the UAE, Saudi Arabia and Oman, a custom multi-subsidiary sales dashboard costs in the order of 250,000 to 650,000 AED in 2026 with a regional agency, for 10 to 14 weeks of work. Most of the budget goes into connecting 3 different ERPs and building reliable consolidation rules by subsidiary, brand and salesperson, not into charts. Power BI, at 10 to 20 USD per user per month, remains a solid display layer; custom is justified when you want a mobile first tool for sales teams, with targets, alerts and business logic your staff cannot maintain inside a report file.
The real cost of late numbers
The CEO of a Dubai based distribution group often lives the same routine: each country extracts sales from its own ERP, a controller pastes them into a workbook, reworks them and emails them. Monthly figures arrive three weeks late, too late to rebalance stock between Jebel Ali, Riyadh and Muscat or to correct a brand's discount policy.
| Criterion | Emailed Excel workbooks | Power BI on manual exports | Power BI with a data warehouse | Custom app |
|---|---|---|---|---|
| Upfront cost | Near zero | Licences only | 150,000 to 350,000 AED integration (order of magnitude 2026) | 250,000 to 650,000 AED (order of magnitude 2026) |
| Recurring cost | Controller time | 10 to 20 USD per user per month | Licences plus warehouse hosting | Hosting plus maintenance |
| Time to available figures | 3 weeks | 1 to 2 weeks | Next day | Next day or real time |
| Connection to 3 ERPs | Manual | Manual | Automatic | Automatic |
| Mobile use by sales staff | No | Limited | Fair | Built for it, with individual targets |
| Alerts (margin, stock-out, target) | No | Basic | Possible | Native, via email, SMS or WhatsApp |
| Maintenance by your team | Easy | Medium | Needs a data profile | Handled by the vendor |
The expensive line in the last two options is the same: ERP integration. Once that layer exists, the display tool becomes a secondary choice.
What the budget covers
Cost depends on the number of source systems, master data quality (item, customer and salesperson codes that differ by country) and consolidation rules.
| Item | Scope | Share of budget | Timeline |
|---|---|---|---|
| KPI definition | Workshops with management and the 3 subsidiaries, KPI dictionary | 10 % | 2 weeks |
| ERP connectors | Daily extraction from 3 ERPs, interruption handling, error log | 30 % | 3 to 4 weeks |
| Shared master data | Mapping of items, brands, customers and sales reps across countries | 15 % | 2 weeks |
| Multi-currency consolidation | Sales in AED, SAR and OMR, purchases in USD and EUR, monthly rates, VAT differences | 10 % | 1 to 2 weeks |
| Dashboards | Group, country, brand and salesperson views; mobile and desktop | 25 % | 3 weeks |
| Alerts and targets | Margin thresholds, stock-outs, monthly target tracking | 10 % | 1 week |
For reference, Kolonell prices this scope in its complex tier, 7,000,000 to 15,000,000+ FCFA (10,670 to 22,870+ EUR), or medium, 4,000,000 to 7,000,000 FCFA (6,100 to 10,670 EUR) when only one subsidiary is connected first. Maintenance is 35,000, 75,000 or 120,000 FCFA per month (53, 114 or 183 EUR); hosting is quoted separately.
Pitfalls specific to a GCC multi-country group
The first pitfall is master data: the same item often carries three codes in three ERPs. Without a mapping table validated by the business, brand rankings will be wrong. Allow 2 weeks of sales team time to validate it.
The second is currency and tax: AED, SAR and OMR are all pegged to the USD, but VAT differs (5 % in the UAE and Oman, 15 % in Saudi Arabia), so margins must be consolidated net of VAT with clear monthly rates. The third is data residency and access: some Saudi entities prefer data hosted in the Kingdom under the Personal Data Protection Law, and a rep in Muscat should only see his own portfolio, a country manager his country, the group CEO everything. Define these rights during discovery, not after go live.
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.
Khalid, CEO of a distribution group with 1.8 billion AED in revenue across three countries, estimates that stock-outs and poorly allocated inventory cost him 0.5 % of revenue in lost margin, or 9 million AED a year. With next day figures and stock-out alerts, he aims to recover half of it, 4.5 million AED.
Add consolidation time: 3 controllers spend 5 days a month each, or 180 days a year. At a fully loaded cost of 1,500 AED per day, that frees 270,000 AED for analysis. For a 450,000 AED custom build, the combined annual gain of about 4.8 million AED pays back in about one month. Even if only the controller time saving materialised, payback would come in about 20 months.
FAQ
Do we need to replace our ERPs first?
No. The dashboard connects to the 3 existing ERPs through their databases or automated exports. A later ERP change only requires replacing one connector, about 2 to 3 weeks.
Why not just buy Power BI?
Power BI is an excellent display tool at 10 to 20 USD per user per month, but it does not solve ERP connections or master data. A hybrid with a custom data warehouse and Power BI for management is often the right answer.
Can sales reps check their figures on mobile?
Yes, with a view limited to their portfolio and monthly targets. Screens are designed to load in under 3 seconds even on weak connections in the field.
How long does rollout take?
Plan 10 to 14 weeks. Starting with the UAE entity, then Saudi Arabia and Oman, shows results from week six.
How are currencies handled?
Sales in AED, SAR and OMR and purchases in USD and EUR are converted at a monthly rate set by group finance. Consolidated margins stay comparable month to month.
Let's scope your project. Tell us about your subsidiaries, your ERPs and the indicators management expects every morning, and we will scope the build and a country by country rollout over 10 to 14 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.