LOOKING FOR RATES AND SCHEDULES TO JOIN A PUBLIC CLASS?
CLICK HERE.

NEED A PROPOSAL FOR COMPANY? 
​EMAIL [email protected]

Data Storytelling: Inspiring Change with Dashboards

This training program focuses on transforming data into compelling stories that drive understanding, alignment, and action. Using Microsoft Excel as the primary tool, participants learn how to move beyond charts and numbers and instead communicate meaning—by structuring insights, choosing visuals intentionally, and presenting dashboards that resonate with specific audiences. The course emphasizes clarity, psychology, and ethics to ensure data stories are not only engaging but also accurate and trustworthy.

By the end of this course, participants will be able to:

• Understand the difference between presenting data and telling a data-driven story
• Structure insights into a clear narrative with a defined purpose and audience
• Select and design visuals that reinforce meaning rather than distract from it
• Apply psychological and design principles to improve comprehension and recall
• Add context and narrative elements to dashboards for stronger decision support
• Build dashboards that communicate confidence while avoiding misleading practices

Who This Course Is For

• Professionals who present data to management, clients, or stakeholders
• Analysts and staff responsible for dashboards and reports
• Managers who need to communicate insights, not just numbers
• Excel users who want their dashboards to influence decisions and behavior

Methodologies

• Guided walkthroughs and hands-on exercises using realistic datasets to build story-driven visuals and dashboards in Excel.
• Critique and refinement sessions where participants evaluate dashboards for clarity, narrative strength, and ethical presentation.

Outline

I. Introduction to Communicating with Data

• Understanding the language of data and how audiences interpret numbers
• Stages of data storytelling from raw data to insight and action
• Differentiating data visualization from data storytelling

II. Preparing to Tell Your Data Story

• Creating a focused 3-minute data story
• Identifying the single main idea your data needs to communicate
• Preparing the story stream or storyboard
• Adapting the story for different audiences (clients, managers, colleagues)

III. Choosing the Right Visual to Convey Meaning

• (Including chart guidelines and Excel execution)
• Using the three core charts: Column/Bar, Line, and Pie
• Translating story intent into dashboard-ready visuals

IV. Applying Psychological Principles in Data Storytelling

• Applying Tufte’s data-ink ratio to remove clutter and noise
• Using Gestalt principles to control visual perception:
  • Good order and symmetry
  • Similarity and continuation
  • Proximity and closure
• Applying pre-attentive attributes to guide attention
  • Using light–dark shading effectively
  • Applying size, contrast, and orientation to emphasize meaning

V. Thinking Like a Designer

• Applying basic design aesthetics to data visuals
• Identifying good vs. poor visual design
• Laying out visual elements for balance and flow

VI. Applying Context to Visuals

• Adding clarity through legends, chart titles, and axis labels
• Using annotations to highlight insights
• Adding subtitles and short explanatory texts to support interpretation

VII. Ethics and Deception in Data Storytelling

• Understanding ethical responsibilities in data communication
• Avoiding deceptive practices in visuals
• Recognizing and preventing cherry-picking
• Understanding data hacking and its consequences

VIII. Preparing Your Dashboard

• Structuring and laying out dashboard components
• Adding objectives, story stream, and indicators of dashboard certainty

Related Courses

Data Visualization: Charting Like a Pro

Basic MS Excel

MS PowerBI for Beginners

Advanced MS Excel

Macros and VBA Programming

​Excel for Data Analytics

Download Outline

Find Public Class

Send Email