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 |
Related CoursesBasic MS Excel
MS PowerBI for Beginners Advanced MS Excel Macros and VBA Programming Excel for Data Analytics |