The verdict in three sentences
A consumer goods distributor that waits 10 days to see the month's figures is steering by the rear-view mirror: stock-outs, excessive discounts and declining territories are discovered too late. A data warehouse fed nightly by the ERP and daily dashboards by rep, territory and brand cost 6 to 18 million FCFA (about EUR 9,100 to 27,400) in 2026 in Abidjan, and the same scope in Singapore usually costs two to three times more in SGD. Add USD 10 to 20 per user per month of BI licence, a modest recurring budget given what is at stake.
Why figures arrive 10 days late
At most mid-sized Ivorian distributors, the flow looks like this: the ERP (Sage, Odoo, SAP Business One or a local solution) records invoices and credit notes, reps send orders via WhatsApp or a field app, then the finance controller exports, cleans and consolidates in Excel.
Typical bottlenecks:
- Credit notes and returns are entered late, so raw figures are wrong until closing.
- Customer codes differ between the ERP and the field app, so consolidation is manual.
- The master data for 3,000 outlets (territory, channel, rep) is not maintained.
- Only one controller knows how to produce the report, spending 4 to 6 days a month on it.
| Metric | Current situation | With a connected dashboard |
|---|---|---|
| Sales data availability | D+10 after month end | D+1, every morning |
| Consolidation time | 4 to 6 days a month | Less than half a day of checks |
| Level of detail | Total by brand | Rep, territory, outlet, SKU |
| Target tracking | Monthly | Daily, with pro rata variance |
| Stock-out detection | Through customer complaints | Alert on sales drop per outlet |
| Mobile access for reps | None | Personal view on smartphone |
What the project costs in 2026
The budget depends on the number of sources to connect and on data quality. The amounts below are 2026 orders of magnitude for Abidjan.
| Scope | Content | 2026 budget | Timeline |
|---|---|---|---|
| Dashboards on the ERP only | Direct connection, 5 to 8 reports | 6,000,000 to 9,000,000 FCFA | 6 to 8 weeks |
| Data warehouse + ERP | Nightly extraction, sales model, 10 to 15 reports | 9,000,000 to 13,000,000 FCFA | 2 to 3 months |
| Multi-source warehouse | ERP + field app + depot stock | 13,000,000 to 18,000,000 FCFA | 3 to 4 months |
| BI licences (Power BI, Looker Studio Pro, hosted Metabase) | Per user | USD 10 to 20 a month, i.e. 6,000 to 12,000 FCFA | Ongoing |
| Warehouse hosting | Cloud database, backups | 80,000 to 250,000 FCFA a month | Ongoing |
| Maintenance and changes | New reports, pipeline fixes | 150,000 to 400,000 FCFA a month | Ongoing |
For 30 users (25 reps, 3 territory managers, 2 directors) at USD 15, licences come to about 270,000 FCFA a month.
Dashboards that actually get used
A good project sticks to a few views used every day rather than 40 reports nobody opens:
- Rep view: sales for the day and the month, pro rata target, top 10 declining outlets.
- Territory view: rep ranking, coverage (outlets visited and ordering), average basket.
- Brand view: sales by SKU, share of discounts, stock turnover per depot.
- Management view: revenue net of credit notes, gross margin, receivables and late payments.
The essential prerequisite is clean master data for the 3,000 outlets, with a unique code shared by the ERP and the field app. This cleanup often takes 20 to 30% of project time.
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.
Mr Kouassi, sales director of a beverage and grocery distributor in Abidjan Koumassi (illustrative persona), generates 9 billion FCFA of annual revenue with 25 reps.
- Consolidation time saved: 5 days a month of a controller costing 900,000 FCFA a month fully loaded, i.e. about 2.4 million FCFA a year.
- Conservative assumption: reacting 3 weeks earlier on declining outlets recovers 0.3% of revenue, i.e. 27 million FCFA, and about 4 million FCFA of gross margin at 15%.
- Budget: warehouse + ERP at 11 million FCFA, then about 600,000 FCFA a month for licences, hosting and maintenance (7.2 million a year).
- Estimated annual gain: 2.4 + 4 = 6.4 million FCFA, close to the recurring cost in year one, with the real gain depending mostly on how much reps and territory managers use it.
This calculation shows one thing: the project pays back through the commercial decisions it enables, not through reporting time saved.
FAQ
Do we need to change ERP to get daily dashboards?
No. Sage, Odoo or SAP Business One allow nightly extraction of invoices, credit notes and stock. Changing ERP often costs 30 to 100 million FCFA, which is not justified for reporting alone.
Power BI or an open source tool?
Power BI costs about USD 14 per user per month and integrates well with Excel. Hosted Metabase or Superset avoid per-user licences but require 80,000 to 150,000 FCFA a month of hosting and monitoring.
Can reps check their figures on a smartphone?
Yes, each rep sees only their own portfolio. An optimised mobile view uses little data, under 1 MB per check, which matters on 4G networks during field rounds.
How long before the first usable dashboard?
Allow 4 to 6 weeks for a first rep view on ERP data, then 1 to 3 months for the other views and additional sources.
Who maintains the data pipelines after delivery?
A maintenance contract of 150,000 to 400,000 FCFA a month covers monitoring of nightly extractions, fixes and 1 or 2 new reports per quarter.
Let's scope your project. Tell us about your ERP, your field tool and your number of users: we will price the data warehouse and dashboards, with a budget of 6 to 18 million FCFA and a first report in 4 to 6 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.
