The verdict in three sentences
In many distribution, construction and services companies in Dakar, Nairobi or Dubai, the CEO sees last month's revenue on the 10th or 15th of the following month, in a hand-consolidated Excel file. Power BI is the best choice when the team already uses Microsoft 365 and an in-house analyst can keep it alive; Metabase suits tight budgets with a technical profile in-house. A custom web cockpit built for mobile with WhatsApp alerts (FCFA 6,000,000 to 14,000,000, about USD 10,000 to 23,000, over 6 to 12 weeks) wins when decision-makers steer from their phones and data comes from mixed sources, provided the source data is cleaned up first.
What steering by Excel costs
The visible cost is the hours a financial controller spends consolidating each branch's files. The hidden cost is decisions made too late: idle stock, a project running over budget, a customer no longer profitable. In Dakar, an experienced financial controller costs FCFA 700,000 to 1,300,000 a month (USD 1,200 to 2,200); in Nairobi or Dubai, considerably more.
| Company size | Consolidation hours per month | Estimated monthly cost | Time until figures are available | Frequency of file discrepancies |
|---|---|---|---|---|
| 50 staff, 1 site | 20 h | FCFA 120,000 | 7 to 10 days | Occasional |
| 100 staff, 2 to 3 sites | 40 h | FCFA 250,000 | 10 to 12 days | Frequent |
| 200 staff, 4 to 6 sites | 70 h | FCFA 450,000 | 12 to 15 days | Frequent |
| 350 staff, subsidiaries | 110 h | FCFA 700,000 | 15 to 20 days | Systematic |
| 500 staff, multi-country | 160 h | FCFA 1,000,000 | 20 days or more | Systematic |
These are 2026 orders of magnitude. They exclude margins lost on projects tracked too late and stock-outs discovered by customers.
Power BI, Metabase or custom cockpit
| Criterion | Power BI Pro | Metabase open source | Custom web cockpit |
|---|---|---|---|
| Licences | About USD 14 per user per month (about FCFA 8,000) | Free self-hosted, paid cloud tier | No per-user licence |
| Setup | FCFA 3,000,000 to 8,000,000 | FCFA 2,000,000 to 5,000,000 | FCFA 6,000,000 to 14,000,000 |
| Annual cost for 20 users | FCFA 1,900,000 in licences + support | FCFA 600,000 to 1,200,000 hosting | FCFA 1,200,000 to 2,400,000 (hosting, maintenance) |
| Mobile reading | Decent, dedicated app | Average | Built for mobile, usable on 3G |
| Alerts | Email, Teams | Email, Slack | WhatsApp, SMS, email with business thresholds |
| Field data entry | No | No | Yes, forms for branches and sites |
| In-house skills required | Power BI analyst | SQL profile | None, maintained by the provider |
| Timeline | 4 to 8 weeks | 3 to 6 weeks | 6 to 12 weeks |
Power BI is powerful for analysis, but a CEO rarely opens a 12-tab report. They want 8 to 12 indicators, an alert when a threshold is crossed and the ability to drill down to one branch. A custom cockpit can also combine both: analysts keep Power BI, management gets a simplified mobile view.
The prerequisite: reliable source data
A dashboard is only as good as its data. Before any development, we audit sources (ERP, point-of-sale software, branch Excel files, banks, Wave, Orange Money or M-Pesa business accounts) and define each indicator in writing: formula, source, frequency, owner.
| Typical indicator | Source | Update frequency | WhatsApp alert |
|---|---|---|---|
| Revenue per branch | ERP or POS | Daily | -15% versus target |
| Gross margin per product family | ERP | Daily | Margin below set threshold |
| Available cash | Banks, mobile money | Daily | Below 30 days of fixed costs |
| Receivables over 90 days | Accounting | Weekly | 10% increase |
| Project progress and budget | Site manager input | Weekly | 5% budget overrun |
| Dead stock | Inventory management | Weekly | Over 120 days without movement |
This scoping phase takes 2 to 3 weeks and 15 to 25% of the budget. It is what prevents a dashboard nobody opens after three months.
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 Ndiaye, CEO of a building-materials distributor in Dakar (220 staff, 5 depots, FCFA 12 billion revenue, about USD 20 million), receives his figures on the 14th of the following month. His financial controller spends 70 hours a month consolidating. The custom cockpit, with WhatsApp alerts and daily depot input, is quoted at FCFA 11,000,000, plus FCFA 150,000 a month. In the second month, an alert reveals that one depot is selling a product family at a 4% margin instead of 11%. On FCFA 600,000,000 of annual sales for that family, fixing the discount policy brings in about FCFA 42,000,000 a year (about USD 70,000). The project pays back in under 4 months, and the controller gains 50 hours a month for analysis.
FAQ
Isn't Power BI enough if we already have Microsoft 365?
Often yes, for analysts. Budget about USD 14 per user per month and an in-house profile able to maintain reports. Custom is mainly justified for mobile reading, WhatsApp alerts and field data entry.
Does the cockpit work on a 3G connection?
Yes. Pages are light (under 300 KB) and indicators are pre-computed nightly or hourly.
Where is our data hosted?
Your choice: a host in Senegal, Kenya, the UAE, Europe or your own infrastructure, in line with local data protection law (Senegal's Law 2008-12, Kenya's Data Protection Act 2019, UAE PDPL).
How long until a first dashboard is live?
A first version with 6 to 8 indicators arrives in 6 weeks; the full multi-site scope in 10 to 12 weeks.
What if our data quality is poor?
The initial audit identifies it. We then plan FCFA 1,000,000 to 2,500,000 (USD 1,700 to 4,200) of clean-up and data-entry rules before building the cockpit.
Let's scope your project. Tell us your data sources, number of sites and the 10 indicators you want to track: we will scope a cockpit between FCFA 6,000,000 and 14,000,000 (USD 10,000 to 23,000), delivered in 6 to 12 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.
