2024 Week 18 | Power BI: Visualize Mammal Lifespan with a Scatterplot and Background Image

Introduction

Continuing on last week’s infographic theme, we are recreating an infographic from Visual Capitalist this week, this time showing average lifespan for different mammals. 

We will be using a scatterplot visual of your choice this week. I made two demo versions, one using the Deneb custom visual and one using the Enhanced Scatterplot custom visual. Both of these custom visuals are free to use. The scatterplot core visual didn’t provide enough customization on the data labels to work well today, but enhancements around labels are coming from the Power BI team (so if you are reading this in the future, it might be a sufficient option).

Requirements

1. Retrieve the data from Data.World

2. Use a background image, either within the visual or on the page to show animal pictures related to each data point. I put the two images I created on Github: scatterplot background, page background. Feel free to use those if you don’t want to make your own, but I think creating background images in Figma is a good skill to cultivate. Please note the image attribution page on my report, as I gave credit to the sources of my images as required by some of their copyright licenses. 

3. Create a scatterplot using your visual of choice (custom or core). Order the animals by lifespan ascending (weasel to whale). Make the size of the mark represent the lifespan number. Line up the scatterplot marks with the animals in your background image. 

4. Be sure each mark has a label containing the animal and the average lifespan. 

Dataset

You can find this week’s data on Data.World at https://data.world/mlongoria/wowpbi2024w18

There is a single table in the dataset. .

The data was gathered from https://posts.voronoiapp.com/other/How-Human-Lifespans-Compare-to-Other-Mammals-972. It was further compiled and manipulated for this exercise. 

Note: Data.World requires you to create a free account to access the data. You may use the Data.World connector in Power BI or download the file to your local machine and connect to it there.

Share

After you finish your workout, share on Twitter or LinkedIn using the hashtags #WOW2024 and #PowerBI. If you share on Twitter, please tag @MMarie, @shan_gsd, @KerryKolosko. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.

Solution

Scroll to Top