Study notes
By the end of this lesson you can:
- Explain the purpose of a dashboard and the main types of business dashboards.
- Plan a dashboard layout with a clear visual hierarchy, and choose a size setting.
- Use tiled and floating objects and horizontal and vertical containers.
- Add shared filters and filter, highlight and URL actions.
- Review a dashboard for consistency, usability and accuracy.
Key idea: A dashboard is a decision tool, not a collection of charts. Design it around the few questions its user must answer, put the most important information where the eye lands first, and let interaction handle the detail.
Dashboard purpose and components
The lecture defines a dashboard as a graphical interface that provides an overview of data, serving as a tool for information management and business intelligence. Dashboards differ by purpose:
| Type | User | Typical content |
|---|
| Strategic | Executives | A few KPIs and long-term trends |
| Operational | Managers and staff | Current status, alerts, daily or weekly figures |
| Analytical | Analysts | Interactive views to explore causes |
In Tableau, a dashboard combines worksheets with objects: text, images, web pages, blanks for spacing, navigation buttons, download buttons and extensions, plus filter, parameter and legend cards.
Layout and visual hierarchy
- Reading order. Viewers usually scan from top left. Put the headline KPIs at the top, the main chart next, and supporting detail below or to the right.
- Few views. Three to five views is a common rule of thumb; more usually means the dashboard serves too many questions.
- Alignment and spacing. Align views to a grid, use consistent padding and leave white space between groups.
- Consistency. The same colour should mean the same thing in every view (for example one colour per Category), and number formats should match.
Size, containers and objects
- Size: Fixed size keeps the layout exactly as designed (best for precise layouts and published dashboards); Automatic resizes to the window (layouts can shift); Range sets a minimum and maximum. The Device Preview lets you create separate layouts for desktop, tablet and phone.
- Tiled versus floating: tiled objects snap into a grid and do not overlap; floating objects can be placed anywhere on top. Use tiled for the main structure and floating sparingly (for example a small logo or legend).
- Containers: horizontal containers place items side by side; vertical containers stack them. Nesting containers keeps the layout tidy, and Distribute Contents Evenly gives items equal space.
Filters and actions
- Shared filters: a filter card normally affects one sheet. Set Apply to Worksheets to All Using This Data Source (or All Using Related Data Sources, or Selected Worksheets) so one filter controls several views.
- Use as Filter: the funnel icon on a sheet makes it filter the rest of the dashboard.
- Dashboard actions (Dashboard → Actions): filter actions limit other views to the selected marks; highlight actions emphasise related marks and dim others; URL actions open a web page; others change parameters or set values or go to another sheet. Each runs on hover, select or menu.
Text, annotation and review
A dashboard title should state the main message or purpose. Add a short note on data source, date range and definitions (for example how profit ratio is calculated). Then review: Can a new user answer the key questions within about 30 seconds? Do filters affect the views they should? Do totals match the source? Is it readable at the chosen size?
Worked example
Design, on paper first, a dashboard for the category manager of the course's office-supplies retailer, who must decide which sub-categories need price or discount changes.
- Questions. (a) How are Sales and Profit of my categories developing? (b) Which sub-categories lose money? (c) Is the problem linked to discounts or to particular regions?
- Type and size. Analytical-operational, viewed on a laptop: Fixed size, for example 1200 × 800.
- Layout. Top row (horizontal container): KPI text sheets for Sales, Profit and Profit Ratio. Middle row: monthly Sales and Profit Ratio as a dual-axis chart on the left; Profit by Sub-Category, sorted, with a diverging palette on the right. Bottom: Profit Ratio by Discount band.
- Filters. Category and Year filters applied to All Using This Data Source, so every view shows the same slice.
- Actions. A filter action from the Sub-Category chart: clicking a sub-category filters the trend and the discount chart to that sub-category. A highlight action on Region in a small map lets the manager see regional differences without filtering everything.
- Text. Title states the purpose ("Where are we losing margin?"); a note gives the date range and the profit ratio definition.
- Review. Ask a classmate to find the weakest sub-category and its likely cause in 30 seconds. If they hesitate, simplify: remove a view, enlarge the key chart or make the title more specific.
Common mistakes
- Too many views. Eight small charts compete for attention; split into two dashboards or use a story.
- Automatic size by default. Layouts can break on different screens; prefer fixed size unless you test the range.
- Filters that silently apply to one sheet. Users assume a filter affects everything; set Apply to Worksheets deliberately.
- Inconsistent colours. If Technology is blue in one view and orange in another, readers misread the dashboard.
Summary
- A dashboard is an overview tool for decisions; match its type to the user.
- Put KPIs and the main message top left, keep to a few aligned views, and use consistent colours and formats.
- Choose fixed, automatic or range size; build structure with tiled objects and containers.
- Shared filters and filter, highlight and URL actions make the dashboard interactive.
- Review usability and accuracy with someone who has not seen the data.