Intermediate

Star Trek timeline data plotted on a sine wave

2024 Week 16 | Power BI: Timeline on a Sine Wave with Core Visuals

Introduction In this week’s challenge, we are creating a timeline visual on a sine wave. You can use your creativity to break out the timelines into series, through conditional formatting, offsetting separate shapes, or create different shapes using different trigonomic functions. Alternatively, with small multiples. Requirements Obtain the data from Kaggle and/or Wikipedia Create a …

2024 Week 16 | Power BI: Timeline on a Sine Wave with Core Visuals Read More

2024 Week 14 | Power BI: Use a matrix to re-create a Tableau viz

Introduction Welcome back to Workout Wednesday! This week we’re recreating a really neat viz that was originally created by Flávio Matos for the Tableau team back in 2023. Flavio created the Periodic Table of Wine, with an option for users to select the food they’ll be eating to help them pair the perfect wine. Today, …

2024 Week 14 | Power BI: Use a matrix to re-create a Tableau viz Read More

2024 Week 12 | Power BI: Contact Cards and Headerless Tables

Introduction This week’s challenge uses a custom visual to achieve some formatting that cannot currently (as of March 2024) be achieved using core visuals. First, we have a table that contains 2 columns and no headers. Next, we have some contact cards that contain both an image and text. The catch is that the number …

2024 Week 12 | Power BI: Contact Cards and Headerless Tables Read More

2024 Week 11 | Power BI: IBCS Charts with Injae

Introduction Welcome back to Workout Wednesday! This week we’re taking notes out of Injae Park’s portfolio and recreating one of his IBCS charts. IBCS, or the International Business Communication Standards is a set of rules to level up how businesses talk and share info. Think of it as a cheat code for clearer charts and …

2024 Week 11 | Power BI: IBCS Charts with Injae Read More

2024 Week 09 – Formulate Select and Navigate Dashboard

Introduction Almost the end of February! Time flies fast! – And another WoW Challenge is here!!  This week is based on the same dataset and maps we had as a challenge during Week 4! The changes are adding one KPI, and one top 5 chart to the existing dashboard. Then add an Interaction (not binding) …

2024 Week 09 – Formulate Select and Navigate Dashboard Read More

2024 Week 6 | Power BI: Customer Lifetime Value Matrix

Introduction Welcome back to Workout Wednesday! This week’s challenge is inspired by Ann Jackson, who created the challenge back in 2021 for the Tableau team. Let’s create a Customer Lifetime Value (CLV) Matrix, a tool that marketers use to segment customers based on their value and loyalty to a business. This helps marketers allocate resources …

2024 Week 6 | Power BI: Customer Lifetime Value Matrix Read More

Faceted Strip Plot with Median Overlay

2024 Week 5 | Power BI: Create a Strip Plot with Median Overlay

Introduction Sometimes it can be useful to show all data points instead of aggregating them. That is where an instance chart, also called a strip plot or a barcode plot, can be useful. This week we are building on a faceted strip plot made in 2023 week 35, and adding a median overlay. Inspired by …

2024 Week 5 | Power BI: Create a Strip Plot with Median Overlay Read More

2024 Week 1 | Power BI: Stacked Bridge with Core Visual

Introduction This week’s challenge builds on last weeks challenge to utilise updated column fill and data labelling features from the Power BI December 2023 release. The challenge will be to create a stacked bridge chart using the core column and line combo chart. Building the bridge will require calculated tables. Intermediate users can use the …

2024 Week 1 | Power BI: Stacked Bridge with Core Visual Read More

Scroll to Top