The Cluttered Executive Dashboard: Balancing Detail and Clarity
A sales operations analyst is building a dashboard for the executive team to monitor regional sales performance. The dashboard includes a map showing sales by state, a bar chart of top 10 products, a line chart of monthly sales trends, a scatter plot of profit vs. sales by customer, and a KPI indicator for total sales. The dashboard is designed for a 1920x1080 screen. During a review, executives complain that the dashboard is overwhelming and they cannot quickly see which regions are underperforming. They also mention that the map is too small to distinguish between states in the northeast. The analyst has 30 minutes to make improvements before the next executive meeting. The dashboard currently uses a single filter for Year and Region, and all sheets are set to 'Use All Filters'.
1. What are the most critical design changes the analyst should make to improve clarity and meet the executives' needs, given the time constraint?
Read the worked answer
Given the 30-minute constraint, the analyst should prioritize changes that directly address the executives' complaints:
- Enlarge the map: Increase the size of the map to at least 40% of the dashboard width, and use a filled map with a diverging color palette (e.g., red for low sales, green for high) to immediately highlight underperforming regions. Add state labels for the northeast or use a zoomed-in inset.
- Add a highlight action: Set up a highlight action from the map to the bar chart and line chart, so selecting a state filters the other views to that state's data, allowing drill-down without clutter.
- Simplify the layout: Remove the scatter plot from the main dashboard (or move it to a secondary tab) as it is less critical for executive oversight. Replace it with a simple ranked bar chart of regions by sales, sorted ascending, to quickly show underperformers.
- Use a KPI indicator with conditional formatting: Make the total sales KPI large and add a trend arrow or color indicator (e.g., red if below target) to draw attention.
- Ensure filters are applied appropriately: The Year filter should be global, but the Region filter might be better as a parameter or quick filter that only affects the map and bar chart, not the trend line (which should show all regions for context). Adjust filter scopes accordingly.
These changes can be done quickly by resizing, changing chart types, and adding actions. The analyst should test on a similar screen size and get quick feedback.
2. How should the analyst handle the filter scoping to ensure that the dashboard remains interactive and not confusing?
Read the worked answer
Filter scoping is crucial to avoid confusion. The analyst should:
- Keep the Year filter applied to all worksheets (global) because the time context is consistent.
- Change the Region filter to apply only to the map and the top products bar chart, not to the trend line. The trend line should show overall sales trends for all regions to provide context. Alternatively, use a parameter to select a region and use calculated fields to filter specific sheets.
- Use actions (highlight or filter) instead of quick filters for cross-filtering. For example, a highlight action from the map to the bar chart allows executives to see product performance for a selected state without filtering out other data in the trend line.
- Ensure that the 'Use All Filters' setting is not causing unintended filtering. The analyst should review each sheet's filter scope and set them appropriately.
By scoping filters thoughtfully, the dashboard remains interactive but not overwhelming, and executives can explore data without losing context.