2023 Week 23 | Power BI: Build with Core Visuals

1 Comment / Power BI, Workout Wednesday / By

Introduction

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!

Requirements

Get and transform data

  1. 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.
  2. 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)
Create visuals
  1. Select the visuals you’d like to recreate
    •  I chose #1, #25, and #62
  2. 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
  3. Add context using the help header icon
  4. 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.

Dataset

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.

Share

After you finish your workout, share on Twitter using the hashtags #WOW2023 and #PowerBI, and 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

Solution File available for download via Data Stories Gallery.

1 thought on “2023 Week 23 | Power BI: Build with Core Visuals”

  1. Pingback: 2023 Week 24 | Power BI: Visualize Change Between Two Points in Time with Deneb – Workout Wednesday

Comments are closed.

Scroll to Top