Workout Wednesday

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 »

2024 Week 37 | Sigma: What would you like help with?

Introduction This week’s challenge is a bit different; you have two options!  Imagine you’re creating a workbook showing off all the cool features and functionalities to your coworkers and want to provide a curated list of Sigma’s help documentation. In this challenge, you’ll create an embedded documentation element enabling the end users to choose a …

2024 Week 37 | Sigma: What would you like help with? Read More »

2024 Week 37 | Power BI: Create a Report with Light and Dark Mode

Introduction In honor of the Power BI Desktop dark mode being scheduled for public preview this month, we are making a report that allows you to switch between light mode and dark mode.  Requirements Get the data from Data.World.  Filter the report to the year 2024. Create a card that shows current year sales. Create …

2024 Week 37 | Power BI: Create a Report with Light and Dark Mode Read More »

#WOW2024 | 36 | Can you build a Measure Names Waterfall?

Introduction Welcome back to another challenge. This week we’re tackling some financial data and in particular, a waterfall chart based on multiple measure columns. Can you handle it? Click to open in Tableau Public Requirements Dashboard Size 800 x 600 One worksheet Create a waterfall chart for Gross Sales Discounts Net Sales COGS Profit Create …

#WOW2024 | 36 | Can you build a Measure Names Waterfall? Read More »

2024 Week 36 | Power BI: Recreate a NYT Interactive Article

Introduction Welcome back to Workout Wednesday. This week we’re taking inspiration from the incredible infographics team over at the New York Times. Their 2015 article looks at the average American’s contribution to the drought in California. As of today (Sep 2024), about a third of California remains abnormally dry. This challenge features some fun data work …

2024 Week 36 | Power BI: Recreate a NYT Interactive Article Read More »