DataIntermediate 2 to 3 hours

Build Filters and Drill-Downs

Design interactive dashboard filters that let users slice data by region, product, and time.

The Scenario

A national sales dashboard currently shows a single view of total company revenue. The regional managers want to filter by their region, drill into product categories, and compare this quarter to last quarter. The current dashboard has no interactivity.

The Brief

Design the filter architecture for an interactive BI dashboard. Specify which filters exist, how they interact (cascading vs independent), and what happens when a user applies multiple filters simultaneously.

Deliverables

  • A list of all filters: Region (multi-select), Product Category (cascading), Date Range (picker), and Comparison Period (toggle)
  • The filter interaction model: which filters are independent and which cascade (e.g., selecting a region narrows the product list)
  • The default state: what the dashboard shows when no filters are applied
  • One edge case: what happens when a filter combination returns zero results

Submission Guidance

A dashboard with 10 filters and no guidance is unusable. Think about progressive disclosure — show the most-used filters first.

Submit Your Work

Your submission is graded against the rubric on the right. If you pass, you get a public Badge URL you can share on LinkedIn. There is no draft save, so work offline first and paste your finished response here.

This appears on your public Badge.

0/20000 charactersMarkdown supported

One per line or comma separated. Up to 5 links.

By submitting, you agree your submission text, name, and evaluation will appear on a public Badge URL.