The verdict in three sentences
A mid-market company that waits until the 15th of the month to know its revenue is making decisions on six-week-old data. An executive dashboard fed by ERP and CRM data, with a data warehouse and connectors, costs roughly 16,000 to 44,000 USD (15,000 to 40,000 EUR) in 2026 and is delivered in 2 to 4 months. Stick to 10 to 20 key indicators refreshed hourly: beyond that, nobody reads them.
Why monthly reporting always arrives too late
The usual process is well known. The financial controller exports sales from the ERP, opportunities from the CRM, payroll data from a third tool, then consolidates everything in Excel. They fix duplicates, match customer codes and recompute margins. The file reaches the executive committee around the 15th, sometimes the 20th, and the numbers are still debated because each department has its own calculation.
The cost is not only the controller's time, often 3 to 5 days a month. It is mostly reaction delay: margin slippage on a product line, a shrinking order book or a customer who stops paying only shows up six weeks later. For a company with 55 million USD in revenue, one point of margin lost for six weeks is worth about 65,000 USD.
What a real dashboard project includes
The visible dashboard is the tip of the iceberg. Underneath, you need connectors that extract data from the ERP (NetSuite, SAP Business One, Dynamics, Odoo, Sage) and the CRM, a data warehouse that cleans and historizes it, a definitions layer where each indicator has a single formula approved by finance, and the visualization tool with mobile access and role-based permissions.
| Component | 2026 market range (excl. tax) | Note |
|---|---|---|
| Indicator scoping and definitions | 2,200 to 5,500 USD | Workshops with each department |
| ERP and CRM connectors | 4,400 to 13,000 USD | Higher for legacy ERPs without APIs |
| Data warehouse and transformations | 5,500 to 13,000 USD | Historization, data quality |
| Dashboards and mobile access | 3,300 to 8,800 USD | 10 to 20 indicators, 3 to 5 views |
| Permissions, security and testing | 1,100 to 3,300 USD | Access by function and subsidiary |
| Total project | 16,000 to 44,000 USD | 2 to 4 months |
| Visualization licenses | 10 to 20 USD per user per month | Power BI, Looker Studio Pro, hosted Metabase |
| Warehouse hosting | 100 to 550 USD per month | Depends on volume and refresh rate |
Hourly refresh covers 95% of executive needs. True second-by-second real time only makes sense for logistics or production, and it doubles or triples infrastructure cost.
Indicators by function
The table below is a starting point. The goal is not to take everything, but to pick three or four indicators per function, the ones that trigger a decision.
| Function | Key indicators | Source | Useful frequency |
|---|---|---|---|
| CEO | Month-to-date revenue, gross margin, closing forecast | ERP, CRM | Hourly |
| Sales | Order backlog, weighted pipeline, win rate | CRM | Hourly |
| Finance | Receivables, late payments, 13-week cash forecast | ERP, bank | Daily |
| Purchasing and inventory | Stock value, stockouts, turnover by family | ERP | Daily |
| Operations | Service level, delivery lead times, defect rate | ERP, MES | Hourly |
| Human resources | Headcount, absenteeism, monthly payroll cost | Payroll, HRIS | Monthly |
| Marketing | Cost per lead, qualified leads, online share of sales | CRM, ad platforms | Daily |
The definitions trap
Half of dashboard projects fail for a non-technical reason: sales and finance do not calculate revenue the same way. Booked or invoiced, before or after credit notes, with or without freight. Scoping must produce an indicator dictionary signed off by the CFO before a single line of code. That document is what ends the debates in committee.
At Kolonell, this kind of steering platform is a complex custom application, 7,000,000 to 15,000,000+ FCFA (10,670 to 22,870+ EUR) depending on the number of sources and subsidiaries, with maintenance from 75,000 to 120,000 FCFA a month (114 to 183 EUR).
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Mini case study
Laura, CEO of a 180-employee building materials distributor in Atlanta, runs 52 million USD in revenue. Her controller spends 4 days a month on reporting, 48 days a year at 500 USD loaded per day: 24,000 USD a year.
The project costs 30,000 USD, plus 25 users at 15 USD a month and 270 USD of hosting, or about 7,700 USD a year. The controller now spends half a day a month on checks, so time savings already cover most of the recurring cost. The real gain lies elsewhere: a 1.5 point margin slip on a 9 million USD product line is spotted in ten days instead of six weeks. One month of reaction gained is worth 9,000,000 × 1.5% ÷ 12 = 11,250 USD preserved, on a single incident.
FAQ
Do we need a data warehouse, or can the tool connect straight to the ERP?
A direct connection works for 3 to 5 simple indicators. Beyond that, a warehouse becomes essential to combine ERP and CRM, keep history and avoid slowing down the ERP during the day.
Power BI, Looker Studio or Metabase?
Power BI is the natural pick if you already use Microsoft 365, at around 10 to 20 USD per user per month. Hosted Metabase suits tight budgets, with a fixed server cost of 50 to 160 USD a month.
What is the maximum number of indicators?
Stay between 10 and 20 for the executive view. Detailed functional views can hold more, but each indicator needs a named owner.
Can the dashboard be viewed on mobile?
Yes, every major tool offers a mobile app or responsive view. Budget 1 to 2 days of work for a truly readable mobile layout.
How soon can we see a first result?
A first dashboard with 5 ERP indicators can be delivered in 4 to 6 weeks. The full ERP and CRM scope takes 2 to 4 months.
Let's scope your project. Tell us your data sources and the five numbers you want to see every morning, and we will define the indicators, architecture and a 2 to 4 month plan. 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.
