A data visualisation of the rather odd habits of dogs.
| 🚀 PROJECT | 🔗 LINK |
| Iron Quest | Tableau Public |
| 🛠️ TOOLS | 🛢️ DATA |
| Python, R, Tableau Public, Figma |
List of dog breeds, Google suggestions API, and radial heatmap generator |
| 🏆 AWARDS | 📰 CITATIONS |
| Viz of the Day 2023-01-12 150+ ⭐ on Tableau Public |
Dogs are amazing, man’s best friend you might say! But for any dog owners, you’ll know that they come with some unusual habits, like snoring, excessive farting and howling in their sleep.
To find out which breeds have the strangest habits I’ve consulted Google Search’s Autocomplete feature and retrieved data on 60 popular dog breeds to find our most common questions.
- List of dog breeds modified from wjsutton/the_kennel_club with a few additional dog breeds
- Google suggestions API a largely undocumented API of the form
https://suggestqueries.google.com/complete/search?output=toolbar&hl=en&q=YOUR+QUERYreturns an XML output - Radial Heatmap Generator an R Shiny app to generate a radial heatmap to plot points
- get_google_dog_suggestions.py feeds List of dog breeds into the Google suggestions API and returns a dataset of all search queries related to different dog breeds.
- data_prep.py cleans up the suggested queries into reasonable groups, e.g. smell, stinks, smells so bad, and removes queries that aren't related to dogs, e.g. "why does my boxers ride up" to form the output dashboard_data/why_does_my_dog.csv
- sunburst_gen.R is an early version of wjsutton/radial_heatmap_generator that creates the points of a radial heatmap to join to the dataset, dashboard_data/test_sunburst.csv
The aim for this viz was to create a static eye-catching design to draw readers in, that would one day be published.
Accessibility was comprimised to make the work more engaging, for example:
- Radial charts are harder to read and size data different depending on its position towards the inner/outer ring
- The colour palette isn't colourblind friendly
- All text is contained in an image background so won't be picked up by a screen reader
After sacrifing accessibility to get my readers attention I needed to make the data easy to interpret. To do this I've answered the basic questions with notes on the dashboard.
e.g. the first note "Why does my French Bulldog fart so much?" introduces the reader to
- What the segments in the radial are
- What the colours mean
- The context and humour associated with the viz
The visualisation utilises the map layers function in Tableau to convert the X, Y co-ordinates into latitude, longitude, and allows me to stack multiple datapoints on top of each other. This helps with the labelling of the segments.
The background of this visualisation was created in Figma:
- Title Font: Luckiest Guy
- All other text: BentonSans Regular (same as Tableau Regular)
Will Sutton, March 2023
Twitter 💬 | LinkedIn 👔 | GitHub 
| Website 🔗