table calculations

#WOW2022 W38: Can you create a Waterfall Pipeline using Salesforce Data?

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

2022 – Week 34: What is the average occupancy by weekday?

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

#WOW2022 Week 31: Let’s build a KPI dashboard

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 …

#WOW2022 Week 31: Let’s build a KPI dashboard Read More

2022 – Week 14: Can you track headcount?

Introduction This week we are looking at HR headcount data. Headcount data can sometimes seem straightforward to work with, but sometimes the reporting rules can be a bit complicated–particularly with large organizations. This week you will attempt to measure the headcount of a large organization using data from the Real World Fake Data project by …

2022 – Week 14: Can you track headcount? Read More

WOW2022 Week 2: Can you build a weekly Year-over-Year line chart?

Introduction I’m excited to join the Workout Wednesday coaching team this year! For my first challenge, I’m pulling from some recent work experience. Our leadership team wanted to see weekly performance for the week ending Sunday, with the current and prior 2 years in the chart. We also needed to include the YoY% change, and …

WOW2022 Week 2: Can you build a weekly Year-over-Year line chart? Read More

Scroll to Top