ConsultingProductsAIReferencesMediaCompanyDeutsch
Glossary

What is a drill-down?

Drill-down refers to an analysis function that lets users move step by step from an aggregated key figure into more detailed levels of a dataset. An annual value becomes quarters, a region becomes individual countries, a product group becomes individual items. The term roughly means drilling into the data. Drill-down is one of the basic functions of multidimensional data analysis and an integral part of OLAP systems. Bissantz has been working on interactive data analysis for many years and uses drill-down functions in the analysis and reporting software DeltaMaster.

AT A GLANCE

At a glance

  • Drill-down is the step-by-step breakdown of an aggregated key figure into finer levels of detail.
  • The opposite is the roll-up, that is, the aggregation of detail data into totals.
  • The basis is hierarchically structured dimensions such as time, region or product.
  • Drill-down is a central function in OLAP systems, BI tools and dashboards.
  • It is to be distinguished from drill-through, which leads to underlying individual records or to another report.

What question do you have about drill-downs?

Your input is sent to an AI service to answer it and is stored to improve the answers. Please do not enter any personal data. Privacy policy

DEFINITION

Drill-down definition

A drill-down is a navigation function in data analysis in which an aggregated key figure is broken down into its components along a hierarchy. If a controller looks at the total revenue of a year, for example, a drill-down to the next time level leads to the revenues of the individual quarters, and from there further to months or days. The same principle applies to other dimensions such as product, customer or sales territory.

Technically, a drill-down requires the data to be structured in hierarchies whose levels are clearly related to one another. The function is thus closely tied to the multidimensional data model as it is used in OLAP systems. The term comes from English and roughly means to drill into or to break down.

„In the past, we requested a new report for every detailed question. With drill-down, we click our way from the group total down to the individual store in seconds and find the causes ourselves.“
Head of Controlling
Retail company
RELEVANCE

What do drill-downs mean for controlling and BI?

Drill-downs make reports interactive. Instead of creating a separate report for every detailed question, users navigate from the overall view into the details themselves. This significantly shortens the path from a conspicuous figure to its cause: if a KPI shows a variance, targeted breakdown quickly reveals which region, which product, or which time period is the decisive factor. A drill-down is therefore a core element of modern variance and cause analysis and a foundation for efficient reporting.

Trusted by market leaders and hidden champions

AI

Drill-down vs. drill-through – what is the difference?

Drill-down and drill-through refer to different operations in data analysis.

  • With drill-down you stay within the same data structure and move along a hierarchy from one aggregation level to the next finer one. The result is always a refinement of the same key figure.
  • With drill-through, on the other hand, you leave the current view and switch to the underlying individual records or to a linked detail report, often with additional attributes that are not contained in the aggregation.

In short: drill-down refines within the hierarchy, drill-through jumps to the data source or to another context. Further navigation directions are drill-across and drill-up, or roll-up.

Navigation directionDescriptionExample
Drill-downNavigation from aggregated to detailed levelFrom year to quarter to month
Roll-up (drill-up)Navigation from detailed to aggregated level, the opposite of drill-downFrom product to product group to assortment
Drill-acrossSwitch to another dimension at the same levelFrom revenue by region to revenue by sales channel
Drill-throughJump from an aggregated key figure to the underlying individual recordsFrom monthly revenue to the individual invoice line
HOW IT WORKS

How does a drill-down work?

A drill-down follows the logic of hierarchically structured dimensions and usually proceeds in several steps.

Hierarchical dimensions

The basis of every drill-down is structured dimensions with multiple levels, for example time (year, quarter, month) or organization (region, country, branch).

Interactive navigation

Clicking on an element expands the level below it. Aggregated totals break down into their components without the user formulating new queries.

Consistent aggregation

On each level the KPIs are condensed correctly, so that the sum of the detail values adds up again to the higher-level value.

Roll-up as the reverse

The path back to the condensed view, called roll-up or drill-up, complements the drill-down to form complete upward and downward navigation.

LIMITS

What are typical mistakes and limits of drill-down?

As intuitive as drill-down may seem, recurring problems arise in practice that can lead to false conclusions.

  • Non-additive KPIs: KPIs such as average prices, ratios, or inventory levels cannot simply be added up. A drill-down that applies the summation logic to such values without question produces misleading subtotals.
  • Incomplete hierarchies: If individual detail elements lack higher-level assignments, residual items or unassigned values arise that suddenly disappear or appear twice when broken down.
  • Excessive depth of detail: Anyone who thoughtlessly drills all the way down to the lowest level easily loses the overview. Without an indication of where a variance actually originates, each level is checked individually, which is time-consuming.
  • Ambiguous hierarchies: If a product belongs to several groups, or a store changes region over time, the drill-down result is no longer unambiguous.
  • Response times: With very large data volumes, each step can be noticeably delayed, which undermines the interactive character.

Those who are aware of these limits interpret broken-down values more cautiously and pay attention to clean hierarchies and correct aggregation rules as early as the modeling stage.

The people shown were generated with artificial intelligence and are fictitious.

The latest developments in BI and controlling

Articles, insights and expert perspectives on business intelligence, data analytics and artificial intelligence. Discover the latest trends, practical applications and strategies for making better data-driven decisions.

To the blog
Controllerin arbeitet mit Prognosedaten auf einem Tablet
PREREQUISITES

What are the prerequisites for effective drill-downs?

For a drill-down to work reliably, a number of conditions concerning the data model and the data basis must be met.

Multidimensional data model

Drill-down requires a data model with defined dimensions and hierarchies, as set up in OLAP systems or data warehouses.

Defined hierarchies

The relationships between the levels must be modeled unambiguously so that navigation works consistently.

Sufficient response times

For interactive navigation to be practical, queries across the hierarchy levels must be answered quickly.

Consistent KPIs

The aggregation logic must ensure that detail values add up correctly to the higher-level totals.

EXAMPLES

Examples of drill-downs

Users encounter drill-down in almost every analytical application. A few typical situations illustrate the principle:

Time-based analysis

Navigate from annual revenue through quarters and months down to individual days to identify seasonal patterns and outliers.

Regional breakdown

Break down from total revenue to countries, regions and individual branches to compare locations.

Product hierarchy

From ranges through product groups down to individual articles to find the drivers of revenue or margin.

Pivot table in Excel

A drill-down in Excel is created by expanding groupings in a pivot table to display detail rows.

Variance analysis

Break down a conspicuous plan-actual variance level by level until the causing unit becomes visible.

Customer structure

Navigate from total revenue through customer segments down to individual customers to assess concentrations.

Where would you like to use drill-downs?

Your input is sent to an AI service to answer it and is stored to improve the answers. Please do not enter any personal data. Privacy policy

Drill-downs with DeltaMaster from Bissantz

In the analysis and reporting software DeltaMaster from Bissantz, drill-down is integrated consistently into all reports. Users break down key figures along any hierarchies, combine the drill-down with automatic anomaly detection and thus move without detours from the overall view to the cause. The function is consistently aligned with the multidimensional data model.

The use of artificial intelligence further simplifies data analysis. Users can ask questions in natural language and, for example, specifically inquire about the causes of certain anomalies. Instead of clicking manually through report levels, they can thus also perform drill-downs via commands in natural language.

FunctionBenefit
Drill-down on every KPI and dimension Conspicuous items can be traced directly to the cause, without a new report.
Combination of drill-down and roll-up Users move freely between overview and detail in both directions.
Automatic highlighting of conspicuous items The path to the relevant level of detail is shortened because outliers become visible.
Consistent aggregation across all levels Detailed values reliably add up to the condensed KPIs.
AI-supported drill-downs Users can ask questions in their own words and search for specific KPIs or causes.
„The combination of drill-down and roll-up has noticeably accelerated our monthly closings. Today, we review variances along the hierarchy instead of searching through raw data.“
Head of Finance and Accounting
Industrial company
FAQ

Frequently asked questions

What is a drill-down, explained simply?

A drill-down means moving from a general overview ever deeper into individual details. You can display more precise information, for example by clicking on a particular area or value. In other words, you look at something step by step in more detail to learn more.

What does drill-down mean in German?

Drill-down can be translated as "aufschlüsseln" (break down), "in die Tiefe bohren" (drill into depth), or "detaillieren" (detail). It refers to breaking a total down into finer levels of detail. No Germanized technical term has caught on, so the English term is usually used.

What is the opposite of drill-down?

The opposite is the roll-up, also called drill-up. Here you move from the detailed level to the aggregated level, condensing individual values back into higher-level totals.

What is the difference between drill-down and drill-through?

With drill-down, you stay within the same hierarchy and switch to a deeper but still aggregated level. With drill-through, you jump from a KPI to the underlying individual records or to another report.

What is a drill-down in Excel?

In Excel, a drill-down is created mainly via pivot tables. By expanding groupings or double-clicking a cell, you can display the detail rows that make up an aggregated value. With Bissantz, this process is easier and clearer, since you can dive deeper into the data directly within the analyses and display detailed information.

What are the prerequisites for a drill-down?

What is required is a multidimensional data model with clearly defined dimensions and hierarchies, consistent aggregation logic, and sufficiently fast queries so that interactive navigation is possible.

SUMMARY

Summary

Drill-down is the step-by-step breakdown of an aggregated key figure along hierarchically structured dimensions and is thus a basic function of interactive data analysis. It is the counterpart to the roll-up and is to be distinguished from the drill-through, which leads to the underlying individual data or to another report. In practice, drill-down considerably accelerates cause analysis in controlling. Bissantz uses the function in the analysis and reporting software DeltaMaster.

Analyze data interactively

Find out how drill-down, variance analysis and automatic anomaly detection work together in controlling. Our experts will show you the path from the key figure to the cause.

Get in touch