The verdict in three sentences
For a distribution group in Zurich, an executive dashboard costs CHF 30,000 to 55,000 to set up on Power BI, plus USD 14 per user per month, versus CHF 50,000 to 90,000 for a custom build. Either way, the real work is the data warehouse that consolidates sales, inventory and accounting: that is what moves figures from day 15 to day 1. Power BI fits when sources are clean and users live in Microsoft tools; custom wins when business rules are specific, users are mobile or you want no per-user licensing.
Where the 15-day delay comes from
In many Swiss mid-sized distribution groups, monthly figures still come out of an Excel consolidation. Each store or subsidiary exports its sales, controlling fixes item codes, reconciles with the ledger under Swiss GAAP FER, then sends a file to the CEO around the 15th. For two weeks, stock-outs, slipping margins and ageing receivables stay invisible.
A dashboard solves nothing if it merely displays the same Excel file. Three steps must be automated: daily extraction from the ERP, point of sale and accounting; cleaning of master data (items, customers, sites); and KPI calculation in a data warehouse.
Power BI or custom: the figures
| Criterion | Power BI with data warehouse | Custom build |
|---|---|---|
| Setup | CHF 30,000 to 55,000 | CHF 50,000 to 90,000 |
| Licences | USD 14 per user per month (about CHF 12.50) | no per-user licence |
| Hosting | Microsoft side included, warehouse to host | CHF 150 to 400 per month |
| Time to go live | 6 to 10 weeks | 10 to 16 weeks |
| Offline and mobile use | limited | possible, lightweight app with caching |
| Specific business rules | DAX formulas, quickly complex | coded in the application |
| Billing | USD or CHF via Microsoft partner | CHF, fixed project price |
The overall market range for this kind of project in Zurich sits between CHF 30,000 and 90,000 in 2026, depending on the number of sources and subsidiaries. A multi-entity dashboard with a proper data warehouse usually lands in the upper half.
Total cost over three years
The entry price is often misleading. Compare the three-year total cost of ownership with 25 users.
| Item over 3 years | Power BI | Custom build |
|---|---|---|
| Setup | CHF 40,000 | CHF 70,000 |
| Licences (25 users) | CHF 11,250 | CHF 0 |
| Warehouse and app hosting | CHF 7,200 | CHF 10,800 |
| Maintenance and enhancements | CHF 18,000 | CHF 25,200 |
| User training | CHF 4,000 | CHF 2,000 |
| Total over 3 years | CHF 80,450 | CHF 108,000 |
| Cost per user per month | about CHF 89 | about CHF 120 |
In Zurich, with stable connectivity and a Microsoft 365 environment, Power BI is often cheaper over three years. A custom build earns its premium when store or regional managers check figures on their phones, when pricing and rebate rules are too specific for DAX, or when the group wants to avoid licence costs as user numbers grow beyond 60 to 80.
On compliance, customer data falls under the revised Swiss Federal Act on Data Protection (nFADP) in force since September 2023. An executive dashboard does not need individual customer names: aggregate by segment and restrict access to detailed records.
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.
Lukas, CFO of a food distribution group in Zurich (6 sites, 25 managers using the dashboard), receives figures on the 15th of the following month. Two controllers each spend 6 days a month consolidating Excel files: 12 days at a loaded cost of CHF 700 a day, about CHF 8,400 a month or CHF 100,800 a year.
With a data warehouse and next-day figures, consolidation falls to 2 days a month. The gain is 10 days, or CHF 84,000 a year. Add faster stock-out detection: cutting shrinkage and losses by 0.2% on average inventory of CHF 12 million saves CHF 24,000. The annual gain of about CHF 108,000 covers the three-year cost of the Power BI option within the first year, before counting better purchasing decisions.
FAQ
Can we start with Power BI and migrate later?
Yes, if the data warehouse is built independently of Power BI. It often represents 50 to 60% of the budget and can be reused by a custom application.
Do we need Power BI Premium?
Not below roughly 300 to 500 users in most cases. Pro licences at USD 14 per user cover a 25-person executive team.
How many KPIs should we start with?
Start with 10 to 15: revenue, margin, inventory, receivables, cash. With more than 30 KPIs at launch, adoption drops.
Where is the data hosted?
Power BI can run in Microsoft's Swiss data centres. A custom build can be hosted with a Swiss provider, which simplifies nFADP compliance for sensitive data.
Who maintains the tool after delivery?
Budget 10 to 15% of the initial cost per year for enhancements. A monthly maintenance plan covers updates, backups and new indicators.
Let's scope your project. List your data sources, priority KPIs and number of users, and we will price the scope, the indicative budget and the timeline to get next-day figures. 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.
