TechPrufer
Get started
Hex
Hex logoHex · Feature trail

Drill-down Analysis

3 posts · Aug 2023 – May 2026

What this trail covers

Hex has evolved its data exploration capabilities by introducing and detailing drill-down analysis. This feature allows users to navigate from aggregate summary metrics to progressively more granular detail by descending through a predefined data hierarchy. The post explains how drill-down powers diagnostic analysis, its distinctions from filtering and drill-through, and the critical importance of upstream data modeling decisions (granularity, ragged hierarchies, slowly changing dimensions, non-conformed dimensions). It also highlights the limitations of predefined paths and the need for flexible exploration beyond them.

All Hex trails
  1. What Is Drill-down Analysis? How It Works And When It BreaksThis post details drill-down analysis as a data exploration technique, explaining its mechanism of navigating aggregate summary metrics to granular detail through predefined data hierarchies. It clarifies the distinctions between drill-down, drill-through, and drill-up, and emphasizes how the quality of drill-down is critically dependent on upstream data modeling decisions, particularly granularity, ragged hierarchies, slowly changing dimensions, and non-conformed dimensions. The post also discusses the limitations of predefined paths and the need for flexible exploration beyond them.
  2. The case for warehouse-based product analyticsThis post details the implementation and benefits of warehouse-based product analytics, contrasting it with event-based tools. It introduces a framework for evaluating feature success (adoption, retention, satisfaction) and explains how warehouse-centric approaches enable richer analysis by allowing data enrichment and the integration of diverse data sources like survey data and customer support tickets. It highlights the use of input parameters and parameterized SQL within Hex for creating extensible feature success dashboards and emphasizes the importance of reliable feature adoption measurement.