The verdict in three sentences
A construction SME with 90 employees that discovers its project margins at year-end is steering six to twelve months behind reality. Power BI (EUR 10 to 20 per user per month, plus EUR 8,000 to 20,000 of setup) is enough in most cases if your accounting and project data are clean. A custom build (EUR 25,000 to 50,000) is justified when site progress must be captured in the field, several tools without APIs must be combined, or views must be pushed to site managers, with a 6 to 10 week timeline either way.
The indicators that change a construction owner's decisions
A useful executive dashboard fits on one screen and answers three questions: am I making money on live projects, do I have enough work for the next six months, are my clients paying me?
| Indicator | Data source | Frequency | Typical alert threshold |
|---|---|---|---|
| Margin to date by project | Project software (hours, purchases) and valuations | Weekly | More than 3 points below planned margin |
| Order book in months of production | Signed quotes, schedule | Monthly | Under 4 months |
| Receivables and late payments | Accounting | Weekly | Over 60 days, retentions not released |
| Actual vs budgeted hours | Time tracking | Weekly | Overrun above 10% |
| Quote conversion rate | CRM or quote file | Monthly | Under 25% |
| 90-day cash forecast | Accounting, payment schedule | Weekly | Projected balance under one month of costs |
Margin to date is the decisive indicator. Project by project, it compares committed cost (labour, purchases, subcontracting, plant hire) with revenue recognised according to percentage of completion.
Power BI or custom: the 2026 comparison
| Criterion | Power BI with an integrator | Custom dashboard |
|---|---|---|
| Setup | EUR 8,000 - 20,000 | EUR 25,000 - 50,000 |
| Licences | EUR 10 - 20 per user per month (Pro or Premium per user) | No per-user licence, hosting estimated at EUR 50 - 300 per month |
| 3-year cost for 15 users (order of magnitude) | EUR 13,400 - 30,800 | EUR 27,000 - 61,000 |
| Accounting connectors (Sage, Xero and similar) | Native or via export | Built on demand |
| Project software without API | Manual exports, fragile | Connector or built-in entry |
| Progress entry by site managers | Not included | Yes, mobile form |
| Timeline | 6 - 8 weeks | 8 - 10 weeks |
| Autonomy to build new reports | High, if one staff member is trained | Depends on the supplier |
The practical rule: if 80% of your data already sits in exportable accounting and project software, go with Power BI. If progress data exists nowhere but in site managers' heads, you need a tool that collects it, so a custom build or a light application layer in front of Power BI.
Typical 6 to 10 week plan
- Weeks 1 and 2: choose 8 to 12 indicators, inventory sources, clean up the project cost codes.
- Weeks 3 to 5: accounting and project connectors, data model, first screens.
- Weeks 6 to 8: progress entry form (if custom), email alerts, role-based access.
- Weeks 9 and 10: acceptance with management, reconciliation with the last close, training.
The classic trap is inconsistent cost coding: if purchases are not booked to the right project, no tool will produce a reliable margin.
Mini case study
James, owner of a 90-employee structural works contractor in London, turns over EUR 16 million (about GBP 13.7 million). At the last year-end, three projects worth EUR 3.2 million finished at a 2% margin instead of the planned 9%.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
- A drift spotted a third of the way through leaves time to act (variations, crew reallocation, supplier renegotiation). Recovering just 3 points on that EUR 3.2 million is worth EUR 96,000.
- Power BI option: EUR 14,000 setup plus 15 users at EUR 14 a month, EUR 16,520 in year one.
- Custom option with mobile progress entry: EUR 38,000 plus about EUR 2,400 a year of hosting.
- Either way, a single recovered project covers the investment. James goes custom, because his site managers use no software to report progress.
FAQ
How much does a Power BI dashboard cost for a construction SME?
Budget EUR 8,000 to 20,000 for setup, plus EUR 10 to 20 per user per month. For 15 users, year one costs about EUR 10,000 to 23,600.
When is custom the better option?
When site progress must be entered in the field or the project software has no API. The budget sits between EUR 25,000 and 50,000.
Which accounting packages can be connected?
Sage, Xero and most construction project tools on the market, via API or scheduled export. The connector usually accounts for EUR 3,000 to 8,000 of the project.
How quickly is the dashboard live?
6 to 8 weeks for Power BI, 8 to 10 weeks for a custom tool. The quality of cost coding often drives the timeline.
Which indicators should come first?
Margin to date, order book in months, receivables and 90-day cash. Eight to twelve indicators are enough for a weekly management meeting.
Let's scope your project. We audit your data sources, recommend Power BI or custom, price the scope between EUR 8,000 and 50,000 and plan delivery in 6 to 10 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.
