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
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
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





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 direction | Description | Example |
|---|---|---|
| Drill-down | Navigation from aggregated to detailed level | From year to quarter to month |
| Roll-up (drill-up) | Navigation from detailed to aggregated level, the opposite of drill-down | From product to product group to assortment |
| Drill-across | Switch to another dimension at the same level | From revenue by region to revenue by sales channel |
| Drill-through | Jump from an aggregated key figure to the underlying individual records | From monthly revenue to the individual invoice line |
How does a drill-down work?
A drill-down follows the logic of hierarchically structured dimensions and usually proceeds in several steps.
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.
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.
Examples of drill-downs
Users encounter drill-down in almost every analytical application. A few typical situations illustrate the principle:
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.
| Function | Benefit |
|---|---|
| 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
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
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.
Related topics
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