Data Visualization & BI using Power BI & Tableau

Chapter 3
Visual Perception and Information Design

Diploma in Business Analytics
Data Visualization & BI using Power BI & Tableau   •   Diploma

Visual Perception and Information Design

Introduction

Data visualization is not simply the conversion of tables into charts. It is the deliberate design of visual representations that help people notice patterns, compare values, identify exceptions, and make decisions. In Power BI and Tableau, a technically correct visual can still fail if it creates unnecessary cognitive effort, hides important differences, or suggests a conclusion that the data does not support.

This chapter examines the principles that connect human visual perception with effective information design. It focuses on pre-attentive attributes, Gestalt principles, visual hierarchy, cognitive-load theory, colour, data-ink, chart selection, and ethical avoidance of distortion. These principles apply directly to dashboards, reports, presentations, and self-service analytics products.

Learning Objectives

By the end of this chapter, you should be able to:

  • Explain how visual perception influences dashboard interpretation.
  • Apply pre-attentive attributes to direct attention.
  • Use Gestalt principles to organise visual elements.
  • Establish a clear visual hierarchy.
  • Reduce unnecessary cognitive load and visual clutter.
  • Select suitable colours and accessible palettes.
  • Apply data-ink principles without removing useful context.
  • Select charts according to analytical purpose and data structure.
  • Identify misleading scales, inappropriate comparisons, and decorative distortion.
  • Evaluate and improve a Power BI or Tableau dashboard.

1. Visualisation as a Communication System

A visualization has at least three components: the data, the visual encoding, and the reader. Data values are encoded through position, length, angle, area, colour, shape, size, and other visual variables. The reader decodes these signals using perception, attention, memory, prior knowledge, and expectations.

The effectiveness of a chart depends on the accuracy and speed with which a reader can decode the intended message. Position along a common scale is usually easier to compare than angle or area. For example, a bar chart normally supports more accurate comparison than a pie chart when many categories have similar values.

Information design therefore involves choices such as:

  • What question should the visual answer?
  • Which comparison is most important?
  • Which values should attract attention first?
  • What context is necessary for interpretation?
  • Which details can be removed without harming understanding?

A dashboard is successful when its visual structure supports the user’s task rather than competing with it.

2. Pre-attentive Attributes

Pre-attentive processing refers to the rapid detection of certain visual features before focused attention is consciously directed to them. These features can help a viewer locate an exception or understand a grouping quickly.

Important pre-attentive attributes include:

AttributeTypical useCaution
PositionComparing values or trendsUse a common, honest scale
LengthComparing quantities in barsStart bars at zero when magnitude is implied
Colour hueCategorising groupsToo many colours reduce meaning
Colour intensityShowing ordered magnitudeEnsure adequate contrast
SizeIndicating relative importanceArea and volume are difficult to compare
ShapeDistinguishing categoriesAvoid excessive symbol variety
OrientationHighlighting direction or trendMay be difficult for dense data
EnclosureGrouping related itemsDo not create excessive boxes
ConnectionShowing relationships or flowCrossing lines create clutter
MotionDrawing attention in interactive mediaUse sparingly and provide alternatives

A common dashboard application is highlighting a key performance indicator that is below target. A neutral grey may be used for normal categories while a single contrasting colour identifies the exception. The colour is effective because it is relatively rare and has a clear semantic meaning.

Pre-attentive attributes should not be used merely for decoration. If every category is brightly coloured, no item is visually prioritised. Similarly, using different shapes, colours, borders, and sizes for the same dimension may overload the viewer.

3. Gestalt Principles of Organisation

Gestalt psychology explains how people tend to organise visual elements into meaningful wholes. These principles are particularly useful when arranging dashboard cards, charts, filters, and annotations.

Proximity

Objects placed close together are perceived as related. A chart title, subtitle, and chart should be closer to one another than to the next chart. In a dashboard, excessive spacing between a heading and its visual weakens the relationship.

Similarity

Elements that share colour, shape, size, or typography are perceived as belonging to the same group. Consistent formatting for all revenue measures, for example, helps users recognise them as a family.

Enclosure

A boundary or background region can group related elements. Enclosure should be subtle; heavy borders around every object produce visual noise.

Continuity

The eye tends to follow aligned or smoothly continuing elements. A line chart uses continuity to communicate movement over time. Misaligned dashboard objects interrupt scanning and make comparison harder.

Closure

People mentally complete incomplete shapes. Minimal visual forms can therefore communicate effectively, but excessive abstraction may require too much inference.

Figure and ground

Readers distinguish a focal object from its background. Strong contrast should be reserved for the figure—the data or message—not for decorative backgrounds.

Common region and connectedness

Elements in the same region, or joined by a line, are interpreted as related. These principles are useful in process diagrams and network views but can mislead if connections imply relationships that do not exist.

4. Visual Hierarchy and Dashboard Layout

Visual hierarchy determines the order in which users notice and interpret elements. A practical hierarchy often follows this sequence:

  1. The dashboard purpose or headline insight.
  2. Key metrics and major exceptions.
  3. Main comparisons and trends.
  4. Explanatory detail and supporting context.
  5. Filters, definitions, and methodological notes.

Hierarchy can be created through position, scale, contrast, whitespace, typography, and colour. It should reflect decision priority, not merely aesthetic preference.

A useful dashboard layout generally places high-level indicators near the top, followed by trends and comparisons, with detailed tables or diagnostic visuals lower down. However, layout should reflect the user’s workflow. A service manager who begins with unresolved cases may need an exception panel before summary metrics.

Whitespace is not wasted space. It separates visual groups and lowers search effort. Alignment is equally important: charts with shared edges and consistent margins are easier to scan than objects placed arbitrarily.

Titles should communicate the analytical message where possible. “Monthly sales” describes a topic, whereas “Sales declined 12% in the final quarter” communicates an insight. The second title should be used only when the statement is supported by the selected data and time period.

5. Cognitive Load and Information Density

Cognitive-load theory distinguishes among three forms of mental effort:

  • Intrinsic load: difficulty inherent in the subject matter or task.
  • Germane load: mental effort devoted to constructing useful understanding.
  • Extraneous load: effort caused by poor presentation or irrelevant complexity.

A dashboard cannot eliminate intrinsic complexity, but it can reduce extraneous load. Examples include removing decorative backgrounds, reducing unnecessary legends, using meaningful labels, and presenting related measures together.

Working memory is limited. A viewer should not be required to remember values from one chart while searching for their counterparts in another. Direct labels, consistent scales, and small multiples can reduce this burden.

Information density must be balanced. Too little information prevents diagnosis; too much produces clutter. A useful design question is: “What decision will this element support?” If the answer is unclear, the element may belong in a detail page rather than the main dashboard.

Interactivity can reduce clutter, but it can also increase cognitive load. A filter hidden behind several menus may make the dashboard difficult to operate. Users should understand what selections are active and how those selections affect the displayed results.

6. Colour Theory and Accessibility

Colour can encode categories, order, intensity, or meaning. These uses should not be confused.

Categorical colour

Categorical palettes distinguish unordered groups, such as product divisions. Colours should be sufficiently different but limited in number. Direct labels are often preferable when there are only a few categories.

Sequential colour

Sequential palettes represent ordered values, such as low-to-high profit. Light-to-dark intensity is commonly used, although the direction should be explained through a legend or label.

Diverging colour

Diverging palettes show values relative to a meaningful midpoint, such as below and above a target. The midpoint should have a substantive interpretation, not merely be the arithmetic centre of the range.

Semantic colour

Some colours carry common meanings: red may indicate risk and green may indicate favourable performance. Such conventions are useful but culturally and organisationally variable. Meaning should be reinforced with text, symbols, or position.

Approximately 8% of men and 0.5% of women of Northern European origin experience some form of colour-vision deficiency, although prevalence varies by population and condition. Designers should not rely on colour alone. Use labels, patterns, position, or shape as additional encodings. Test palettes for contrast and colour-vision accessibility.

Avoid using saturated colours for large areas, because they compete with data marks. Use a restrained neutral base and reserve accent colours for important comparisons or exceptions.

7. Data-Ink and the Removal of Clutter

The data-ink principle, associated with Edward Tufte, argues that graphical elements should support the communication of data. Non-data ink includes decoration that does not improve interpretation, such as unnecessary gradients, three-dimensional effects, ornamental images, heavy borders, and redundant labels.

The principle is not “remove everything except marks.” Gridlines, reference lines, axes, and annotations can be valuable when they help users estimate or interpret values. The appropriate question is whether an element contributes meaning at an acceptable visual cost.

For example, faint horizontal gridlines may help readers compare bar heights. Removing them entirely may make the chart harder to read. Conversely, a 3-D column chart may add perspective and shading without improving quantitative comparison; it should normally be avoided.

A practical cleaning process is:

  1. Identify the analytical question.
  2. Remove elements unrelated to that question.
  3. Reduce competing colours and typography.
  4. Simplify legends through direct labelling where practical.
  5. Check whether scales, units, and definitions remain visible.
  6. Test the result with a user who did not design it.

8. Choosing an Appropriate Chart

Chart selection should follow the analytical task rather than software defaults.

Analytical purposeSuitable chartImportant caution
Compare categoriesBar or column chartSort categories meaningfully; avoid excessive labels
Show trend over timeLine chartUse an appropriate time interval and avoid false continuity
Show part-to-wholeStacked bar, 100% stacked barLimit segments; parts may be hard to compare
Show distributionHistogram, box plotExplain bins and outliers
Show relationshipScatter plotConsider scale, outliers, and aggregation
Show geographic patternMapDo not imply area equals value without justification
Show a single KPICard or bullet chartInclude target, period, and definition
Show flowSankey or process diagramUse only when flow is central to the question
Show detailed valuesTable or matrixAdd conditional formatting carefully

Pie charts are most defensible when there are few categories, the parts form a complete whole, and approximate proportions are sufficient. They are weak for precise comparison because angles and areas are harder to compare than aligned lengths.

Scatter plots are useful for examining association, but association does not establish causation. A trend line may summarise a relationship, but it does not prove that changing one variable will cause the other to change.

Maps should be used when location is analytically important. A map can be misleading when large geographic areas dominate attention despite having small populations. In such cases, a ranked bar chart or normalised rate may be more informative.

9. Avoiding Distortion and Misleading Scales

Truncated axes

For bar charts representing magnitude, the quantitative axis should normally begin at zero because bar length is interpreted from a baseline. A truncated axis can exaggerate differences. Line charts may use a non-zero baseline when the purpose is to show variation within a narrow range, but the scale must be clearly labelled and interpreted cautiously.

Unequal intervals

Time axes must represent time consistently. Equal visual distances should represent equal time intervals unless a deliberate transformation is explicitly identified.

Dual axes

Dual-axis charts can suggest a relationship between variables merely because the designer selected compatible-looking scales. They should be used only when the relationship is meaningful, units are clearly labelled, and the two measures are not being falsely compared.

Area and volume

People generally judge length more accurately than area and volume. Bubbles and 3-D columns can therefore magnify perceived differences. If size is used, explain whether it represents area, radius, or another measure.

Aggregation and denominators

Totals can conceal important differences in population size or exposure. Rates should be used when comparing groups of different sizes. For a rate per k units:

Rate = (Number of events ÷ Population at risk) × k

Here, the number of events and population at risk must refer to the same period and defined population, while k is a scaling constant such as 1,000 or 100,000. Rates should not be compared when their denominators are defined differently.

Missing data

Blank values, zeros, and unavailable values are not equivalent. A dashboard should identify how missing observations are treated. Automatically replacing missing values with zero can create a false decline or falsely improve a total.

10. Applying the Principles in Power BI and Tableau

In Power BI, visual-level, page-level, and report-level filters should be clearly distinguished. Conditional formatting can implement exception highlighting, but colour rules need documented thresholds. Themes can standardise typography and colour across pages. Tooltips can provide definitions and detail without overcrowding the primary view.

In Tableau, shelves and marks determine the visual encoding. The Marks card can control colour, size, shape, label, and detail, but adding fields to multiple visual channels may create unnecessary complexity. Reference lines, annotations, and dashboard actions should support a clear analytical purpose.

In both platforms, designers should:

  • Use consistent number formats and units.
  • Label measures with business-friendly definitions.
  • Display the active filter state.
  • Provide accessible colour alternatives.
  • Test interactions, drill-throughs, and tooltips.
  • Prevent aggregation from producing an invalid interpretation.
  • Document refresh time, data period, and important limitations.

A dashboard should be tested at realistic screen sizes. A design that works on a large monitor may become unreadable on a laptop or mobile display.

11. Applied Case: Improving a Regional Sales Dashboard

Background

The following is an illustrative case. A retail organisation uses a Power BI dashboard to monitor regional sales, profit, returns, and sales targets.

Problem

Managers report that the dashboard is visually impressive but difficult to interpret. It contains a 3-D sales chart, ten bright category colours, a map with bubbles, three gauges, and a line chart with a truncated vertical axis. The dashboard does not show whether sales figures are gross or net of returns.

Analysis

The 3-D chart makes length comparison difficult. The ten colours create no clear visual priority. The map attracts attention to large regions even when their sales are low. The truncated axis exaggerates a small movement in sales. The gauges consume space but provide less comparative precision than bullet charts or labelled KPI cards. Finally, the undefined measure creates a governance risk: different users may interpret “sales” differently.

Approach and solution

The redesign begins with the decision questions: Are regions meeting target? Which regions require intervention? Are returns affecting performance?

The redesigned page uses:

  • Four clearly defined KPI cards for net sales, profit margin, return rate, and target attainment.
  • A sorted horizontal bar chart comparing regional net sales against target.
  • A line chart showing monthly net sales with a clearly labelled axis and target reference line.
  • A restrained sequential palette for performance and one contrasting colour for below-target regions.
  • A small scatter plot comparing sales and profit margin, with region labels and an explanation that association is not causation.
  • A tooltip containing gross sales, returns, net sales, and the refresh date.
  • A visible note defining all measures and the denominator for return rate.

Outcome

Managers can identify below-target regions more quickly and are less likely to confuse gross and net sales. The dashboard uses less decoration while providing stronger context. The redesign does not remove detail; it moves diagnostic information into tooltips and a secondary page.

Learning points

The case demonstrates that visual quality is not equivalent to visual complexity. Good design aligns hierarchy, encoding, definitions, and interaction with the decisions users must make.

12. Ethical and Professional Considerations

Visualization choices influence organisational decisions. A designer may mislead intentionally or unintentionally through selective time periods, omitted categories, inconsistent denominators, hidden filters, or exaggerated scales. Ethical practice requires transparency about data sources, transformations, uncertainty, missing values, and definitions.

Important governance practices include:

  • Preserve an audit trail for calculated measures.
  • Record who owns and approves key performance indicators.
  • Show refresh dates and data coverage.
  • Protect confidential or personally identifiable information.
  • Apply row-level security where required.
  • Avoid exposing sensitive groups through small-cell reporting.
  • Provide accessible alternatives for colour and interaction.
  • Distinguish observed data from forecasts or estimates.

Artificial intelligence can assist with natural-language summaries, anomaly detection, and chart suggestions. However, AI-generated explanations may overlook missing data, confuse correlation with causation, or produce unsupported narratives. Human review remains necessary, especially for high-impact decisions.

13. A Practical Design Review Checklist

Before publishing a dashboard, ask:

  1. What decision or question does each visual support?
  2. Is the most important message noticed first?
  3. Are comparisons based on aligned scales where possible?
  4. Are bar-chart baselines appropriate?
  5. Are colours meaningful, limited, and accessible?
  6. Can the visual be understood without relying on colour alone?
  7. Are units, periods, denominators, and definitions clear?
  8. Are missing values distinguished from zero?
  9. Have unnecessary borders, effects, and labels been removed?
  10. Do filters and interactions reveal their current state?
  11. Does the dashboard remain usable on the intended device?
  12. Has a representative user tested it?

Chapter Summary

Visualisation is a communication system in which data are encoded through visual features and decoded by human users. Pre-attentive attributes such as position, colour, length, and enclosure can direct attention, but excessive encoding creates noise. Gestalt principles explain how proximity, similarity, continuity, enclosure, and figure-ground relationships organise dashboard elements.

Visual hierarchy should reflect decision priority. Cognitive-load theory encourages designers to reduce extraneous effort through alignment, whitespace, direct labelling, consistent scales, and purposeful interaction. Colour should distinguish categories, represent ordered values, or communicate meaningful divergence, while accessibility requires that colour not be the only signal.

Data-ink principles support the removal of decoration without removing useful context. Chart choice must follow the analytical task. Bar charts support comparison, line charts support trends, scatter plots support relationships, and maps are appropriate only when geography is important. Misleading scales, dual axes, inappropriate aggregation, unclear denominators, and unreported missing data can distort interpretation. Professional dashboards combine perceptual clarity with ethical transparency, accessibility, governance, and user testing.

Key Terms

Pre-attentive attribute: A visual feature detected rapidly before focused attention.

Visual encoding: The representation of data values through visual properties.

Gestalt principle: A principle describing how people organise visual elements into meaningful patterns.

Proximity: The tendency to perceive nearby elements as related.

Similarity: The tendency to group elements sharing visual characteristics.

Enclosure: Grouping created by a boundary or common region.

Visual hierarchy: The order in which visual elements attract attention.

Cognitive load: Mental effort required to understand or use information.

Extraneous load: Effort caused by unnecessary complexity or poor presentation.

Data-ink: Visual content directly used to represent or explain data.

Chart junk: Decorative or redundant visual elements that do not support interpretation.

Categorical palette: Colours used to distinguish unordered groups.

Sequential palette: Colours representing an ordered low-to-high scale.

Diverging palette: Colours representing values on either side of a meaningful midpoint.

Truncated axis: An axis that begins above zero and may exaggerate differences.

Dual-axis chart: A chart using two quantitative axes, often with different units.

Denominator: The reference population or quantity used when calculating a rate.

Small multiples: A set of similarly designed charts used for structured comparison.

Dashboard: A visual interface combining indicators and analyses for monitoring or decision-making.

Review Questions

Short Answer Questions

  1. What is a pre-attentive attribute, and why is it useful in dashboard design?
  2. Explain the Gestalt principle of proximity with a dashboard example.
  3. Distinguish between categorical, sequential, and diverging colour palettes.
  4. Why can a truncated axis mislead viewers of a bar chart?
  5. What is the purpose of data-ink principles?

Long Answer Questions

  1. Explain how visual hierarchy and cognitive-load theory should influence the layout of a business dashboard.
  2. Compare bar charts, line charts, scatter plots, maps, and pie charts in terms of their appropriate analytical uses.
  3. Discuss how colour can improve or weaken a visualization, including accessibility considerations.
  4. Explain how Gestalt principles can be applied to organise a multi-page Power BI or Tableau report.
  5. Discuss the ethical responsibilities of a dashboard designer when presenting performance data.

Analytical / Application Questions

  1. A dashboard uses twelve colours, 3-D columns, a dark textured background, and a truncated y-axis. Identify the perceptual and ethical problems and propose a redesign.
  2. A hospital compares 40 emergency visits in a clinic serving 500 people with 60 visits in a clinic serving 2,000 people. Explain why totals may be inappropriate and describe a suitable rate comparison, including the necessary denominator checks.
  3. Design a dashboard for a regional sales manager. Specify the decision questions, chart types, visual hierarchy, colour strategy, definitions, and accessibility or governance controls you would include.

Multiple Choice Questions with Answers

Question 1

Which visual encoding generally supports the most accurate comparison of quantities?

A. Position on a common scale

B. Three-dimensional volume

C. Pie-slice angle

D. Decorative texture

Correct Answer: A. Position on a common scale

Question 2

Which Gestalt principle suggests that nearby dashboard elements are perceived as related?

A. Closure

B. Proximity

C. Continuity

D. Figure-ground

Correct Answer: B. Proximity

Question 3

Which palette is most appropriate for showing values below and above a meaningful target?

A. Categorical

B. Sequential

C. Diverging

D. Monochromatic decorative

Correct Answer: C. Diverging

Question 4

Why should colour not be the only way to communicate a difference?

A. Colour always increases cognitive load

B. Some users have colour-vision deficiencies

C. Colour cannot represent categories

D. Colour is unavailable in BI software

Correct Answer: B. Some users have colour-vision deficiencies

Question 5

Which chart is generally most suitable for comparing sales across regions?

A. Sorted bar chart

B. 3-D pie chart

C. Decorative bubble chart

D. Unlabelled map

Correct Answer: A. Sorted bar chart

Question 6

What is a major risk of truncating the baseline of a bar chart?

A. It prevents all trend analysis

B. It can exaggerate apparent differences

C. It removes the need for labels

D. It guarantees accurate comparison

Correct Answer: B. It can exaggerate apparent differences

Question 7

In the rate formula Rate = (Number of events ÷ Population at risk) × k, what does the denominator represent?

A. The chart width

B. The scaling constant

C. The population at risk

D. The number of categories

Correct Answer: C. The population at risk

Question 8

Which visual is most appropriate for examining the relationship between advertising expenditure and sales?

A. Scatter plot

B. Pie chart

C. Single KPI card

D. 100% stacked bar only

Correct Answer: A. Scatter plot

Question 9

What is an example of extraneous cognitive load?

A. Understanding a complex business definition

B. Comparing two clearly labelled trends

C. Interpreting a required calculation

D. Searching through unnecessary decorative elements

Correct Answer: D. Searching through unnecessary decorative elements

Question 10

Which practice improves dashboard governance?

A. Hiding all filter selections

B. Removing measure definitions

C. Showing refresh dates and data definitions

D. Replacing missing values with zero automatically

Correct Answer: C. Showing refresh dates and data definitions

Data Visualization & BI using Power BI & Tableau
Chapter 3 of 14