Year: 2024

#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

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 5 | Sigma: Can you use dynamic text to report on KPIs?

Introduction Welcome to Week Five 🖐🏼 This week’s challenge is all about crafting an impactful headline. Whether it’s for the top of a dashboard or a key component of a presentation, the goal is to effectively highlight KPI performance of email campaigns through Hubspot. We’ll be utilizing Sigma’s dynamic text feature, drawing data directly from …

2024 Week 5 | Sigma: Can you use dynamic text to report on KPIs? Read More

Scroll to Top