Skip to content
Power BI17 min read3,843 words

Power BI consultancy in Geneva: what it costs, what breaks and what to build first

A practical guide to Power BI consultancy in Geneva: the definition traps in asset and wealth management and commodity trading, honest licensing arithmetic, hire-versus-engage costs, and the compliance position under the revised Federal Act on Data Protection (revFADP / revDSG), in force since September 2023.

Local view for Geneva, Switzerland

If you are looking for Power BI help in Geneva, the useful question is not who can build a dashboard. It is who will tell you which of your existing numbers is wrong.

Geneva is large enough that most organisations here already have several analytics teams and the problem is reconciling them. With around 205,000 people in the city itself and roughly 1,030,000 across the wider urban area and an economy built on asset and wealth management, commodity trading, and public sector, the reporting questions here are specific rather than generic, and so are the ways they go wrong. This page sets out what a Power BI engagement in Geneva actually involves: the metrics we check first, what it costs, how licensing should be chosen, whether you would be better off hiring, and what the compliance position looks like under the revised Federal Act on Data Protection (revFADP / revDSG), in force since September 2023.

Why reporting breaks in Geneva specifically

Generic advice about Power BI is not very useful, because the failure modes follow the industry rather than the tool. Geneva's economy is weighted towards asset and wealth management, commodity trading, and public sector, with a major private banking and wealth management centre and one of the world's largest commodity trading hubs shaping much of the local employment base. That mix produces a predictable set of reporting problems, and we have seen each of them here more than once.

Commodity trading

Position, trade and logistics data with mark-to-market valuation, counterparty exposure and physical movements that must reconcile against paper positions.

The characteristic failure is this: risk and finance value the same position at different snapshot times, so the explained difference is recalculated manually every day. Where that has already happened, the first deliverable is not a dashboard. It is a written reconciliation that establishes which number is correct and why. In practice we start by building a position and valuation model with a single curve snapshot policy, which ends the daily disagreement between risk and finance.

Typical source systems: CTRM platform, market data feeds, logistics and vessel tracking, finance and treasury systems and credit systems. Market abuse and transaction reporting obligations apply, and market data licences typically restrict redistribution.

Precision engineering and instruments

Low-volume, high-value production with extensive measurement data per part, long order books and a service business attached to the installed base.

Here the recurring problem is different: metrology data stays in the quality system, so the cost of variation never reaches the people deciding where to invest. The fix is a measurement and scrap-cost model at part grain, which makes quality performance a financial conversation rather than an engineering one. Calibration and measurement traceability records are audited under quality standards, and retention periods are long.

Public sector

Case and service data locked inside line-of-business systems with restrictive reporting modules, feeding statutory returns with precisely defined rules. Returns are assembled by hand each cycle by a small number of experienced staff, concentrating risk in individuals.

We would usually begin with a governed model that produces both the statutory return and internal performance reporting, so published and internal figures cannot diverge. Source systems to expect: case management systems, finance and ERP, HR and payroll, GIS and gazetteers and grant management.

The metrics we check first in a Geneva engagement

Sector knowledge in analytics is mostly knowing which definitions destroy a number when they drift. Before we design anything we go through the measures that matter to you and establish, in writing, exactly how each one is calculated and who owns that definition. The table below is the starting list for Geneva, derived from the industries that dominate here.

MetricWhere it comes fromThe trap that breaks it
benchmark-relative performanceasset and wealth managementBenchmark rebalancing dates have to align with the portfolio calculation basis
client profitabilityasset and wealth managementFee rebates and introducer commissions are usually held outside the portfolio system entirely
counterparty credit exposurecommodity tradingNetting agreements have to be applied correctly or exposure is materially misstated
demurrage and logistics cost per cargocommodity tradingThese costs are usually captured late and attributed to the wrong period
outcome achievement ratepublic sectorCohort follow-up windows have to be consistent across services
demand trendpublic sectorRepeat referrals must not be counted as new demand
scrap cost per orderprecision engineering and instrumentsHigh unit values mean a count-based scrap rate hides the financial exposure entirely
process capability indicesprecision engineering and instrumentsSubgroup selection and measurement system error must be handled or capability is overstated
pipeline weighted valueprofessional and legal servicesStage probabilities decay and need periodic recalibration against actual conversion
utilisationprofessional and legal servicesThe availability basis has to be fixed once and published beside the figure
The definition traps we check first in a Geneva engagement, drawn from the sectors that dominate the local economy.

None of this is exotic. A measure with two plausible definitions will acquire both, and the resulting variance is then explained away every month instead of being fixed once. The output of this stage is a measure dictionary: every KPI, its business definition, its owner, and the DAX that implements it.

What a first Power BI engagement looks like

We work the same way whether the client is a large group with nine existing workspaces: decisions first, sources second, model third, reports last. Reports built before the model are the single most common cause of rework.

  1. Decision inventory, week 1We start from the recurring decisions that need numbers, not from the data that happens to be available. Who decides, on what cadence, and what currently blocks them. For a Geneva business in commodity trading, that usually surfaces three or four decisions worth building for and a dozen reports nobody needs.
  2. Source profiling, weeks 1 to 2Each source system profiled for grain, volume, change tracking, quality and refresh window. CTRM platform, market data feeds and logistics and vessel tracking are the usual candidates here. This is where unpleasant surprises belong, not in week ten.
  3. Model build, weeks 3 to 7A star schema with conformed dimensions, measures written against the agreed definitions, and row-level security applied from the start. For commodity trading the argument that has to be settled first is normally mark-to-market position, where valuation curve and snapshot time must be identical across risk and finance reporting. Settle it before any report exists, not after two of them disagree.
  4. Report build and validation, weeks 6 to 10Reports built with the people who will use them and validated line by line against the source of record until the numbers tie out. Disagreements get resolved and written down, never averaged.
  5. Handover, weeks 10 to 14Workshops with your team, documentation in your own systems, and a thirty-day period where we fix what breaks while your people drive. The University of Geneva and nearby EPFL supply quantitative talent, with international organisations and banks competing for it.

What that costs

Build cost follows project size rather than report count, the number of source systems and their state drive almost all of it. These are the bands we quote in Switzerland, and we publish them because a buyer cannot start an approval chain without a budget figure.

Project sizeWhat that coversIndicative costElapsed time
SmallOne or two source systems, one business area, three to five reports, a straightforward star schemaCHF 15,000 to CHF 40,0003 to 6 weeks
MediumThree to six sources, two or three business areas, several fact tables, non-trivial DAX, basic governanceCHF 40,000 to CHF 120,0006 to 12 weeks
LargeHeterogeneous sources including ERP and CRM, multiple business areas, a dedicated data layer, formal governanceCHF 120,000 to CHF 400,000+3 to 6 months
Indicative build cost in Swiss franc, excluding Microsoft licensing. Discovery is quoted separately as a fixed fee in the low five figures, and the fixed price for the build is set after it rather than before.

Running it afterwards is a separate line: CHF 3,000 to CHF 8,000 a month for a small estate, CHF 8,000 to CHF 20,000 for a mid-sized one, CHF 20,000 to CHF 50,000+ for a large multi-domain platform. Microsoft licensing is separate again, and is covered next.

Licensing: what Geneva organisations should actually pay

This is where money is most often wasted, in both directions. Power BI Pro is listed at around US$14 per user per month and Power BI Premium Per User at around US$24 following the 2025 price revision. Local list prices in sterling, euro and Swiss francs track those figures with regional adjustment, and enterprise agreements usually land below list.

OptionWho it suitsApproximate list priceThe catch
Power BI FreeOne person exploring data with no sharingNo chargeCannot share into a workspace, so it is not a business option
Power BI ProSmall reader populations, typically under about 200 peopleAround US$14 per user per month at listEvery reader needs a licence, so cost scales linearly with the audience
Premium Per UserTeams needing larger models, higher refresh rates or paginated reportsAround US$24 per user per month at listStill per-user, so a large reader base gets expensive quickly
Fabric F2, F32 capacityData engineering workloads with a modest reader populationFrom roughly US$260 a month for an F2, pay-as-you-goReaders still need Pro licences below F64, and small SKUs throttle under load
Fabric F64 capacityLarge reader populations and in-platform data engineeringRoughly US$8,400 a month pay-as-you-go, around US$5,000 reservedOnly pays for itself above roughly 350 to 600 readers, depending on your discount
Approximate list prices. Local prices in Swiss franc track these with regional adjustment, and enterprise agreements normally land below list, price from the current Microsoft rate card before committing.

The arithmetic that matters: F64 only becomes cheaper than per-user licensing somewhere in the region of 350 to 600 readers, depending on the discount you actually pay and whether you reserve capacity. Below that, Pro or PPU per user is normally the right answer, and buying capacity for prestige is a straightforward waste of money.

For larger Geneva organisations with hundreds of report consumers, a capacity SKU is usually the right answer, and which one depends on measured consumption rather than headcount. We profile workloads on a short-lived trial capacity before anyone signs.

Always price from the current Microsoft rate card for your region and agreement. Any figure in an article older than a quarter should be treated as an order of magnitude, not a quote.

Hiring in Geneva versus engaging a consultancy

This is a fair question and the honest answer is sometimes "hire". The University of Geneva and nearby EPFL supply quantitative talent, with international organisations and banks competing for it. Locally, a mid-level analytics engineer costs roughly CHF 110,000 to CHF 160,000, with Zurich and Zug at the top. An experienced external consultant runs at roughly CHF 1,300 to CHF 2,200 per day.

ApproachWhen it is the right callWhat it costs you
Hire internallySteady ongoing demand, an existing platform to maintain, and a manager who can judge the workRoughly CHF 110,000 to CHF 160,000, with Zurich and Zug at the top a year, plus recruitment time and the risk that one person holds all the knowledge
Engage a consultancyA first platform, a migration, a specialist problem, or a deadline that cannot absorb a hiring cycleRoughly CHF 1,300 to CHF 2,200 per day, for a defined scope with documentation and handover included
BothThe most common answer: internal ownership of business engagement, external depth for architecture and peak deliveryA smaller internal salary plus a modest retainer, which is usually cheaper than either extreme

Where a Geneva client has told us they intend to build an internal team, we design for it from the start. Everything is built to be handed over: scriptable models rather than click-built ones, a naming convention written down, documentation in the tools your team already uses, and a dictionary of measures that outlasts the engagement. Several clients have gone on to need us only for quarterly review, which is a perfectly good outcome.

Data residency and compliance for Geneva organisations

Switzerland North and Switzerland West give in-country residency, which matters more here than almost anywhere else in Europe: banking secrecy, professional secrecy obligations and client expectation all push Swiss data to stay Swiss. Verify per service, because not every Azure or Fabric feature is available in both Swiss regions. In practice, Geneva deployments normally use Switzerland North (Zurich), with Switzerland West (Geneva) as the paired region.

Regulatory oversight relevant to analytics comes from the Federal Data Protection and Information Commissioner (FDPIC / EDÖB) under the revised Federal Act on Data Protection (revFADP / revDSG), in force since September 2023, plus the sector bodies that matter here: FINMA for banking, insurance and asset management supervision, including outsourcing circulars, FDPIC for federal data protection oversight and ElCom for electricity market and grid reporting.

  • The revFADP brought Swiss law closer to the GDPR but not identical to it: records of processing, impact assessments and breach notification follow Swiss rules, and an EU-shaped compliance pack needs adapting rather than copying.
  • FINMA outsourcing expectations require documented control over cloud providers, including the right to audit and a tested exit plan.
  • Article 321 of the Criminal Code and sectoral secrecy duties restrict who may see client-identifying data, which has direct consequences for row-level security design.

We cover this properly on the data governance and compliance page, and in more depth in our article on data governance for Geneva organisations.

How we deliver into Geneva

  • Swiss engagements are precise about scope and documentation, and tolerate fewer surprises than UK projects.
  • Multilingual stakeholder groups are normal: German-speaking head office, French-speaking region, English-language group reporting.
  • Expect strict supplier onboarding, including security questionnaires and in some cases background checks before any data access.

Delivery is remote-first with on-site workshops at the points where being in the room genuinely helps: definition sessions, validation and go-live. We work in German, French, Italian and English, and stakeholder sessions run in whichever of those the room prefers.

How a Geneva organisation actually buys this

Most consultancy pages stop at what the work is and leave the buying process to email. Relationship-led but heavily documented, with supplier due diligence that goes further than anywhere else in our markets, particularly in banking and pharmaceuticals.

In the private sector: A relationship and a reference open the door; a formal supplier onboarding then decides whether the work can proceed. Expect a security questionnaire, financial checks and, in financial services, an outsourcing assessment against the FINMA circular with documented audit rights and a tested exit plan. Background checks on individual engineers are routine in banking, and some clients require that named staff never move data outside Switzerland.

In the public sector: Federal and cantonal bodies publish on SIMAP under BöB at federal level and IVöB at cantonal level, with WTO/GPA thresholds determining the procedure. Cantonal rules differ, and language requirements follow the canton.

StageWho is involvedWhat they need from a supplier
QualificationFachstelle, the business ownerA clear statement of what would be built, in what order, with an indicative price range
Technical reviewIT security, with a questionnaire and frequently an architecture reviewAn architecture position that survives questioning, and references in a comparable sector
Risk and complianceDatenschutz, against the revFADP rather than an EU-shaped pack and Einkauf for commercial termsHandelsregisterauszug, current commercial register extract, Betreibungsregisterauszug, a debt enforcement register extract, requested more often than people expect and Insurance certificates including professional indemnity, in CHF cover levels
CommercialGeschäftsleitung, for anything touching client-identifying dataContract shape, payment terms and liability. German, French or Italian depending on the canton; English is common in banking, pharmaceuticals and international groups.
The approval path a Geneva purchase of this kind normally follows. Expect eight to twenty weeks. Financial services onboarding alone can take two to three months before any work starts.

Documents you should expect to request, and that any supplier worth shortlisting will have ready, are handelsregisterauszug, current commercial register extract, betreibungsregisterauszug, a debt enforcement register extract, requested more often than people expect, insurance certificates including professional indemnity, in chf cover levels and data processing agreement drafted against the revfadp, not a translated eu template.

Our own entity details, insurance, processing agreements and contracting shapes are published on the procurement page, so your buying team can start without waiting for a reply.

Signals it is time to call someone

The usual triggers are two reports disagreeing on a headline number, an overnight refresh someone re-runs by hand each morning, a largest model that is one file owned by one person, finance still rebuilding the board pack in a spreadsheet, a legacy BI renewal whose price no longer makes sense, or a question about who can see a sensitive dataset that took a week to answer honestly. If two or more are true, a two to three week paid discovery will tell you what to do about it, and you keep the output whether or not you engage us further. Book a technical review, or read what we actually build:

We work across Switzerland and deliver into neighbouring markets regularly. Nearby pages worth reading if your group has sites elsewhere: Zug, Zurich, Bern, Lugano, Thun and Fribourg.

Frequently asked questions

Do you have an office in Geneva?

We are deliberately a distributed consultancy rather than a network of nameplate offices, so we will not claim a Geneva address we do not occupy. We deliver into Geneva remotely with on-site workshops at the stages where presence matters, definition sessions, validation and go-live, and we are explicit about travel in the statement of work rather than burying it.

How much does a Power BI project cost for a Geneva business?

Discovery is a fixed fee in the low five figures. Build cost follows project size: CHF 15,000 to CHF 40,000 for a small project of three to six weeks, CHF 40,000 to CHF 120,000 for a medium one of six to twelve weeks, and CHF 120,000 to CHF 400,000+ for a large platform running three to six months. What moves a project between bands is the number of source systems and their state, not the number of reports. Running it afterwards costs CHF 3,000 to CHF 8,000 a month for a small estate, CHF 8,000 to CHF 20,000 for a mid-sized one, CHF 20,000 to CHF 50,000+ for a large multi-domain platform. We give a written estimate range before discovery and a fixed price after it, because an estimate based on an average rather than on your data is worth very little.

Which industries in Geneva do you work with?

The local mix means most of our Geneva work sits in asset managers and private banks, commodity trading houses, and public bodies and agencies. We publish what we expect to find in each sector, the metrics, the source systems and the specific traps, so you can judge whether we understand your business before the first call.

Can you work with the Power BI estate we already have?

Yes, and it is usually the cheaper route. We begin with an estate review: which models are worth keeping, which should be consolidated into a shared semantic model, and which can be retired because nobody has opened them in six months. A full rebuild is occasionally correct, but it should be a conclusion rather than a starting assumption.

Do we need Fabric capacity, or will Power BI Pro do?

The arithmetic that matters: F64 only becomes cheaper than per-user licensing somewhere in the region of 350 to 600 readers, depending on the discount you actually pay and whether you reserve capacity. Below that, Pro or PPU per user is normally the right answer, and buying capacity for prestige is a straightforward waste of money. For most organisations of the size typically found in Geneva, per-user licensing is cheaper and will stay cheaper. We model your actual reader mix and give you the break-even point in writing.

How long does it take to get a project started in Switzerland?

Eight to twenty weeks. Financial services onboarding alone can take two to three months before any work starts. The variable is rarely the commercial negotiation. It is supplier onboarding, security review and, where it applies, works council or outsourcing committee consultation. We publish our entity details, insurance, processing agreements and contracting shapes on the procurement page so your buying team can begin that in parallel rather than afterwards.

Who owns the work when the project ends?

You do, in a form you can change without us. You get a model under version control that a script can rebuild, a documented naming convention, a dictionary that says what each measure is for, and training that runs alongside the build instead of after it. Exit assistance is written into every agreement rather than negotiated at an awkward moment.

Read next

Next step

Arrange a technical review

A 45-minute working session with an engineer rather than a sales call. You describe the problem; we set out what we would build, in what order, and what it is likely to cost.

How this usually runs here
A technical call, then a written Offerte. Regulated buyers will ask for an outsourcing assessment and a tested exit plan early.

Answered within one working day, by the engineer who would do the work