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 …
Introduction There are a lot of visualisation common practises that are less than ideal. One of those is the funnel chart. I think the analogy works well, however a lot of implementations are misleading at best. Unfortunately the default funnel chart in CRMA belongs in that category. As the value is only encoded in the …
Introduction A few weeks back, in week 11, I set this challenge to build a viz that allows the comparison of state sales. I indicated at the time that it was part 1, so this week is part 2 and we’re going to expand on the requirements. This type of scenario is very typical in a …
#WOW2023 | Week 23 | Can You Compare State Sales?- Part 2 Read More
Introduction This week’s challenge uses Deneb custom visual to create a jittered scatter with inverted axis plus a bubble plot with labels. Requirements Power Query Obtain the dataset from Australian Bureau of Meteorology Website Model and load data Power BI Desktop Option 1: Obtain Deneb Custom Visual from AppSource Create a Scatter Chart with point …
2023 Week 22 | Power BI: Inverted Jittered Scatter Read More
Introduction Last week, our team was faced with an unique challenge and I’m using it as the basis for this week’s challenge! The premise is quite simple – create a dashboard that shows KPIs and a trend of the selected kpi. Allow the user to filter dates, change the period type and select a period …
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
Introduction This week’s challenge is a slight twist on the classic Measure (bar) vs Target (gantt) chart. The key difference here is that we want to allow the user to select a ‘tolerance’ around the specific Target value. We only want to highlight months where profit was Above or Below the permited tolerance. Click to …
#WOW2023 | Week 21 | Profit vs Target (with Tolerance) Read More
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
Introduction This week, I’m introducing the idea of taking bathymetry or contour lines on maps and placing the lines on heat maps. These lines come from identifying the elevation (for contour lines) or depth of water (for bathymetry lines) and creating a map using those values. Here is an example of a contour map from …
2023 Week 20: Can you build a heat map with bathymetry lines? Read More
Introduction I’m so excited to bring this challenge to you live from Tableau Conference 2023 and I get to be the one who created the challenge. I saw something on twitter a while back and wanted to see if I could recreate it in Tableau. This challenge is not as easy as it looks but …
#WOW2023 Week 19: Can you create a jitterfly chart? TC23 Live Edition Read More
