Actions and Detail Panel
Storytelling with Data: Data Visualization in Excel
Thu, 8 June 2017, 9:00 AM – 4:00 PM MDT
We are bombarded with data - scatterplots of the most overrated films; stacked bar charts with Trump’s most frequent words; line charts showing the high and lows of the stock market.
We humans love our data, and when we show that data effectively it can make a huge difference in how it is understood - in other words, telling the story we want to tell.
In this 1-day workshop we will explore what effective data visualization is by learning about:
The science of human perception. Did you know that we did not just arbitrarily choose to villainize pie charts? There is actual science behind why this graph is usually not the best graph for understanding your data.
How to move from showing to telling. In other words, figure out what story you are trying to tell with your data and then pick the chart that tells that story best (yes, there are more options than the boring old column chart we were taught to make back in the day).
Design. Just as there is science behind how we perceive things, there are design principals that can enhance understanding of our data. You’ll reduce clutter, use font and colour to highlight important information, and add text where it belongs – not where Excel tells you it should go.
And of course, we have built in lots of time for you to bring out your inner data nerd and practice working in Excel. You’ll enhance your line charts, make bar and column charts that stand out, and experiment with dot plots and diverging stacked bar charts.
Topics we will cover
- Overview of how humans perceive and process information
- Stories we tell with data
- Overview of chart types and which to choose for your story, including charts you’ve probably never even heard of (e.g. dot plots, slopegraphs, tree maps, lollipop graphs)
- Choosing colour and font wisely
- Free colour and font resources to use
- How to format your graphs in Excel using design principals
- Considerations for employing these learnings in your practice
People from all backgrounds, sectors and types of roles should attend. Of most importance it that you are open to changing the way you present data. We will be using Excel so you should have a laptop with Excel on it and have basic Excel skills (e.g. enter and arrange data on a spreadsheet and insert charts)
Kristy Madsen and Shelby Corley of Three Hive Consulting will be your guides as you explore your new role as a data designer. They have both undertaken the journey from bad design to good design, and are experienced in delivering information products that get stakeholders interested.
Lunch and coffee are included in registration.
Parking is available at Lister for a fee, and transit opportunities abound.
Questions? You can find us at firstname.lastname@example.org.