Workout Wednesday

2024 Week 8 | Power BI: Build a Pipeline Funnel with Core Visuals

Introduction This week’s challenge we will be utilising visual calculations (this will require turning Visual Calculations on in Preview settings of February 2024 Desktop) and some additional new data label formatting options to create a pipeline funnel with out of the box visuals in Power BI. Visual calculations can be handy for visual specifiic calculations …

2024 Week 8 | Power BI: Build a Pipeline Funnel with Core Visuals Read More

2024 Week 8 | Sigma: Can you customize this tooltip?

Introduction A good data visualization strikes a balance between enough and too much information. For this week’s challenge, we will explore a couple of ways to customize tooltips. Customizing these can help provide users with meaningful information without overwhelming or crowding the visuals. I’m sure you’ll knock this one out of the park! Need access …

2024 Week 8 | Sigma: Can you customize this tooltip? Read More

#WOW2024 | Week 8 | Can you create an area chart tile map?

Introduction While reviewing recent work I’ve done in preparation for this week’s challenge, I came across a tile map with individual area charts by state that we use to monitor subscriptions, and thought it would be a fun one. As I dug into it, I realized it was inspired by Luke’s challenge in 2020 Week …

#WOW2024 | Week 8 | Can you create an area chart tile map? Read More

A Line Graph that changes between different date granularities

2024 Week 7 | Sigma: Can you recreate this Line Graph?

Introduction Welcome to Week Seven! This week, you’re going to create a line graph that can change its date granularity.  With a dynamic x-axis, this graph allows users to view trends at the level that makes sense for their current needs, without duplicating work. Also in this challenge, you’re going to learn how to show …

2024 Week 7 | Sigma: Can you recreate this Line Graph? Read More

2024 Week 07 – Column interaction sorting

Introduction It’s already week 7 of our #WorkoutWednesday challenges (whoa, time flies…). In this challenge, I’d like to explore one aspect of the column multi-selection interaction in CRM Analytics: sorting. When we select more than 1 grouping, can we maintain the sorting within the selected groups, regardless of the selection’s order? We’ll find out in …

2024 Week 07 – Column interaction sorting Read More

DataViz Makeover of bar chart

2024 Week 7 | Power BI: Report Re-design – Aussie trips to Indonesia

Introduction This week’s challenge is a little different, we will be looking to make-over a report from the Australian Bureau of Statistics. This report contains a lot of information and data sources to download, so it is up to you as to how much or how little you want to do. The primary challenge, however, …

2024 Week 7 | Power BI: Report Re-design – Aussie trips to Indonesia Read More

#WOW2024 | Week 7 | Can you include and exclude options with a custom control?

Introduction This week’s challenge is inspired by  something I’d seen at work, and I thought it would be quite fun to see if I could reproduce in Tableau and if so, share as a challenge 🙂 I could, so here it is… can you include & exclude options with a custom control? Click to open …

#WOW2024 | Week 7 | Can you include and exclude options with a custom control? Read More

Screenshot of some text that displays a secret message

2024 Week 6 | Sigma: Can you keep a secret with Row Level Security?

Introduction This week’s challenge features *secret messages*! It’s not a flashy visual, but it showcases two important features of Sigma that any developer *must* know: Input Tables and Row Level Security. Input Tables allow Sigma users to interact with the data warehouse directly by manipulating tables at the cell-level in Sigma. These input tables can …

2024 Week 6 | Sigma: Can you keep a secret with Row Level Security? 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

Scroll to Top