Service: BI & Data Analytics

BI & Data Analytics Consulting: numbers your team steers by

Our business intelligence consulting is for companies whose teams have more questions for the data than capacity to answer them. In our BI consulting we design and implement the KPIs, definitions and analysis structure on one unified foundation, so everyone steers by the same numbers.

KPI & metric designSelf-service BIAnalytics engineeringData analysis & deep dives
“Most teams don't have a dashboard problem, they have a definition problem. Only once marketing, finance and sales calculate the same metric the same way is the first dashboard worth building.”
Bianca, Managing Principal at Gemma Analytics
KPI systems expert
Your expert

Bianca

Managing Principal
What we do

What our business intelligence consulting delivers

For us, business intelligence starts with getting the KPIs, definitions and analysis structure right. Dashboards, reporting and deep-dive analysis then rest on one unified data foundation. Four building blocks work together.

01

KPI & metric design

We design your KPI system, the metric definitions everyone agrees on and the analysis frameworks that connect numbers to decisions. Where marketing, finance and sales calculate differently today, we settle on one definition per KPI before any tool is touched. You end up with a documented KPI system, written-down metric definitions and the analysis frameworks your teams steer by.

In one project the steering document listed around 25 KPIs. We started with four, led by a utilisation figure that looks ahead.

02

Self-service BI

Dashboards that let your business teams answer their own questions. We build fast, maintainable dashboards in tools like Lightdash, Power BI, Looker, Tableau or Metabase, on the agreed definitions and with curated numbers everyone can trust. You get production dashboards and reporting, documented so your teams can work with them on their own.

We like to build dashboards as a hierarchy, with each level seeing the aggregated KPIs of the level below.

03

Analytics engineering

dbt models turn raw data into clean, tested metrics. KPIs like CAC, churn or conversion update automatically every day. This is the unified foundation that reporting and analysis build on. You get a tested, documented dbt project in which your agreed KPI definitions live as code.

A consolidation of several entities across different accounting systems can live in dbt the same way, with documented rules your team maintains itself.

04

Data analysis & deep dives

When a question goes deeper than any standard dashboard, we analyse it directly, for example which products really make a margin or where appointments stay open. You get answers your team can turn into decisions, with the analysis behind them.

For example your own marketing attribution in the warehouse, or a marketing mix model that calculates budget scenarios per channel.

A typical discovery

Our business intelligence consulting usually starts with a short discovery, with interviews and a review of the source systems. It ends with a prioritised KPI set with written definitions, a list of terms your team still needs to settle and a recommendation for the technical next step.

InterviewsSource systemsKPI set with definitionsRecommendation
Typical problems

Typical problems we solve

Does any of this sound familiar? Then a conversation about your data analysis and reporting is worth having.

Everyone calculates differently

Marketing, finance and sales report different numbers for the same KPI because the definition was never agreed, and nobody knows which one to trust.

Reporting runs on Excel

Numbers live in spreadsheets, get updated by hand once a week and are out of date again by Friday.

KPIs are tracked too slowly

KPIs like CAC, channel conversion or churn cannot be tracked efficiently because they are not defined once and the processes behind them are manual.

Your data team is the bottleneck

Without agreed KPIs and a clear analysis structure, every question becomes a new request: there are more requests than capacity, and decisions wait on dashboards.

Business teams cannot reach the data

Without curated KPIs and technical help, non-technical teams find no quick answers to business questions.

Nobody knows which products make money

Leadership sees one blended P&L number, and below it every product is a question mark.

Budget owners lack their actuals

Budget owners never see their own actuals, and the management report gets built by hand every month.

New and existing business blur

Revenue from several billing systems cannot be split cleanly into new and existing business.

How we work

From discovery call to production

We work hands-on and focus on results, in four steps. First the numbers and definitions, then the tools.

01

Discovery call

We spend 30 to 60 minutes on your challenges, your data situation and the questions and KPIs your team steers by.

02

Scope & concept

We agree which KPIs and metric definitions bring the most value, then which dashboards show them and which sources the data comes from. This often starts with a short discovery that covers interviews, a look at the source systems and a recommendation with options.

03

Build

We build the data models that calculate your KPIs, then the dashboards on top, hands-on, tested and documented, and align every step with your team.

04

Production & enablement

Your teams work with the numbers and dashboards themselves. Where it helps, we also cover interim roles in your data team. At one client we carried the analytics work until their first analyst joined, then supported her.

Tools & technologies

The tools behind our BI consulting

We work with these tools, among others. Which ones fit depends on your setup.

dbt logoLightdash logoPower BI logoLooker logoTableau logoMetabase logoSnowflake logoGoogle BigQuery logo
Trusted by

70+ successful projects in six years, a senior team of 20 based in Berlin.

Viessmann logoVaillant logoyfood logoFlaschenpost logoglow25 logoheyData logoaudibene logoHomeToGo logoManiko logoWikinger Reisen logoasphaltgold logoPets Deli logoVALUE AG logomotel a mio logoju:it logoInno Nature logoMocMakler logon. logoSmoobu logoTasty Urban logoAUXEUM logohellomed logoNatsana logoSwappie logowholey logoFOND OF logoCleanwatts logoViessmann logoVaillant logoyfood logoFlaschenpost logoglow25 logoheyData logoaudibene logoHomeToGo logoManiko logoWikinger Reisen logoasphaltgold logoPets Deli logoVALUE AG logomotel a mio logoju:it logoInno Nature logoMocMakler logon. logoSmoobu logoTasty Urban logoAUXEUM logohellomed logoNatsana logoSwappie logowholey logoFOND OF logoCleanwatts logo
FAQ

Frequently asked questions about data analytics consulting

It depends on the scope. The main cost drivers are how many KPIs and metric definitions we need to agree on, how many data sources feed them, how many dashboards you need and whether a data warehouse already exists. Another driver is how many review rounds each metric definition needs. We usually plan for one. In a free discovery call we clarify your needs and outline what a project could look like. For eligible SMEs, BAFA funding can cover part of the consulting costs.

How long a BI project takes depends mostly on how quickly your teams agree on KPI definitions, how many data sources are involved and how many dashboards are in scope. A discovery usually takes about three weeks with around five consulting days. A first build with a few dashboards recently took about two months, a larger finance reporting setup around eleven weeks. We work out the timeline for your project in the discovery call.

Yes. Our clients have between 30 and 15,000 employees, most of them 50 to 200, and our case studies show growing companies like Glow25, Maniko and Natsana. BI consulting pays off most when your team has more requests than capacity and decisions wait on dashboards. For SMEs, BAFA funding can apply on top.

Among others dbt, Snowflake, Google BigQuery, Power BI, Looker, Tableau, Metabase and Lightdash. Which tools fit depends on your setup and your team.

BI and data analytics consulting delivers the numbers your teams steer by: KPI and metric design, dashboards, reporting and deeper analysis. Data Apps & Infrastructure builds what sits underneath: pipelines, the warehouse and the infrastructure. Often you need both, and we cover both in one team.

To Data Apps & Infrastructure

We are a consultancy that builds the solution ourselves and keeps running it if you want, which is what many people expect from a business intelligence agency or a data analytics agency. We start with your metrics and the decisions you make with them, and the dashboards come after that.

We build business intelligence solutions from the KPI system to the finished dashboard: reporting for management, self-service dashboards for business teams and deep dives, for example into margin per product or marketing attribution. Depending on your setup we use Lightdash, Power BI, Looker, Tableau or Metabase.

Yes. Data strategy consulting is part of our work, along with tool decisions, upskilling and hiring support. It usually starts with a short discovery: interviews, a look at the source systems and, at the end, a prioritised KPI set with a recommendation for the next technical step. We can then implement the data strategy with the same team.

Analytics engineering, meaning turning raw data into tested metrics with tools such as dbt, is mostly offered by specialised data consultancies in Germany. Gemma Analytics is one of them: we build dbt projects that hold your agreed KPI definitions as code, with a senior team based in Berlin.

Quite possibly, for BI projects too. Gemma Analytics is registered with BAFA as a consulting company. For eligible SMEs, the programme covers up to 50% (up to 80% in the new federal states) of eligible consulting costs as a non-repayable grant, up to a maximum amount. The application has to be approved before the project starts, and we walk you through it at no charge.

More about BAFA funding
Contact

Ready for numbers your team can rely on?

Book a free discovery call: 30 to 60 minutes, focused on your challenges.

Bijan, Founder & Managing Director at Gemma Analytics
Your contact

Bijan Soltani

Founder & Managing Director

Bijan and the Gemma team go through your data situation and your questions with you. In the call we also check whether your project qualifies for BAFA funding.