Data Storytelling with Microsoft Excel

Data Storytelling course teaches participants how to effectively find and communicate insights in data, with a focus on context, design, communication, and automation.

Click Here For More Information

All students will learn to:

  • Understand the difference between exploratory and explanatory analysis
  • Distinguish between data visualization and data storytelling
  • Learn the data storytelling process
  • Ask the right questions to impact business decisions
  • Choose the appropriate story type for the data story
  • Construct the data story
  • Identify common pitfalls of data analysis and visualization

Course Outline

Part 1: Set Up/Context

  • Understanding the difference between data visualization and data storytelling
  • The data storytelling process overview
    • Question/problem statement/ obtain context
    • Analysis
      • Exploratory to get to Explanatory
    • Select your data story type
    • Sketch
    • Communicate
      • Which storybook (the different ways to communicate your data story) should you use

Part 2: Analysis

  • Exploratory Analysis
  • 5 Types of Analysis

Part 3: Select Your Data Story

  • Seven types of data stories
  • Using secondary characters:

Part 4: Sketch

  • How will this be visually represented?
  • Sketch it out considering:
    • Purpose
    • Audience
    • Rising Action
    • Climax/Peak
    • Conclusion/Ending

Part 5: Communicate

Communicating through story “books”

  • Dashboard
  • Slide deck/Story Points
  • Written/oral report
Course Information
  • Course Level:Intermediate
  • Prerequisite:All students should have prior experience working with corporate reporting.
  • Credit:16 hours
  • Fee:595
  • Length:2 days
  • Date:Varies
  • Hours:8:30 a.m. - 4:30 p.m., or 4 1/2 days - flexible
  • Delivery:On-site or Virtual

Related Courses