Workout Wednesday

2024 Week 48 | Power BI: Use a Calendar as a Filter

Introduction Welcome back to Workout Wednesday! I’ve been getting so much of my inspiration from the community lately, and this week’s challenge is no exception! Recently, Andy Kriebel posted a cool calendar filter on LinkedIn, that he built using Tableau. Our very own guest contributor and friend Erik Svensen took Andy’s post and re-created it …

2024 Week 48 | Power BI: Use a Calendar as a Filter Read More »

2024 Week 48 | Sigma: Can you map these Thanksgiving Dishes?

Introduction Welcome to Week Forty-Eight!  This week, I am heavily focused on my Thanksgiving preparations, so naturally, we will be taking our Workout Wednesday to the kitchen. I asked Chat GPT to generate us a dataset involving popular Thanksgiving dishes by state.  We’re going to use that to utilize some newer features, like a conditional …

2024 Week 48 | Sigma: Can you map these Thanksgiving Dishes? Read More »

2024 Week 45 | Sigma: Can you create these patient demographic visuals? 

Introduction Hey everyone! This week’s Workout Wednesday focuses on creating clear, actionable patient demographic visuals using a Sankey, a KPI, and two bar charts—binned and unbinned. Here’s the setup: the Sankey chart helps us map distribution, while the KPI delivers an at-a-glance view of a key metric to ground the analysis. With the bar charts, …

2024 Week 45 | Sigma: Can you create these patient demographic visuals?  Read More »

bubble likert

2024 Week 46 | Power BI: Likert Bubble

Introduction Utilising the dataset from a previous challenge (week 43), this week we are going to build a bubble likert chart. Likerts are usually ordered categorical data, and often it does not make sense to convert categories to a numerical  score to find averages. Sometimes, likerts can be treated as interval data. https://www.scribbr.com/methodology/likert-scale/. For the …

2024 Week 46 | Power BI: Likert Bubble Read More »