Skip to content
Technology transformation expertise firm · ARDIANE Group Innovate, secure, succeed

Data

Business intelligence and augmented analytics

Three dashboards, three revenue figures: the problem does not come from the reporting tool, but from the lack of a shared definition. Our consultants help your teams build a BI where each indicator is defined once and reused everywhere.

Our principles

  • Each indicator defined and calculated in a single place
  • Self-service opened up by levels of autonomy
  • AI-driven analytics backed by reliable definitions
In brief

Business intelligence (BI, or decision support) brings together the methods and tools that turn data into indicators, dashboards and analyses useful for decision-making. Management Square consultants help your teams define indicators with the business, calculate them once in a semantic layer, organise self-service and prepare AI-driven analytics.

Scope

How we contribute

  1. Inventory of your BI estate

    Listing of reports and dashboards, measurement of their actual use, identification of duplicates and of indicators calculated in several ways.

  2. Indicator dictionary

    Definition, calculation rule, scope and owner of each management indicator, agreed with the business areas concerned before any development.

  3. Semantic layer

    A model that describes indicators, analysis dimensions and access rights in business terms, queried by all tools so that the same calculation gives the same result everywhere.

  4. Management dashboards

    Design based on the decisions each governance body has to take: few indicators, ranked, with the thresholds and comparisons that give them meaning.

  5. Organising self-service

    Levels of autonomy, workspaces, content certification process, training of business analysts and retirement of unused reports.

  6. AI-augmented analytics

    Natural language querying and explanation of variations, connected to the semantic layer, evaluated on a set of reference questions before being opened up.

Page contents

Why business intelligence produces figures that contradict each other

Business intelligence is one of the oldest data workstreams, and one that management readily complains about. The stock of reports grows without anyone knowing which ones are still consulted. Two dashboards presented to the same committee display two values for the same indicator, and the meeting is spent trying to work out which one is right.

The reporting tool is rarely to blame. The calculation rule is buried in each report: each author applies their own filters, period and exclusions. The “margin” or the “active customer” therefore exists in as many versions as there are reports. Self-service, opened up without a framework, has accelerated the phenomenon.

A second cause is less visible. Many dashboards were designed from the data available, and not from the decisions to be taken. They provide plenty of information, but do not help to make decisions.

The semantic layer: defining each indicator only once

The semantic layer sits between the platform’s tables (warehouse or lakehouse) and the reporting tools. It describes in business terms the indicators, the analysis dimensions, the relationships between tables and the access rules. An indicator is calculated there in a single place. The reports, connected spreadsheets and assistants that query it all obtain the same value.

Its design calls for three decisions.

Where to place it. In the reporting tool, it is simple to set up but only serves that tool. In an independent layer, it can be reused by several tools and by applications, at the cost of an additional component to operate. The choice depends on the number of tools in service and on the role AI will play in accessing data.

What model to base it on. The star schema, which separates the measured facts from the analysis dimensions, remains the most readable basis for the business and the most predictable in terms of performance. It is prepared in the data platform, not in each report.

Who validates. An indicator only enters the semantic layer with an agreed definition and a business owner. Without this rule, the semantic layer reproduces the disorder it was meant to resolve.

Self-service: three levels of autonomy

Self-service is not an on/off switch. Not all users have the same needs or the same skills, and the framework must reflect this.

Level What the user does What they need to be provided with
Consultation Reads, filters and explores certified dashboards A small amount of documented content, with the source displayed
Analysis Builds their own views from the indicators in the semantic layer A readable model, training, a personal or team workspace
Production Creates new datasets and new indicators Prepared data, modelling rules, a review process

Two mechanisms hold everything together. Certification visibly distinguishes what is authoritative from what is exploratory: a user can tell at a glance whether they can present a figure in committee. The life cycle retires what is no longer used, based on consultation statistics.

AI-augmented analytics: what it brings, what it requires

Three uses stand out: querying data in natural language, automatic explanation of a variation (which segments explain the fall in an indicator) and drafting summary commentary.

The risk lies in the nature of a language model. Placed in front of raw tables, it has to guess the joins, filters and business rules. It then produces a well-worded answer, sometimes wrong, with no error signal. For a figure intended for a decision, this behaviour is not acceptable.

The remedy is to have the model go through the semantic layer. It translates the question into a selection of existing indicators and dimensions; the calculation itself remains deterministic. Four conditions are added: carefully written business descriptions, including synonyms; access rights that remain those of the user; display of the indicators and filters used for each answer; a set of reference questions, with the expected answers, to evaluate the assistant before it is opened up and after each change. These principles are the same as those we apply to generative AI projects.

Our approach: from decisions to data

Our consultants work within your teams; decisions remain yours.

Measuring the existing estate. We inventory reports and their actual use. This survey highlights content to be retired and conflicting indicators.

Starting from the management bodies. For each committee, we identify the decisions to be taken, then the indicators that inform them. The indicator dictionary is agreed at this stage, with the business owners.

Building on a first domain. The semantic layer is implemented on a limited scope. The priority dashboards are rebuilt on it, and the old ones are decommissioned as you go.

Opening up in stages. Self-service is extended level by level, with the corresponding training and a network of lead analysts in the business areas. AI is introduced when the definitions are stable, not before.

The seemingly good ideas we advise against

  • Changing tool to solve a definitions problem. The new tool will display the same discrepancies, with better presentation.
  • Migrating all reports like for like. A change of tool does not justify carrying over reports that nobody opens any more.
  • Opening self-service on raw tables. Each user then recreates their own calculation rule.
  • Piling up indicators. A dashboard that displays dozens of them ranks nothing and triggers no decision.
  • Treating a data defect in the reporting layer. When the discrepancy comes from the sources and not from the definitions, it falls within data quality and is corrected upstream.

How to know whether your BI serves decision-making

The indicators agreed at the scoping stage concern use and trust, not the volume produced.

  • The share of reports actually consulted, and the number of items of content retired.
  • The share of consultations that concern certified content.
  • The number of management indicators with a single definition and an owner.
  • The time taken to obtain a new analysis, and the share of requests handled independently by the business.
  • For an analytics assistant: the rate of correct answers on the set of reference questions.

One qualitative sign is worth all the others. When committees stop discussing the validity of the figures and start discussing what to do with them, the BI is fulfilling its role.

Typical work

What our consultants contribute to

Report map

Inventory of existing content with its measured use and a proposal to keep, merge or retire it.

Indicator dictionary

Agreed definitions, calculation rules, sources and owners of the indicators within scope.

Semantic model

Indicators, dimensions and access rules implemented with your teams, tested and documented on the first domain.

Self-service rules

Levels of autonomy, certification criteria, content life cycle and training paths.

Management Square in figures

300+
projects completed
43+
clients supported
Since2015
serving our clients
  • Allianz
  • Euler Hermes
  • Groupe BPCE
  • ODDO BHF
  • Candriam
  • Ledger
  • Saur
  • Veolia
  • Voltalia
  • emeis
  • Bonpoint
  • Legal Suite

FAQ

Frequently asked questions

Another question? Ask us

What is business intelligence?

Business intelligence, or decision support, refers to the methods and tools that collect, model and present an organisation's data to inform its decisions. It produces indicators, dashboards and analyses. Its value does not lie in the number of reports, but in the decisions it makes faster and better founded.

What is a semantic layer?

A semantic layer is an intermediate model between data tables and reporting tools. It describes, in business vocabulary, the indicators, their calculation rules, the analysis dimensions and access rights. Each indicator is defined there only once, so that all the reports that use it display the same value.

How do you prevent reports from proliferating in self-service?

By clearly distinguishing certified content from exploratory content, and by giving users indicators that are already defined rather than raw tables. A life cycle completes the arrangement: reports that are no longer consulted are flagged to their author, then retired. Business autonomy is not the problem; the lack of a framework is.

Can you query your data in natural language with a language model?

Yes, provided the model is not left to guess the calculation rules. When it generates queries directly on raw tables, it can produce a plausible but wrong result. The reliable approach is to have it select indicators and dimensions already defined in the semantic layer, with the calculation remaining deterministic and the access rights remaining those of the user.

Should you change BI tool to resolve discrepancies in figures?

Rarely. Discrepancies most often come from competing definitions or diverging source data, which the new tool would reproduce identically. A change of tool is justified for other reasons, such as cost, performance or end of support, and is best preceded by agreement on the indicators.

A project to bring to completion?

A first conversation is enough to understand your challenge, identify the right people and tell you frankly what we can bring.