Navigation

Get in touch
Logo
News

Business intelligence

Wrong numbers. Costly decisions.

A key figure should mean the same thing in sales, finance and management. We develop shared data models, understandable dashboards and traceable reports. Instead of more individual analyses, your teams get an aligned basis for decisions.

person using MacBook Pro — illustrative image
KPI catalog · Planning and implementation by OTOKO®

Your brief for OTOKO®

What we take care of for you.

Revenue can mean incoming orders, invoicing or incoming payments. We document the calculation logic, time reference, exclusions and owner for each key figure. Together, we review sample cases: credit notes, canceled transactions, changing currencies and later postings. A semantic model connects these rules with the source data. This way, the meaning of a key figure is maintained centrally, instead of rebuilding the same formula differently across several reports.

The possible scope of services

  • KPI catalog with definitions, formulas and owners
  • Semantic data model as the shared basis of all reports
  • Dashboards and reports in Power BI, Tableau or open-source tools
  • Row-level and column-level permissions connected to your directory
  • Recurring reports for supervisory authorities and management with versioning

We define the specific scope, your involvement and the acceptance criteria before the start.

Technology explained clearly

How we carry out the task.

01

From management overview to explainable detail

Dashboards start with the decision they are meant to support. A deviation can be traced down to the underlying data, as far as permissions allow. Row-level permissions limit locations, for example; sensitive columns may need additional restrictions. We check data exports as well as the display. The update status and filters stay visible. For large models, we test data aggregation, query times and refresh windows, so a month-end close does not fail because of an overloaded reporting environment.

02

Signing off reports against business control totals

Together with the business units, we compare defined key figures and edge cases against agreed reference figures. The handover includes the model, a KPI catalog and a controlled change process. Self-service then means analyzing data independently within these rules. Good starting points are existing Excel reports, discussions about diverging figures and the questions that today can only be answered with manual preparation.

Meeting room at the OTOKO® Cologne office

A verifiable result

What you keep working with.

  1. KPI catalog
  2. Data model and report suite
  3. Permission concept with evidence

The handover brings together implementation and documentation. Together, we review the agreed cases and record any remaining tasks.

Your project in detail

Explain key figures and support decisions.

A dashboard is useful when its users know which decision it supports and how the numbers come about. We develop analyses together with the business units and check both the presentation and the underlying business calculation.

Clearly define key figure, period and comparison

Revenue can mean incoming orders, the invoiced amount or incoming payments. We record the definition, reference period, currency and exceptions before any visualizations are built. These rules are captured in a reusable business data model, so that different reports do not calculate the same key figure differently.

Together with the future users, we determine the level of detail needed: management, team leads and case workers need different views. Filters, comparison periods and drill-down options are aligned with their tasks. The user interface shows which data snapshot the figures are based on and which limitations apply to their interpretation.

Deploy reports to production and control changes

We check permissions down to the required data level, for example by location or organizational unit. An approved report must not unintentionally show more information through an export or an additional view. For personal data, the required scope is agreed with the responsible owners.

Operation includes updates, error handling and maintenance of the key figure model. Changes are checked with comparison calculations and approved from a business perspective. We also look at load times and usage: a report with many unused charts is not automatically better. What matters is a clear overview and targeted paths to the details.

Illustrative project scenario

How the service helps in everyday use.

Example: A sales manager sees declining revenue but needs to distinguish between missing orders and delayed invoicing. We connect the relevant process data and build an overview with a transparent drill-down. This makes it possible to investigate the cause instead of just showing a number in red.

This example explains a possible process and is not a customer reference.

Before the first step

Your questions about Business intelligence.

Can we continue using Power BI?

Yes. We review the data model, permissions and refresh paths in your existing tool. Switching tools is not a prerequisite for better metrics.

Do dashboards replace expert review?

No. Visualization can even make data errors look convincing. Acceptance and business responsibility for metrics are explicitly defined.

Your project

Which task would you like to solve?

Describe your situation and the desired result. The selected service will be included in the contact request.

Request this service

Our Partners

  • Microsoft
  • Microsoft Azure
  • Amazon AWS
  • Google Cloud
  • Thales Group
  • Arrow ECS
  • Vodafone
  • IBM
  • Veeam
  • Atlassian
  • JetBrains
  • NinjaOne
  • OPSWAT
  • Utimaco
  • Eviden

Accessibility

Adjust the display to suit your needs.

A simple version is not available for this page yet.

Settings currently apply to this visit. Allow saving in Cookie settings to remember them.