Skip to content
Power BI17 min read3,823 words

Power BI consultancy in Lüneburg: what it costs, what breaks and what to build first

A practical guide to Power BI consultancy in Lüneburg: the definition traps in public sector and higher education and research, honest licensing arithmetic, hire-versus-engage costs, and the compliance position under the EU GDPR and the Bundesdatenschutzgesetz (BDSG).

Local view for Lüneburg, Germany

The call from Lüneburg usually starts the same way: two reports disagree, both have a defender, and the meeting where it matters is on Thursday.

Lüneburg is a market of mostly owner-managed and mid-sized organisations, where analytics is one person's responsibility alongside three others. With around 80,000 people and an economy built on public sector, higher education and research, and logistics and freight, 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 Lüneburg 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 EU GDPR and the Bundesdatenschutzgesetz (BDSG).

Why reporting breaks in Lüneburg specifically

Generic advice about Power BI is not very useful, because the failure modes follow the industry rather than the tool. Lüneburg's economy is weighted towards public sector, higher education and research, and logistics and freight, with regional administration and courts and a university with sustainability and management focus 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.

Public sector

Case and service data locked inside line-of-business systems with restrictive reporting modules, feeding statutory returns with precisely defined rules.

The characteristic failure is this: returns are assembled by hand each cycle by a small number of experienced staff, concentrating risk in individuals. 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 governed model that produces both the statutory return and internal performance reporting, so published and internal figures cannot diverge.

Typical source systems: case management systems, finance and ERP, HR and payroll, GIS and gazetteers and grant management. Freedom of information and transparency duties mean published figures must be reproducible, and disclosure control has to be applied in the pipeline.

Tourism, hospitality and events

Booking, channel and rate data with heavy seasonality, plus on-site spend and occupancy that only reconcile once channel commission is accounted for.

Here the recurring problem is different: gross booking value from online travel agents is compared with direct booking revenue, making the most expensive channel look like the best one. The fix is a stay-grain model joining rooms, ancillary spend and channel cost, which is where true channel profitability becomes visible. Guest data is personal data with cross-border transfer implications when group systems sit outside the region.

Food and drink manufacturing

Short shelf life, high SKU churn, promotional volatility and retailer scorecards that measure you on their definitions rather than yours. Internal service levels read green while the retailer scorecard reads amber, because the two measure different events.

We would usually begin with a production and waste model aligned to retailer scorecard definitions, so commercial conversations use the customer's own numbers. Source systems to expect: ERP, MES, warehouse management, retailer EDI and scorecards and quality systems.

The metrics we check first in a Lüneburg 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 Lüneburg, derived from the industries that dominate here.

MetricWhere it comes fromThe trap that breaks it
demand trendpublic sectorRepeat referrals must not be counted as new demand
statutory timescale compliancepublic sectorClock-stop rules differ per duty and must be modelled individually
continuation and completion rateshigher education and researchCohort definition and the treatment of interruptions determine the figure
research income per academic FTEhigher education and researchFTE basis and the treatment of fractional appointments must be fixed
dwell timelogistics and freightArrival definition at gate, yard or dock changes the figure substantially
pick productivitylogistics and freightIndirect labour and travel time must be in or out consistently across areas
RevPARtourism, hospitality and eventsOut-of-order rooms treatment changes the denominator and is handled differently by each system
booking lead time distributiontourism, hospitality and eventsCancellations must be excluded or the distribution misleads revenue management
yield per raw material tonnefood and drink manufacturingSeasonality in raw material quality has to be a dimension, not noise
waste and shrinkagefood and drink manufacturingProduction waste, distribution waste and retail returns need separate categories
The definition traps we check first in a Lüneburg engagement, drawn from the sectors that dominate the local economy.

None of this is exotic. Where two definitions are both defensible, an organisation ends up carrying both, and the monthly difference between them becomes a recurring agenda item rather than a resolved question. 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 mid-sized business with one overworked analyst: 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 Lüneburg business in public sector, 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. case management systems, finance and ERP and HR and payroll 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 public sector the argument that has to be settled first is normally statutory timescale compliance, where clock-stop rules differ per duty and must be modelled individually. 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. Leuphana University provides management and data graduates, with Hamburg competing for them.

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 Germany, 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 schema€15,000 to €40,0003 to 6 weeks
MediumThree to six sources, two or three business areas, several fact tables, non-trivial DAX, basic governance€40,000 to €120,0006 to 12 weeks
LargeHeterogeneous sources including ERP and CRM, multiple business areas, a dedicated data layer, formal governance€120,000 to €400,000+3 to 6 months
Indicative build cost in euro, 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: €3,000 to €8,000 a month for a small estate, €8,000 to €20,000 for a mid-sized one, €20,000 to €50,000+ for a large multi-domain platform. Microsoft licensing is separate again, and is covered next.

Licensing: what Lüneburg 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 euro 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 most organisations in Lüneburg, per-user licensing is the correct answer and will remain so for years. We have told several clients here that the Fabric capacity they were quoted would be a straightforward waste of money, and we would rather do that than sell the larger number.

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 Lüneburg versus engaging a consultancy

This is a fair question and the honest answer is sometimes "hire". Leuphana University provides management and data graduates, with Hamburg competing for them. Locally, a mid-level analytics engineer costs roughly €60,000 to €95,000, higher in Munich, Frankfurt and Stuttgart. An experienced external consultant runs at roughly €900 to €1,500 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 €60,000 to €95,000, higher in Munich, Frankfurt and Stuttgart 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 €900 to €1,500 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 Lüneburg client has told us they intend to build an internal team, we design for it from the start. Teams here expect to own what we build, and we design for that explicitly: scriptable models, conventional naming, documentation in their wiki, and a measure dictionary that survives our departure. Several clients have gone on to need us only for quarterly review, which is a perfectly good outcome.

Data residency and compliance for Lüneburg organisations

Germany West Central in Frankfurt is the usual choice and gives in-country residency with very low latency to the financial sector. Germany North provides a paired region. Residency alone does not satisfy a German works council or data protection officer. They will also ask about processor chains and access by support personnel, so those answers need preparing. In practice, Lüneburg deployments normally use Germany West Central (Frankfurt), with Germany North (Berlin) as the paired region.

Regulatory oversight relevant to analytics comes from the federal commissioner (BfDI) and the Land data protection authorities under the EU GDPR and the Bundesdatenschutzgesetz (BDSG), plus the sector bodies that matter here: BaFin for financial services supervision, including MaRisk data-quality expectations, Land data protection authorities for data protection enforcement, which varies in emphasis by Land and BNetzA for energy, telecoms and rail network reporting.

  • Betriebsrat co-determination is the single most underestimated factor in German analytics projects: any reporting that could be used to assess individual employee performance generally needs a works agreement before launch.
  • MaRisk and BAIT expectations mean financial-sector data lineage and documentation standards are explicit, not inferred.
  • The Lieferkettensorgfaltspflichtengesetz requires supply-chain due-diligence data that most ERP estates do not hold in reportable form.

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

How we deliver into Lüneburg

  • Specification discipline is higher than in the UK: expect a written Fachkonzept and a documented acceptance process, and plan for it rather than resisting it.
  • Works council consultation should be scheduled at the start of a project, not discovered during user acceptance testing.
  • Many Mittelstand clients prefer German-language documentation and stakeholder sessions even where the project team works in English.

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 and English, and stakeholder sessions run in whichever of those the room prefers.

How a Lüneburg organisation actually buys this

Most consultancy pages stop at what the work is and leave the buying process to email. Specification-driven and documented. The technical team and the Einkauf negotiate separately, references carry real weight, and a written proposal with itemised positions is expected rather than a slide deck.

In the private sector: The business area issues a Lastenheft describing what it needs, or asks the supplier to produce a Pflichtenheft specifying how it will be delivered. The supplier responds with a formal Angebot: itemised positions, a stated Tagessatz or fixed price, delivery dates and acceptance criteria. The Einkauf then negotiates commercial terms separately from the technical discussion, and a Betriebsrat consultation runs in parallel wherever the system could be used to assess individual employee performance.

In the public sector: Public bodies procure through e-Vergabe and the Land Vergabeportale under VgV above EU thresholds and UVgO below them, with above-threshold notices also published on TED. The process is formal, the award criteria are published in advance, and a submission that misses a formal requirement is excluded regardless of quality.

StageWho is involvedWhat they need from a supplier
QualificationFachbereich, the business area that owns the requirementA clear statement of what would be built, in what order, with an indicative price range
Technical reviewIT, for architecture and operabilityAn architecture position that survives questioning, and references in a comparable sector
Risk and complianceDatenschutzbeauftragter, for the AVV and the processing position and Betriebsrat, wherever employee performance could be derived from the reportingHandelsregisterauszug, a current commercial register extract, Unbedenklichkeitsbescheinigung for tax and social security contributions and Betriebshaftpflicht and professional indemnity insurance certificates
CommercialGeschäftsführung, above the delegated authority thresholdContract shape, payment terms and liability. German for the contract, the AVV and the acceptance documentation, even where the delivery team works in English.
The approval path a Lüneburg purchase of this kind normally follows. Expect six to sixteen weeks in the private sector, with the Betriebsrat consultation often the critical path. Public procedures run four to eight months.

Documents you should expect to request, and that any supplier worth shortlisting will have ready, are handelsregisterauszug, a current commercial register extract, unbedenklichkeitsbescheinigung for tax and social security contributions, betriebshaftpflicht and professional indemnity insurance certificates and auftragsverarbeitungsvertrag (avv), the article 28 processing agreement, in german.

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 who also looks after three other systems, 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 Germany and deliver into neighbouring markets regularly. Nearby pages worth reading if your group has sites elsewhere: Halle (Saale), Trier, Bonn, Magdeburg, Lübeck and Potsdam.

Frequently asked questions

Do you have an office in Lüneburg?

We are deliberately a distributed consultancy rather than a network of nameplate offices, so we will not claim a Lüneburg address we do not occupy. We deliver into Lüneburg 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 Lüneburg business?

Discovery is a fixed fee in the low five figures. Build cost follows project size: €15,000 to €40,000 for a small project of three to six weeks, €40,000 to €120,000 for a medium one of six to twelve weeks, and €120,000 to €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 €3,000 to €8,000 a month for a small estate, €8,000 to €20,000 for a mid-sized one, €20,000 to €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 Lüneburg do you work with?

The local mix means most of our Lüneburg work sits in public bodies and agencies, universities and research institutes, and logistics operators and freight forwarders. 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 Lüneburg, 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 Germany?

Six to sixteen weeks in the private sector, with the Betriebsrat consultation often the critical path. Public procedures run four to eight months. 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. The model lives in source control and can be rebuilt from a script, the naming convention is written down rather than inferred, the dictionary records why a measure exists and not just how it calculates, and your team is trained while the work happens rather than afterwards. 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
Ein Fachgespräch, then an itemised Angebot in German with an AVV attached. Expect the technical review to be detailed.

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