Heat Map
Heat Map
What Is This Report Type?
A Heat Map is a data visualization that uses a color gradient to represent the magnitude of values across a two-dimensional grid. Each cell in the grid sits at the intersection of an X-axis category and a Y-axis category, and is filled with a color that encodes the cell’s value—darker or more saturated colors indicate higher values, lighter colors indicate lower values.
Why Is It Used?
Heat Maps are ideal for identifying patterns, concentrations, and anomalies across two categorical dimensions simultaneously. The color-coded grid allows the eye to immediately spot clusters of high or low activity without scanning individual numbers—making them especially powerful for large datasets where tabular views would be overwhelming.
Key Features and Characteristics
| Feature | Description |
|---|---|
| Color Gradient Scale | A continuous or stepped color scale maps values to colors (e.g., white → orange → red). |
| Two-Dimensional Grid | Rows and columns each represent a categorical dimension; cells hold aggregated values. |
| Value Labels | Cells can display their exact numeric value alongside the color encoding. |
| Configurable Palette | Color scheme can be customized (sequential, diverging) depending on the data context. |
| Pattern Detection | Clusters of high-intensity cells reveal hotspots; sparse regions reveal gaps. |
When to Use It (Use Cases)
- Website Click Tracking: Showing which page areas receive the most user interactions by grid zone.
- Call Center Analysis: Displaying ticket volume by hour (rows) and day of week (columns) to identify peak periods.
- Sales Performance: Mapping revenue density across products (rows) and sales rep (columns).
- Attendance Patterns: Highlighting employee check-in frequency by day and hour.
Real-Time Business Example
Scenario: A support team manager needs to optimize staffing by identifying when ticket volume is highest throughout the week.
Visualization: A Heat Map shows 7 columns (Mon–Sun) and 24 rows (0–23 hours). Cells are colored on a scale from light yellow (low volume) to dark red (high volume). The chart immediately reveals dark red clusters between 9 AM and 12 PM on Monday through Wednesday—the peak support window. Friday afternoons and weekends appear pale yellow. The manager adjusts staff shifts to match the visible pattern.
Common Metrics Displayed
- Event Counts: Number of support tickets, logins, orders, or errors per time block.
- Revenue Density: Revenue values distributed across product × region or product × month grids.
- Correlation Matrices: Correlation coefficients between multiple numeric variables.
- Risk Scores: Risk intensity across risk categories and business units.
User Interactions
| Interaction | Behavior |
|---|---|
| Filters | Filter by date range, department, or segment to recalculate cell values. |
| Hover / Tooltip | Hovering over a cell reveals the exact X category, Y category, and aggregated value. |
| Click / Drill-Down | Clicking a cell navigates to the record list for that specific X-Y combination. |
| Color Scale | Adjust the color palette or threshold range to highlight specific value bands. |
| Export | Export to Excel. |
Creation Steps
- Select Heat Map as the report type.
- X-Axis: Drag a category field for columns (e.g., Day of Week).
- Y-Axis: Drag a category field for rows (e.g., Hour).
- Metrics: Drag the value field for cell color intensity (e.g., Ticket Count).