The verdict in three sentences
For an SME with EUR 20 to 50 million in revenue whose data is scattered across several tools, Power BI is the best choice when users are analysts comfortable exploring data. Custom development wins when the dashboard must be simple, mobile, built into frontline managers' daily routine and enriched with alerts or actions. Either way, 60% of the budget goes into the same thing: a clean data warehouse that reconciles ERP, CRM, e-commerce and payroll.
What each option costs in 2026
The prices below are 2026 orders of magnitude for a distribution SME with 15 dashboard users and 4 data sources.
| Item | Power BI + integrator | Custom |
|---|---|---|
| Licences | USD 14 per user per month (Pro), about EUR 2,300 a year for 15 users | EUR 0 |
| Connectors and data model | EUR 8,000 to 20,000 excl. VAT (integrator) | Included in development |
| Screen development | Included in integration | EUR 15,000 to 35,000 excl. VAT in total |
| Data warehouse (cloud) | EUR 50 to 300 a month | EUR 50 to 300 a month |
| Maintenance and changes | EUR 200 to 400 a month | EUR 300 to 600 a month |
| Time to go live | 6 to 10 weeks | 8 to 14 weeks |
| 3-year cost (mid-range) | about EUR 36,000 | about EUR 45,000 |
Power BI is therefore slightly cheaper upfront. The gap narrows or reverses when users exceed 40, when Premium Per User licences (USD 24 a month) are needed for external sharing, or when managers do not adopt the tool and finance keeps emailing Excel files.
The 12 KPIs of a useful executive dashboard
An effective executive dashboard fits on one screen. Beyond 12 KPIs, nobody reads it. Here is a typical selection for a distribution SME, with source and refresh frequency.
| KPI | Source | Refresh |
|---|---|---|
| Revenue day, month, year to date vs budget | ERP | Hourly |
| Gross margin by product family | ERP | Hourly |
| Order book and service level | ERP | Hourly |
| Stock turnover and value, stockouts | ERP / WMS | Hourly |
| DSO and overdue receivables | Accounting | Daily |
| Available cash and 13-week forecast | Banks + accounting | Daily |
| Weighted sales pipeline | CRM | Hourly |
| Quote conversion rate | CRM | Daily |
| Online sales and average basket | E-commerce | Hourly |
| Payroll vs budget | Payroll | Monthly |
| Warehouse productivity (lines per hour) | WMS | Daily |
| Customer complaints and returns | CRM / after-sales | Daily |
Hourly refresh requires reliable connectors. That is often where the real cost hides, especially with a legacy ERP without an API.
How to choose: the decision grid
| Situation | Recommended choice | Reason |
|---|---|---|
| Finance team with an analyst controller | Power BI | Autonomy to build new reports |
| Frontline managers on mobile, short on time | Custom | Simple interface, push alerts |
| Need to act from the dashboard (chase, approve) | Custom | Power BI remains a reading tool |
| Microsoft 365 ecosystem already in place | Power BI | Native authentication and sharing |
| Dashboard shared with clients or franchisees | Custom | No per-user external licence |
| Initial budget under EUR 15,000 | Power BI | Faster start |
Mini case study
Marc, CEO of an electrical equipment distributor in Nantes (EUR 25 million revenue, 110 staff), consolidates figures from the ERP, CRM, e-commerce site and payroll every Monday. His financial controller spends 10 hours a week on it, 480 hours a year valued at EUR 50: EUR 24,000 a year.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
- Chosen option: Power BI for 15 users, integrator at EUR 14,000 excl. VAT, data warehouse at EUR 150 a month, maintenance at EUR 300 a month.
- Annual recurring cost: 2,300 + 1,800 + 3,600 = EUR 7,700.
- Remaining consolidation time: 2 hours a week, i.e. EUR 19,200 saved a year.
- Net annual gain: 19,200 - 7,700 = EUR 11,500.
Payback: 14,000 / 11,500 = about 15 months, excluding the main benefit: decisions made on today's figures rather than last week's.
FAQ
How much does Power BI cost for an SME in 2026?
A Power BI Pro licence costs USD 14 per user per month, about EUR 2,300 a year for 15 users. Add EUR 8,000 to 20,000 excl. VAT for integration and EUR 50 to 300 a month for the data warehouse.
Is a custom dashboard more expensive?
Upfront yes, at EUR 15,000 to 35,000 excl. VAT, but with no per-user licence. Beyond 40 users or with external sharing, it often becomes cheaper over 3 years.
Is a data warehouse mandatory?
As soon as figures come from 3 or more sources, yes. It costs EUR 50 to 300 a month and ensures everyone reads the same revenue figure, which ends debates in management meetings.
How soon is the dashboard available?
Budget 6 to 10 weeks with Power BI and 8 to 14 weeks for custom. A first version with 5 KPIs can be delivered in 4 weeks to validate usage.
Can we start with Power BI and move to custom later?
Yes, because the data warehouse is 100% reusable. Only the display layer changes, about 40% of the initial investment.
Let's scope your project. List your data sources, your 12 priority KPIs and the number of users: we will compare Power BI and custom on your case, with a budget between EUR 15,000 and 35,000 excl. VAT. 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.
