Beginner

2023 Week 26 | Power BI: Display metrics with the new card visual

Introduction Welcome back to Workout Wednesday! This week we’re exploring the new card visual that was released in preview this month. Key metrics are frequently displayed in reports, and in the past it took a combination of cards, images, and other visuals. Thanks to the new card visual, we now have more flexibility, options for …

2023 Week 26 | Power BI: Display metrics with the new card visual Read More

2023 Week 26 | The Component Widget

Introduction This week we are exploring the Component widget. Essentially it is a container with pages that allows you to quickly create and reuse dynamic areas of a dashboard! Components solve 2 main use cases: Reusability & maintainability (the components you create in this challenge will be used again in a future challenge!) Easily (through …

2023 Week 26 | The Component Widget Read More

2023 Week 23 | Power BI: Build with Core Visuals

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 …

2023 Week 23 | Power BI: Build with Core Visuals Read More

Sample Power BI report

2023 Week 21 | Power BI: Create a Theme – With a Twist!

Introduction This week, we’re building on Shannon’s theme from Week 17 2022 by creating a custom Power BI theme–with a twist!   Instead of manually selecting colors, this week you’ll use OpenAI’s free version of ChatGPT (or your Large Language Model (LLM) of choice) to create a theme. You’re in control of your prompts, and …

2023 Week 21 | Power BI: Create a Theme – With a Twist! Read More

baseball length column chart

2023 Week 20 | Power BI: Remake of Tableau Length of Baseball Games

Introduction For this Workout Wednesday, we are putting a Power BI spin on a Tableau viz created by Luke Stanke and Spencer Bauke for their Workout Wednesday 2023 Week 14.  While we could probably match nearly exactly to the original Tableau viz by using Deneb in Power BI, I wanted to see what I could …

2023 Week 20 | Power BI: Remake of Tableau Length of Baseball Games Read More

2023 Week 19 | Power BI: Formatted bar chart and bookmark navigator

Introduction Welcome back to Workout Wednesday! We’re taking inspiration once again from our friends at Makeover Monday. This one is fun – the Makeover Monday team was inspired by a bar chart featured in a blog post and they decided to recreate it in Tableau! You can read Andy’s full post on his blog if you want more info.  Today …

2023 Week 19 | Power BI: Formatted bar chart and bookmark navigator Read More

2023 Week 15 | Power BI: What-if parameters inspired by Makeover Monday

Introduction Welcome back to Workout Wednesday! This week we’re using a Makeover Monday dataset that was inspired by Andy Kriebel’s post on Twitter (dataviz inception!). Andy has been working through Makeover Monday challenges in Power BI, and I thought it would be a good opportunity for us to do some of these together! This week’s challenge uses what-if parameters, a …

2023 Week 15 | Power BI: What-if parameters inspired by Makeover Monday Read More

Doge with a word cloud of US misspellings

2023 Week 14 | Power BI: Word Cloud and Modulo

Introduction This week’s challenge is inspired by recent Twitter activities. We are creating a word cloud containing common misspellings in the US. Requirements Power Query Obtain the dataset from https://www.dailymail.co.uk/femail/article-11357183/Google-search-data-reveals-commonly-misspelled-words-spell-correctly.html OR https://github.com/kolky001/Workout-Wednesday-2023/blob/main/Misspellings Transform and load data HINT : Add Index column, create modulo column, unpivot data Power BI Desktop Obtain Word Cloud custom visual from …

2023 Week 14 | Power BI: Word Cloud and Modulo Read More

2023 Week 12 | Data Syncs & Scheduling

Introduction Hello and welcome to WoW week 12! This weeks challenge will be short & sweet from a requirements perspective but will hopefully provide valuable insights to help you optimize your data sync cycle. Tip… check out the Tips section! Requirements Navigate to the dataset created in a previous exercise, or create a new one …

2023 Week 12 | Data Syncs & Scheduling Read More

Image of Power BI report.

2023 Week 12 | Power BI: Are your reports accessible?

Introduction Welcome back to Workout Wednesday! This week we’re taking a note out of Meagan’s book and looking at existing reports to ensure they’re accessible to our end-users.  Creating accessible Power BI reports isn’t just a nice-to-have feature, but a crucial aspect for ensuring all users can access and understand your data. Don’t let accessibility …

2023 Week 12 | Power BI: Are your reports accessible? Read More

Scroll to Top