Workout Wednesday

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

#WOW2024 W43: Can you show total sales and filtered sales in the same view?

Introduction Hello #WOW enthusiasts, I’m Hannah, a data analyst consultant at The Information Lab. This week’s challenge is inspired by a client project I did recently, where I was trying to recreate a specific visual from a different software. I thought I could save you the headache if this kind of problem ever crossed your …

#WOW2024 W43: Can you show total sales and filtered sales in the same view? Read More

Scroll to Top