Welcome back to Workout Wednesday! This week’s inspiration comes from the incredibly cool 1 dataset 100 visualizations project, presented by the Data Viz Project. The basic premise of the 1 dataset 100 visualizations project is that the team created 100 visualizations using a single, simple dataset. In today’s exercise, we challenge you to re-create as many of the 100 visualizations as you’re able!
Today’s challenge is presented using only Power BI core visuals. This means that there are no custom visuals and nothing additional that you’ll need to learn. All you’ll need is a bit of patience and some formatting skills!
To our amazing advanced crew out there, feel free to go beyond the core visuals. As always, we’d love to see what you can do!
Get and transform data
- Enter data in Power Query. The sample dataset from the Data Viz Project team contains data on UNESCO World Heritage sites for 3 countries, for 2 years.
- In Power Query:
- unpivot the year columns
- double check data types
- rename columns if you’d like
- add a sort order column (this comes into play to make the visuals match the samples exactly)
- Select the visuals you’d like to recreate
- I chose #1, #25, and #62
- Create your visuals and pay close attention to:
- colors and font (I use the Colour Contrast Analyzer to find hex codes)
- unnecessary default items, like axis labels and gridlines
- Add context using the help header icon
- Ensure that all visuals meet the minimum standards of having alt text, that the tab order in your report makes sense, and that your color choices meet the minimum standards.
This week’s data comes to us courtesy of the Data Viz Project, who retrieved the data from the UNESCO website. It can be accessed directly on the 1 dataset 100 visualizations site.