Data Storytelling

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

NEED A PROPOSAL FOR COMPANY?
EMAIL [email protected]

Data Storytelling and Visualization

This training aims to use MS Excel to convey story from data. This module focuses on different ways to present data to achieve a certain purpose and to be appreciated by your audience.

I. Introduction to Communicating with Data
• Understanding the Language of Data
• Stages to Data Storytelling
• Data Visualization vs Data Storytelling

II. Preparing to Tell Your Data Story
• Creating Your 3-Minute Story
• Identifying the Main Idea of Your Story
• Preparing the Story Stream / Storyboard
• Adapting Your Presentation to Your Audience (Clients vs Managers vs Colleagues)

II. Choosing the Right Visual to Convey Meaning (and Guidelines to Using Charts + How to Perform them in Excel)
• The Three Main Charts: Column/Bar, Line, and Pie Charts
• Showing Relationships with Scatter Charts
• Showing Intersecting Aspects with Stacked Bars
• Showing Geographical Information with Map Charts
• Showing Hierarchy with Tree Maps and Sunburst Chart
• Preparing a Dashboard

III. Applying Psychological Principles in Data Storytelling
• Tufte’s Data-Ink Ratio: Measuring and Removing Clutter in Your Visuals
• Gestalt’s Principle: Controlling How Viewers See Your Message
• Principle of Good Order and Symmetry
• Principle of Similarity and Continuation
• Principle of Proximity and Closure
• Applying Pre-Attentive Attributes in Visuals
• Using Light-Dark Color Shading
• Using Attribute of Size and Contrast
• Using Attribute of Orientation

IV. Thinking Like a Designer
• Applying Aesthetics to Visuals
• Good vs Bad Visuals
• Laying Out Elements

V. Applying Context to Visuals
• Adding Context via Legends, Chart and Axis Titles
• Adding Annotations
• Adding Subtitles and Paragraph Texts

VI. Ethics and Deception in Data Storytelling
• Ethics in Data Storytelling
• Avoiding Data Deception
• Cherry Picking
• Data Hacking

VII. Preparing Your Dashboard
• Laying Out Your Dashboard Elements
• Adding Objectives, Story Stream, and Dashboard Certainty