Introduction This week is Dreamforce; Salesforce’s conference. So I thought I would stay on theme and use Salesforce Data. When I first started to see Salesforce pre-built dashboards they included several elements, but the one we are going to focus on today is the Waterfall chart. This allows us to see how much value is …
#WOW2022 W38: Can you create a Waterfall Pipeline using Salesforce Data? Read More
Introduction This week’s challenge is focused on Level of Detail (LOD) calculations. We could probably build this chart using Table Calculations, but we’re not going to. Deliberate practice with some basic LODs. This also can be the basis for some cohort analysis, aligning various groups from different time periods on the same starting point. And …
#WOW2022 Week 37: Can you create a common starting point? Read More
Every needed to visualize a % of total across two dimensions & measures? Then the Marrimeko chart is what you need! Check out this week’s #WOW2022 challenge for a throwback to 2017 week 8
Introduction This week’s challenge is brought to you by a guest coach, my colleague Valerija Kirjackaja, who came across this problem at work and created a beautiful solution for it. How often do you get asked to re-create Excel tables in Tableau? On a scale from 1 to ‘I am never doing this again’ – …
#WOW2022 | Week 35 | Conditional Table Formatting with Dynamic Headers Read More
Introduction This week we return to another business-specific challenge. This team we will explore hospitality data. The goal of this challenge is to determine what the average occupancy is by day at three different properties. The challenge of this data is that you’ll only ever know when customers check-in or check-out. Not the actual total …
2022 – Week 34: What is the average occupancy by weekday? Read More
Introduction When looking through the challenge insights I realised we haven’t had many of the fundamental LOD style Workouts for a while. So this week we take a look at how does the latest month compare to the prior X months average? Click to open in Tableau Public Requirements Dashboard Size: 800 x 700px 2 …
#WOW2022 W33: Can you compare the latest month to the prior X months average? Read More
Introduction About three years ago, I was participating in our weekly Makeover Monday group at work, and happened to immediately know what I wanted to build and got it done in about 40 minutes. A colleague also completed theirs in that time, and so we then shared what we had built with the rest of …
Introduction Who doesn’t love a good KPI dashbaord? This one is fairly simple and straightforward. Let’s look at four simple metrics and see how each subcategory ranks within a selected metric. With this challenge – MIND THE NUMBER FORMATTING 🙂 Click to open in Tableau Public Requirements Dashboard Size: 700 x 350 2 sheets Display …
Introduction I’ve been wanting to create this challenge for some time, so I’m really glad to finally be releasing it. This challenge was inspired by some work I did last year where a client wanted to be able to visualize the number of hours that their team had spent working on different projects. What made …
Introduction Working with financial data is hard. There are some calculations that make for long evenings to get right. One of those calculations is Time-Weighted Return. This challenge is simple: calculate the Time-Weighted Return Rate for a simple data source and return a line chart. Click to open in Tableau Public Requirements Dashboard Size: 400px …
