Stop 05 · Data VisualizationTopics · 9/10

Interactive Dashboards

Part of the Data Analyst Roadmap

In short

Instead of making ten nearly identical charts for ten managers, build one dashboard with filters. Each person clicks their region and gets their answer without messaging you.

Adding filters, drill-downs and parameters so one dashboard can answer many related questions instead of requiring a separate static chart for each — covered in tool-specific depth in Phase 7.

The jaadu turns knobs and sliders on a control panel that changes coloured bars above.

Think of it like this

The music system's knobs

A home music system has one set of speakers but knobs for bass, treble and volume. Everyone tunes it their way without buying new speakers. Filters, drill-downs and parameters are the knobs on your dashboard: same data, each person's view.

Watch it happen

A manager exploring a dashboard

Manager
Dashboard
Data source

Region = South

1/5The manager picks their region from a dropdown filter.

The big ideas

What you need to know

Filters

Dropdowns or buttons that narrow all charts at once, like by date, region or product.

Drill-down

Click a summary to see the level below: country to state to city.

Parameters

Let users change a value, like a target or growth rate, and see the effect.

Keep it fast

Slow dashboards don't get used. Limit default date ranges and pre-aggregate heavy data.

Save yourself the pain

Common mistakes

Oops

Adding ten filters so users can 'explore anything'.

Do this instead

Offer the two or three filters people actually need. Too many choices confuse.

Oops

Filters that silently don't apply to some charts.

Do this instead

Make sure every chart responds, or clearly label the ones that don't.

Your mission

Build a filterable view

~40 min

Quick check

What's the main benefit of an interactive filter on a dashboard?

Go deeper

  1. 1Add a filter or slicer to a dashboard and test how it changes the underlying charts.
  2. 2Learn the trade-off: more interactivity can also mean more complexity for the viewer.
  3. 3Preview Phase 7 for the BI-tool-specific mechanics of building this.

More topics at this stop

Stuck on this topic? Ask an Insider

Get 1:1 guidance from people who've walked this exact path — on the InsideEdge app.

Download
InsideEdge