People like pictures 3 30x MORE LIKELY High quality infographics are 30 times more likely to be read than text articles 9900% The use of visualized information on the internet has increased by 9900% since 2007
Agenda A bit about me What is data visualization? Why is it important? Let’s take a look Using PowerPoint to visualize data Q&A You try! 4
Katie Grasmeyer Patient Safety & Quality Improvement Coordinator RAPP Grad Marketing Research to Social Research Weekends outside with my dog 5
What is data visualization? Data visualization is representing data in a visual context, like a chart, map or graphic to help people understand the significance of that data. 6 It enables decision makers to see analytics presented visually, so they can grasp difficult concepts or identify new patterns. Source: www.sas.com
Why is data visualization important? 7 Because of the way the human brain processes information, using charts or graphs to visualize large amounts of complex data is easier than poring over spreadsheets or reports. Source: www.sas.com
Enhancing Information with Visuals 8
Scenario 9 You work in the analytics department for a large Travel & Tourism company based out of Toronto. The project team is working on a campaign to target vacationing families with the hopes of increasing visitors to the Toronto Islands following a slow season due to island flooding the previous year. Crucial to the marketing campaign, is showcasing available accommodations across the city. The team has come to you asking for ‘the lay of the land’ in terms of what is available through Airbnb. Lucky for you, Airbnb has a large, public data set available.
Accommodation Types 10 Airbnb Data
Accommodation Types 11 Type of Accommodation % of Market Entire home/apt 64% Private room 34% Shared room 2%
Neighborhoods 13 Neighbourhood # of Accommodations Waterfront Communities-The Island (77) 2268 Niagara (82) 636 Church-Yonge Corridor (75) 543 Annex (95) 498 Bay Street Corridor (76) 422 Dovercourt -Wallace Emerson-Junction (93) 419 Little Portugal (84) 413 Trinity-Bellwoods (81) 390 Kensington-Chinatown (78) 378 Palmerston-Little Italy (80) 322 Willowdale East (51) 309 South Riverdale (70) 301 Moss Park (73) 298 South Parkdale (85) 273 Mimico (includes Humber Bay Shores) (17) 195 Mount Pleasant West (104) 178 Roncesvalles (86) 173 Cabbagetown-South St.James Town (71) 170 The Beaches (63) 161 Dufferin Grove (83) 160 High Park-Swansea (87) 138 High Park North (88) 134 North St.James Town (74) 133 University (79) 129 Oakwood Village (107) 117 East End-Danforth (62) 101 *See appendix for complete list Number of Airbnb Accommodations per Neighbourhood
Neighborhoods 14 Number of Airbnb Accommodations per Neighbourhood 452 543 161 117 2268 390 636 423 101 161 161 195 195 195 237
Neighborhoods 15 Average Cost of Airbnb Accommodations per Neighbourhood
Accommodation Type by Neighbourhood 16
Accommodation Type by Neighbourhood 17 Remove gridlines and in-graph title Add data labels and remove Y axis
Accommodation Type by Neighbourhood 18 Average Overall Satisfaction per Neighbourhood Waterfront Communities Niagara Church-Yonge Lowest Avg. Cost per night ($127)
When you have to use a table 19 Neighbourhood # of Accommodations % Entire Home/ Apt. Waterfront Communities-The Island (77) 2268 20% Niagara (82) 636 27% Church-Yonge Corridor (75) 543 88% Annex (95) 498 72% Bay Street Corridor (76) 422 46% Dovercourt -Wallace Emerson-Junction (93) 419 55% Little Portugal (84) 413 72% Trinity-Bellwoods (81) 390 46% Kensington-Chinatown (78) 378 26% Palmerston-Little Italy (80) 322 80% Willowdale East (51) 309 17% South Riverdale (70) 301 54%
Made in PowerPoint 20 7% 42% No items Only a few items 24% Half full/some items 1% Full/lots of items Shopping Cart/Basket Contents 45 min 40 min 35 min 33% Yes 67% No 22% Go up & down every aisle How do you shop the store?
Using PowerPoint to Visualize Data 21
Adding Icons & Images 22 Images search returns the best results Adding the word ‘icon’ after your search word will give you a better shot at finding the images best suited to a presentation For example… www.iconfinder.com
Choosing Icons 23 House Icon
Choosing Icons with Similar Look & Feel 24 You can make most icons match your presentation by formatting the colour of the icon to match your theme For example… BEFORE AFTER
Changing the Colour of Icons 25
Visualizing Simple Data 26 Estimate how long it takes to complete your year end performance evaluation 40 min Year end performance review documentation 40 minutes on average On average, staff estimate it takes 40 minutes to complete their year end performance review evaluation to complete their year end performance review evaluation minutes Staff estimate it takes 40
Do it in PowerPoint 27 40 min Year end performance review documentation 40 minutes on average 40 min
Do it in PowerPoint 28 50% of Males 80% of Females Find your icon Re- colour to the ‘base’ colour Copy and paste icon so you have 2 sets Re- colour the ‘top’ colour Crop coloured icons to fit %
Using PowerPoint Features - Shapes 29 Instead of bullet points, use shapes and icons to separate pieces of information
Using PowerPoint Features – Shapes 30 Instead of bullet points, use shapes and icons to separate pieces of information
Using PowerPoint Features - Shapes 31 Instead of bullet points, use shapes and icons to separate pieces of information For example…
Using PowerPoint Features - Shapes 32
Using PowerPoint Features - Shapes 33 Strategic System Level Scorecard
Using PowerPoint Features - Shapes 34 21% Over 16 years 21% 6-10 years 16% 11-15 years 38% 2-5 years 4% Hired post-transition Length of Employment with Organization 21% Over 16 years 21% 6-10 years 16% 11-15 years 38% 2-5 years 4% Hired post-transition Insert line Format width, colour and endcap of line Insert circle, copy as needed and format colour Insert speech bubble, copy as needed and format colour Slap on some text boxes Throw an icon in!
Using PowerPoint Features - Arrange 35 Line up objects Align objects in the center of slide Distribute objects evenly Keep all objects together Make the objects work for you
Aligning & Distributing Objects 36 21% Over 16 years 21% 6-10 years 16% 11-15 years 38% 2-5 years 4% Hired post-transition
Aligning & Distributing Objects 37
Grouping Objects 38 21% Over 16 years 21% 6-10 years 16% 11-15 years 38% 2-5 years 4% Hired post-transition
Things to remember Make it easy for the audience Remove anything that doesn’t add to the story Keep it simple Make the points ‘pop’ Know your content Be creative! 39
Thank you! 40
You Try! 41 Waterfront Communities – The Island This neighborhood has the most accommodations (2268 in total) of all neighborhoods. Of those accommodations… 87% Entire Home 12% Private Room 1% Shared Room Average Price for accommodations… Entire Home - $150 Private Room - $75 Shared Room - $84 Type of Accommodation Average Overall Satisfaction Entire home/apt 3.3 Private room 3.0 Shared room 2.9