The verdict in three sentences
If your 6 to 15 branches each send their own Excel workbook, your leadership steers 3 to 10 days late and discovers stockouts once it is already too late. In 2026 there are two paths: a managed ETL (Airbyte, Fivetran) wired to a dashboard, or a custom pipeline consolidating sales and inventory per point of sale. The custom route costs USD 13,000 to 26,000 (≈ EUR 12,000-24,000) but permanently kills the 26-40 hours of monthly compilation and shifts stockout detection from D+10 to D+1.
Consolidating 15 files into one cockpit — the 2026 options
The hard part is not the dashboard, it is moving and normalizing the data coming from each branch. Three architectures compete, with very different costs once maintenance is included.
| Option | 2026 build cost (USD) | Monthly recurring | Timeline |
|---|---|---|---|
| Airbyte Cloud + Metabase | 5,000 – 9,000 | USD 220 – 490 | 4 – 6 wks |
| Fivetran + Power BI | 7,500 – 13,000 | USD 420 – 1,000 | 4 – 7 wks |
| Custom pipeline + dashboard | 13,000 – 26,000 | USD 330 – 830 (maintenance) | 5 – 8 wks |
| Manual Excel consolidation (status quo) | 0 | 26 – 40 hrs/mo of labor | permanent |
Managed ETL starts fast but bills by synced rows: past 8-10 very active branches, the Fivetran bill climbs. Custom pays off once the network exceeds 10 stores or sources are heterogeneous (different POS systems, partial ERP, manual files).
What you actually gain
The real gain is not cosmetic: it is executive time and margin protected by better product availability.
| Metric | Before (Excel) | After (consolidated) |
|---|---|---|
| Monthly consolidation time | 26 – 40 hrs | < 1 hr (review) |
| Data freshness | 3 – 10 days | daily / D+1 |
| Stockout detection | D+10 | D+1 |
| Figure reliability | ± 5% (copy errors) | > 99% |
| Monthly reporting cost | USD 900 – 1,500 | USD 330 – 830 |
At 26-40 hours freed per month for a controller costing roughly USD 25-35/loaded hour, labor savings alone are USD 650 to 1,400/month. On top sits the margin saved by avoiding stockouts on fast-moving SKUs.
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
Aisha, who runs an 11-store cosmetics network in Dubai, spent 3 full days at every month start merging POS exports. Chosen build: USD 18,500 for a custom pipeline + dashboard, plus USD 520/month maintenance. Measured gain: 34 hours/month recovered (≈ USD 1,000) and, above all, fewer stockouts on the top 40 SKUs, recovering USD 1,800/month in previously lost sales. Payback reached in ≈ 7 months, maintenance included.
FAQ
Do we need an ERP before consolidating? No. A pipeline can ingest POS exports, Google Sheets and a partial ERP at once. The absence of a unified ERP is precisely the most common reason to build a consolidated dashboard.
Managed Airbyte or custom? Below 8 homogeneous branches, managed ETL (USD 220-490/month) is enough. Beyond that, or with heterogeneous sources, custom is cheaper over 24 months.
How long to go live? Budget 5 to 8 weeks for a custom pipeline: 1-2 weeks scoping sources, 2-4 building, 1-2 for acceptance testing on your real data.
Does the dashboard work on a weak mobile connection? Yes. A well-optimized dashboard (pre-computed aggregates, lazy loading) stays smooth on 3G, which matters for branch managers on the move.
Who maintains the pipeline if a POS changes format? That is the maintenance contract's job (USD 330-830/month): it absorbs source-format changes, adds branches and fixes anomalies without re-quoting a project.
Let's scope your project. Tell us about your network (number of branches, data sources, any ERP) and an indicative budget, and we will scope the ETL-or-custom architecture with the best 24-month economics. 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.
