Introduction This week’s challenge is inspired by something I’d seen at work, and I thought it would be quite fun to see if I could reproduce in Tableau and if so, share as a challenge 🙂 I could, so here it is… can you include & exclude options with a custom control? Click to open …
#WOW2024 | Week 7 | Can you include and exclude options with a custom control? Read More
Introduction This week’s challenge features *secret messages*! It’s not a flashy visual, but it showcases two important features of Sigma that any developer *must* know: Input Tables and Row Level Security. Input Tables allow Sigma users to interact with the data warehouse directly by manipulating tables at the cell-level in Sigma. These input tables can …
2024 Week 6 | Sigma: Can you keep a secret with Row Level Security? Read More
Introduction Welcome back to Workout Wednesday! This week’s challenge is inspired by Ann Jackson, who created the challenge back in 2021 for the Tableau team. Let’s create a Customer Lifetime Value (CLV) Matrix, a tool that marketers use to segment customers based on their value and loyalty to a business. This helps marketers allocate resources …
2024 Week 6 | Power BI: Customer Lifetime Value Matrix Read More
Introduction This week’s challenge came to me via the community! Long time #datafam member turned Tableau employee and still #datafam to the core, Mark Bradbourne! What I love about this challenge, is that there’s multiple ways to solve it and I challenge you to do in more than one way! Click to open in Tableau …
Introduction Sometimes it can be useful to show all data points instead of aggregating them. That is where an instance chart, also called a strip plot or a barcode plot, can be useful. This week we are building on a faceted strip plot made in 2023 week 35, and adding a median overlay. Inspired by …
2024 Week 5 | Power BI: Create a Strip Plot with Median Overlay Read More
Introduction Welcome to Week Five 🖐🏼 This week’s challenge is all about crafting an impactful headline. Whether it’s for the top of a dashboard or a key component of a presentation, the goal is to effectively highlight KPI performance of email campaigns through Hubspot. We’ll be utilizing Sigma’s dynamic text feature, drawing data directly from …
2024 Week 5 | Sigma: Can you use dynamic text to report on KPIs? Read More
Introduction This week we dive into date calculations in SAQL! Unlike other languages, SAWL doesn’t have a simple DATEADD() function. Instead we need to build one ourselves in order to be able to add days to a given date. In this example we have case records with an Open Date, a Close Date and an …
Introduction It’s a pleasure to be back for my third year on the Workout Wednesday team. This week, I wanted to create a challenge that incorporates one of the things that will elevate many visualizations, which is seamless and intuitive interactivty. A good user experience should, by design, appear simple but often involves careful consideration …
#WOW2024 | Week 5 | Excel at Tableau Interactivity with Dynamic Zone Visibility Read More
Introduction Welcome to Week Four! This week, we’re going to create a single element that shows multiple pieces for analysis. This challenge is easier than last week, and is meant to show how quickly Sigma can perform period over period analysis on any KPI. Good Luck!-Ashley Need access to Sigma? Click Here to Sign Up …
2024 Week 4 | Sigma: Can you recreate this KPI Chart? Read More
Introduction I keep seeing a particular visual shared by a Denver-area meteorologist on social media. It seems to be output from weathermodels.com. I thought it might be fun to make a modified version in Power BI, so that is our challenge this week. While we don’t have native overlapping columns, there is a native solution …
2024 Week 4 | Power BI: Recreate this weather visual with overlapping columns Read More
