Workout Wednesday

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

#WOW2024 | Week 45 | Can You Switch A Dashboard Theme?

Introduction This month we hold Global Community Weeks! We’ll feature guest coaches from around the world in the coming weeks. I’m excited and honored to introduce Tomoki Goda (@padawan_viz) from Japan! Tomoki is relatively new to Tableau but is strongly passionate about Tableau community activities. He is one of the co-hosts of a popular Japan …

#WOW2024 | Week 45 | Can You Switch A Dashboard Theme? Read More

2024 Week 44 | Power BI: Community Appreciation – SQLJason

Introduction Welcome back to Workout Wednesday! I’m nearing the end of my 4th year contributing to this incredible initiative, and quite honestly, I am running out of ideas! This week I went to the Fabric Data Stories Gallery to look at reports that have inspired me, and I was reminded of this incredible report that Jason Thomas …

2024 Week 44 | Power BI: Community Appreciation – SQLJason Read More

2024 Week 44 | Sigma: How likely is a holiday birthday?

Introduction Welcome to Week Forty-Four! This week, I wanted to have a little fun because not only is Thursday Halloween, but it’s also my birthday.  As someone who loves data and shares her birthday with a holiday, I am interested to see just how common holiday birthdays are. In this challenge, you will use a couple …

2024 Week 44 | Sigma: How likely is a holiday birthday? Read More

#WOW2024 Week 44 | Can you join two spatial files to find intersection?

Introduction This week we’re working with some spatial data. I have a project at work where we’re finding the number of records (points) that are within a geospatial area (polygon), so we’ll try that this week. We’ll use public school district boundaries (polygons) and school locations (points) to find the number of schools in each …

#WOW2024 Week 44 | Can you join two spatial files to find intersection? Read More

Chart Makeover

2024 Week 43 | Power BI: Line Chart Makeover

Introduction This week’s challenge is to test your data storytelling skills and enhance a line chart of service desk survey responses to focus attention on important aspects. No solution file provided this week. Requirements Obtain the data Model Data Create a chart showing survey response trends Dataset This week’s dataset is downloadable from Github https://github.com/kolky001/Workout-Wednesday-2023/blob/main/Help%20Desk.xlsx  …

2024 Week 43 | Power BI: Line Chart Makeover Read More

2024 Week 43 | Sigma: Can you create a segmented date control?

Introduction This week, I wanted to highlight Sigma’s actions once again, as we got a new update a last week: The ability to change date controls via actions! Pairing this new feature with the ‘Conditions’ beta feature in actions, we can create more user-friendly date filtering with much less hassle. Stay up to date on changes to …

2024 Week 43 | Sigma: Can you create a segmented date control? Read More

Scroll to Top