Year: 2024

2024 Week 41 | Sigma: Can you create a dynamic column bar chart? 

Introduction For this week’s challenge, we’re creating a dynamic column bar chart. The end user can select the number of columns to split the data into. Note that there are only 37 States in the Plugs data, so do your best not to hard code anything for a more realistic use case! Have fun!-Katrina Need …

2024 Week 41 | Sigma: Can you create a dynamic column bar chart?  Read More

#WOW2024 | Week 41 | People Resource Planning

Introduction This week’s challenge is brought to you by another guest coach – introducing Dan Wade!   Dan has been working with Tableau for just over a year. Originally trained by *the* Matt Francis in a Management Trainee role, Dan quickly recognised the power of data visualisation and analytics so he decided to pivot his …

#WOW2024 | Week 41 | People Resource Planning Read More

2024 Week 40 | Sigma: Can you avoid the food?

Introduction Welcome to Week Forty! In my last article,  Week 36, we covered how to affect multiple columns using the same filter.  This week, we’re going to focus on even more advanced filtering techniques.  What do you do when you want to compare multiple arrays?  Luckily Sigma recently released a brand new function:  ArrayIntersection.   In …

2024 Week 40 | Sigma: Can you avoid the food? Read More

#WOW2024 | Week 40 | Can you create a brush filter?

Introduction Deciding how to best use the limited space on a dashboard is always a challenge. I’ve often struggled with practical issues, especially regarding the placement of filters. This time, let’s create a brush filter as one way to use the chart itself as a filter. Enjoy the challenge and have fun trying it out!” …

#WOW2024 | Week 40 | Can you create a brush filter? Read More

2024 Week 40 | Power BI: #FabConEurope Edition – Contest Deadline Extended!

Introduction Welcome back to Workout Wednesday. This week we’re extending the #FabConEurope edition of Workout Wednesday. We’re hosting a contest and three winners will receive a 30-minute one-on-one mentoring session with one of the three Workout Wednesday hosts. For more information on how to enter, see contest details below. Requirements   Get and transform data Get …

2024 Week 40 | Power BI: #FabConEurope Edition – Contest Deadline Extended! Read More

2024 Week 39 | Power BI: #FabConEurope Edition

Introduction Welcome back to Workout Wednesday. This week we’ve got a special #FabCon Edition of Workout Wednesday. We’re hosting a contest and three winners will receive a 30-minute one-on-one mentoring session with one of the three Workout Wednesday hosts. For more information on how to enter, see contest details below. Requirements   Get and transform data Get …

2024 Week 39 | Power BI: #FabConEurope Edition Read More

2024 Week 39 | Sigma: Can you test out changes in cost?

Introduction This week, I wanted to challenge myself to do something I didn’t know how to do in Sigma, I wanted to start laying the groundwork to do sensitivity analysis. I’ve often thought this would be possible in Sigma, since we can connect to Snowflake User-Defined Functions (UDFs) via Sigma’s function bar to call models …

2024 Week 39 | Sigma: Can you test out changes in cost? Read More

2024 Week 38 | Sigma: Can you create reference marks?

Introduction Welcome to Week 38! Sometimes there are events or notable data points that aren’t stored in your data, but you want to see how they effect the trends. Enter reference marks and conditional formatting! This week we practice using reference marks and conditional formatting to highlight specific dates and events. The formatting styles and …

2024 Week 38 | Sigma: Can you create reference marks? Read More

#WOW2024 | Week 38 | Can you create multi-select parameters?

Introduction This week’s challenge again comes from trying to solve a problem in my day job, where I was exploring the possibility of parameters being multi-select like filters. We couldn’t use filters because we had different data sources, so I found a few forum and blog posts that make multi-select parameters a possibility, even if …

#WOW2024 | Week 38 | Can you create multi-select parameters? Read More

Scroll to Top