STORYTELLING USING DATA

Storytelling using Data participants across Mumbai, Kolkata, Bangalore, New Delhi, Gurgaon, Chennai, Hyderabad, Pune, Nasik, Ahmedabad, etc.

Storytelling using data involves using data, visualizations, and other forms of data representation to communicate a message or tell a story. It is a way of using data to engage an audience and communicate insights in a clear and compelling way.

However, storytelling using data is a powerful way to communicate insights and engage an audience with data. By carefully selecting the right data, visualizations, and narrative, you can effectively tell a compelling story using data.

With the aim of equipping with this Ninja-level power. We have developed a 1-day workshop, which has been conducted at prestigious companies, including PwC, EY, ITC, Coca-Cola, Flipkart, Asian Paints, etc.

Storytelling using Data | Course Outline

Program Name: Storytelling using Data
Software: Microsoft PowerPoint
Level: Intermediate to Advanced (L2 and L3)
Duration: 6.5 effective hrs.

Learning Material: Datasets-based case studies, PDF and YouTube videos from our channel for revision

Delivery Style:

  • Hands-on practice (Demo -> Practice side-by-side).
  • First, show a demo with the problem statement and solution.
  • Then, slow down the pace to let people practice along with the Instructor.

Objectives:

This program focuses on helping users to:

  1. Choose the right charts and use them to present data (80%)
  2. Use shortcuts to execute ideas & visualisation (10%)
  3. Use company’s guidelines of using Charts, Titles and basics Hygiene factors (5-10%)

A: Use Google to find sector-wise trends on latest industry charts | 10 mins.

→ Learning Objectives: Get context- specific (sector, business, KPI) ideas on Charts:

  1. How to use Google’s Advanced Search tags to see the latest industry trends on charts

B: Essential chart elements & settings | 60 mins.

→ Learning Objectives: Customise the chart settings and options to make it client-ready.

Anatomy of a Chart:

  1. Chart Title (metric name) vs Slide Title (inference)
  2. Writing a title for figures
  3. Writing a title for a slide (also called strapline)
  4. Vertical vs Horizontal Axis, Axis Titles, Data Labels, Gridlines, Legends; Fill & Outline
  5. Source & Footnotes

Exercise: Get to know all the essential Chart settings:

  1. Sort the data set for easy comparison (Desc / Asc Order)
  2. Create a ‘Column Chart’
  3. Change Chart Type – Horizontal ‘Bar Chart’
  4. Column Chart vs Bar Chart – Why?*
  5. Format Axis – Categories in Reverse Order
  6. Format Data Series – Reduce Gap Width & Best Practice
  7. Add Data Label (numbers) – 3 ways
  8. Data Label – Inside Base vs Outside End
  9. Change color of all or one the series
  10. Add a thin border, dashed line to one of the series
  11. Convert Y-axis ‘jump’ values = 0, 50, 100 …. 200
  12. Remove Gridlines & add Primary Major Horizontal Gridlines

C: Essential Charts - 1 | 100 mins.

→ Learning Objectives: Focus on business charts that are commonly used in Consulting.

  1. Basics of 2 axis Charts – Primary Axis (Column) & Secondary Axis (Line)
  2. Thermometer Chart & its use cases
  3. Automatic color of negative data series (column)
  4. Waterfall Chart – 1
  5. De-mystifying the ‘Select Data’ option
  6. Stacked Column
  7. 100% Stacked Horizontal
  8. Re-basing / Indexing data to a base of 100 for comparing time-trends (Line)

D: Concept of Parallel Chart or Side-by-Side Chart | 45 mins.

→ Learning Objectives: Focus on how to present multiple data points without adding clutter.

  1. Three Types using industry examples – EY, McKinsey
  2. Exercise – Create a parallel chart incl PowerPoint shortcuts & Data handling tricks

E: Alternatives to Pie Chart | 45 mins.

→ Learning Objectives: Explore better alternatives to Pie Chart.

  1. Each pie chart should have 100% = “metric being shown” on the top right hand corner
  2. Horizontal Bar
  3. Treemap
  4. Waterfall Chart – 2
  5. Donut

F: 7 Storytelling Strategies | 60 mins.

→ Learning Objectives: Learn from best industry practices & consulting reports (updated Aug’2022)

  1. 7 strategies to add impact to text / table heavy slide
  2. Symbols (Webdings, Wingdings) – criticality, % completion, tick, legends for lengthy names
  3. Highlighter (dashed outline)
  4. De-Highlighter (white tracing paper) – semi-transparent white shape
  5. De-Highlighter – greyed out text
  6. Clustering using curly braces shape (75%:25%)
  7. Number Pointers for Navigation & Flow of reading
  8. Callouts
  9. Essential – PowerPoint Shortcuts to create new visuals
  10. Exercises – Overlapping circles, Waffle Visual

G: Quick Theory - Hygiene Factors to present Table | 30 mins.

→ Learning Objectives: Overview of presenting tabular-data better.

  1. How to format tables (text alignment, borders, shading, distribute rows/columns)
  2. Every table needs to have serial numbers on the left
  3. Every table needs to have a row for totals
    Tables /Charts need to be sorted on the basis of relevant logic (alphabetic order is not a logic) + How to Sort
  4. Every table/chart/figure in a slide must have a title, left aligned, which captures:
    – Name of metric being monitored and analysis being shown
    – Time validity of data
    – Absolutely no inference statement in the Table title (the slide title needs to capture that or these need to highlighted in a callout)
  5. Source needs to be mentioned in each slide
  6. Each number mentioned must have a unit
  7. No acronyms without reference at the bottom (like Legends)

FAQs:

The purpose of corporate storytelling using data training is to help professionals develop the skills and knowledge they need to effectively communicate data insights and engage an audience with data.

Corporate storytelling using data training is typically attended by a variety of professionals, including business analysts, data analysts, data scientists, and other professionals who are responsible for presenting data insights to colleagues, clients, or other stakeholders within their organization.

Corporate storytelling using data training can help professionals develop the skills and knowledge they need to effectively communicate data insights and engage an audience with data, which can lead to a range of benefits for both individuals and organizations.

It’s important to create a supportive environment that encourages your employees to continue learning and practicing their data storytelling skills after the training has ended. This can help them retain the skills they learned and continue to improve their ability to effectively communicate data insights.

There are no specific prerequisites to learn storytelling using data, but having some basic knowledge and skills in such areas can be helpful: Data analysis, Presentation skills, Visual design & Data literacy.

WHAT STUDENT SAYS

Pre-Training Prep Course Testimonials

Kapila Basnayake
Causeway Paints
Read More
It is highly appreciating the way he teaches us. We are a much more comfortable zone to understand since we are in the beginning.
Prasoon Mehra
EY
Read More
The video and modules illustrated were good with the proper shortcuts mentioned. a great training prep.
Sanyam Kalra
PwC
Read More
This Excel Speed Training was really helpful and informative. Shortcuts were really good to know. Flash Fill. Vlookup and Pivot Table as well. Helped me get to the next level. A big thanks to PwC and Yoda Learning Team for introducing me to this course.
Harsh Bhati
PwC
Read More
It's short, and concise yet pretty informative, your way of describing things and the edits mentioning the shortcuts on the screen helped me with the learning.
Vishal Sharma
PwC
Read More
The way these sessions are planned is way more helpful than physical training in the classroom. These are very much helpful.
Chandni Lakdawala
PwC
Read More
Now I can easily and efficiently use excel. Also really good and quick coverage Of the topics.
Mohit Kumar
EY
Read More
Pre-Training preparation is very crisp and really useful to refresh the formulas for advanced training.
Ankit Singh
EY
Read More
All the concepts were explained very clearly and were easy to understand. The information conveyed was relevant and is really going to be handy.
Kavya Gupta
PwC
Read More
All the topics were relevant and can be used in day-to-day projects. Very insightful and informative topics were covered.

WHAT STUDENT SAYS

Post-Training Testimonials

Kaustubh Raul
EY
Read More
It was a superb and 2 ways session. The trainer made it so comfortable and easy for everyone though for almost everyone this is was the very first time to be working on Power BI.
Anushree krishania
EY
Read More
It was excellent!! Very very worthwhile to attend it. Thank you so much, and I hope to have more sessions.
Pushkar Thakur
PwC
Read More
Just excellent. Such detailed explanation and patience, Sir, has no word other than 'excellent.' When training can be tedious, Sir has made the session interactive and not just for the namesake; because it's so exciting and accurate to its name Sir has done justice to the 'advanced excel training.' Kudos!!
Chetan Nagaraju
Razorpay
Read More
The presenter was able to explain all aspects clearly. He was patient and was able to answer all Qs.
Chirag Jain
ITC
Read More
The session was great, and the way the trainer told things was convenient and easy to understand.
Diganta Kakati
T&A Consulting
Read More
So far, I have enjoyed the session. It was very informative and exciting. I like the pace that the trainer conducts the session. Looking forward to learning more new and exciting stuff.