Data Visualisation for Business Training Course

Participants can match data structures and analytical tasks to suitable visual forms.

• Nominal, ordinal, interval and ratio scales distinguished for visual encoding
• Comparison, distribution, composition, relationship and ranking tasks classified accurately
• Time-series questions separated from cross-sectional and cumulative reporting questions
• Grain, aggregation and denominator choices tested before chart construction
• Measures, dimensions and hierarchies mapped to a reporting data model
• Outliers, missing values and suppressed values assessed before visual publication

Participants can use perceptual principles to make important patterns easier to detect.

• Cleveland-McGill ranking applied to position, length, angle, area and colour
• Preattentive attributes used for selective attention, grouping and exception signalling
• Gestalt principles applied to proximity, similarity, enclosure and visual continuity
• Data-ink ratio improved by removing nonessential borders, fills and decoration
• Visual hierarchy established through position, size, contrast and whitespace
• Dual encoding combines labels and marks without creating redundant clutter

Participants can select and justify chart types for common management reporting questions.

• Bar charts used for ranked categorical comparisons and target gaps
• Line charts designed for trends, seasonality, forecast and intervention effects
• Dot plots replace crowded bars when labels and rankings dominate
• Scatter plots reveal correlation, clusters, quadrants and influential observations
• Waterfall charts explain budget, revenue and headcount movement drivers
• Small multiples compare repeated patterns without overloaded multi-series charts

Participants can prepare reliable reporting data for charting and dashboard use.

• Source fields profiled for completeness, uniqueness, validity and consistency
• Tidy data principles applied to rows, variables and observational units
• Power Query transformations standardise dates, categories, text and null values
• Calculated fields separate business logic from display formatting decisions
• Star schema relationships defined between fact tables and shared dimensions
• Data lineage recorded from source extract through published dashboard measure

Participants can construct a focused dashboard from a defined business reporting brief.

• Dashboard wireframes allocate space according to decision priority and reading sequence
• Executive landing pages combine headline KPIs, trends, exceptions and drivers
• Slicers and filters limited to meaningful user choices and analytical paths
• Tooltips provide supporting detail without overcrowding primary chart views
• Consistent titles state the finding, period, population and comparison basis
• First dashboard build uses prepared data and selected chart patterns

Participants can create a consistent visual language for business dashboards and reports.

• Categorical, sequential and diverging palettes matched to data meaning
• Colour reserved for status, comparison, grouping and deliberate emphasis
• Colour-blind-safe palettes tested against common vision deficiency patterns
• Typography hierarchy distinguishes page titles, chart titles, labels and notes
• Grid layouts align visual components and protect whitespace between analytical sections
• Design tokens document approved colours, fonts, spacing and annotation styles

Participants can visualise performance over time while preserving meaningful comparisons.

• Period-over-period change calculated for monthly, quarterly and annual reporting
• Rolling averages reduce noise while preserving trend direction and turning points
• Seasonality separated from underlying growth using comparable prior-period measures
• Control charts distinguish common-cause variation from special-cause signals
• Targets, forecasts and confidence ranges displayed without misleading precision
• Indexed series compare relative movement across measures with different scales

Participants can visualise financial and operational variances for management action.

• Actual, budget and forecast variances calculated with consistent denominator conventions
• Bridge analysis decomposes margin movement into price, volume, mix and cost
• Variance annotations identify material drivers, owners, actions and expected recovery
• Service-level dashboards compare performance against thresholds, commitments and historical baselines
• Exception reports rank locations, products or teams by business materiality
• Run charts expose process drift, recurring peaks and persistent underperformance

Participants can reveal patterns in relationships, distributions and business segments.

• Histograms show distribution shape, spread, skewness and possible data quality issues
• Box plots compare medians, quartiles, spread and outliers between groups
• Scatterplot quadrants segment accounts, branches or products by two measures
• Reference lines establish targets, averages, percentiles and decision thresholds
• Bubble charts used cautiously when third-variable magnitude adds analytical value
• Segmentation views combine filters, ranking and drill-through for focused investigation

Participants can create transparent measures that support reliable visual analysis.

• DAX measures distinguish filter context, row context and aggregation behaviour
• Tableau level-of-detail expressions fix calculation grain for comparison metrics
• Time intelligence calculates year-to-date, rolling-period and prior-period measures
• Ratios protect interpretation through numerator, denominator and exclusion documentation
• Conditional formatting rules reflect approved thresholds rather than arbitrary colours
• Measure dictionaries record definitions, owners, refresh logic and caveats

Participants can design interactions that support investigation without confusing users.

• Overview-to-detail structure guides users from summary signals to underlying records
• Drill-down paths follow agreed business hierarchies and reporting accountability
• Cross-filtering tested for predictable behaviour across linked visuals
• Bookmarks and parameters support alternative views without duplicating dashboard pages
• Default states show essential findings before any user interaction occurs
• Interaction instructions written where controls are not self-evident

Participants can use geographic visualisations appropriately for location-based decisions.

• Geographic questions tested before choosing maps over ranked comparison charts
• Choropleth maps normalise counts using population, customers or exposure
• Proportional symbols show magnitude when location precision matters materially
• Geocoding quality checked for unmatched places, duplicates and ambiguous boundaries
• Map classifications compared using equal interval, quantile and natural breaks
• Location privacy assessed before publishing customer, employee or incident data

Participants can present a persuasive evidence-based narrative from business data.

• Situation-complication-question-answer structure frames analytical presentations for senior audiences
• Message titles state the conclusion rather than merely naming the chart
• Annotations connect visible evidence to operational causes and decision implications
• Story arcs sequence context, finding, consequence, recommendation and requested action
• Counterarguments anticipated through assumptions, limitations and alternative explanations
• Executive briefings distinguish observed facts from forecasts and management judgement

Participants can review visualisations for accessibility and inclusive use.

• WCAG 2.2 contrast requirements checked for text, marks and interactive controls
• Colour-independent cues use labels, shapes, patterns and direct annotations
• Alt text describes chart purpose, key findings and material comparisons
• Keyboard access considered for filters, tabs, tooltips and dashboard navigation
• Plain-language labels reduce ambiguity in metrics, dates and business terminology
• Accessible exports preserve readable tables for users requiring alternative formats

Participants can test dashboards for analytical accuracy, usability and publication readiness.

• Reconciliation checks compare dashboard totals with approved source reports
• Boundary testing validates filters, date ranges, nulls and empty selections
• Visual integrity review checks scales, sorting, baselines and truncated axes
• Usability testing observes whether users locate findings and complete tasks
• Peer critique uses a structured rubric for purpose, clarity and actionability
• Publication checklists confirm ownership, refresh status, caveats and version control

Participants can plan governed dashboard publication with appropriate performance controls.

• Import, DirectQuery and live connection modes compared for reporting requirements
• Data model size reduced through column removal, aggregation and efficient data types
• Refresh schedules aligned with source availability, decision cadence and control requirements
• Row-level security maps dashboard access to approved user groups
• Certified datasets distinguish governed measures from local analytical extracts
• Dashboard ownership assigns stewardship, change approval and retirement responsibilities

Participants can diagnose weak visualisations and redesign them against defined criteria.

• Chart critique separates data errors, design defects and unsupported conclusions
• Misleading axes, areas and dual scales identified using visual integrity checks
• Before-and-after redesigns document changed choices and resulting decision value
• Cognitive load reduced by removing competing messages and unnecessary interaction
• Stakeholder feedback translated into prioritised design changes rather than feature accumulation
• Review sessions test whether visual emphasis matches business materiality

Participants can plan a controlled transition from course prototype to workplace dashboard.

• Use cases prioritised by decision value, data readiness and sponsor commitment
• Stakeholder maps identify report consumers, data owners and approval authorities
• Dashboard backlogs sequence minimum viable views, enhancements and dependencies
• Acceptance criteria define data accuracy, usability, accessibility and refresh expectations
• Implementation risks assessed for source instability, scope growth and access constraints
• Build reviews consolidate peer feedback into an evidence-based improvement plan

Participants can build, review and present a complete decision-ready dashboard with documented design rationale.

• Capstone brief defines audience, decision, metrics, thresholds and reporting cadence
• Prepared business dataset supports calculations, filters, comparisons and exception analysis
• Dashboard build applies chart selection, visual hierarchy and interaction principles
• Quality review verifies data reconciliation, accessibility, usability and visual integrity
• Presentation narrative communicates findings, implications, recommendation and requested decision
• Peer panel review records strengths, risks, revisions and publication conditions