# Luke Stanke

## 2022 – WEEK 44: What is the lifetime value of customers?

Introduction This is probably my favorite challenge of the year. So i’m saving it for near the end. You’ll need level-of-detail and table calculations to solve this one. For this challenge you need to calculate customer lifeftime value (in sales). While their are many ways to do this. We are going to keep this as …

## 2022 – Week 39: Where were COVID-19 Cases most active on December 30th, 2021?

Introduction This week we’ll look back at COVID-19 cases in the continental United States on December 30th, 2021. In this challenge you will use data from covidactnow.org to show where cases were most prevalent in terms of cases per 100,000. The data for this challenge are already pre-loaded in a workbook. They include the COVID-19 …

## 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 29: What is the Time-Weighted Return?

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 …

## 2022 – WEEK 24: How is the arctic ice extent trending?

Introduction This week you are invited to build a horizon chart of the arctic ice extent–the amount of ice on the arctic ice cap. Data comes from the National Snow and Ice Data Center. In case you are not familiar with the horizon chart, a nice definition can be found here on Nathan Yao’s Flowing …

## 2022 – Week 19: Can you format the dashboard?

Introduction This week the challenge focuses on formatting and your ability to use containers. The goal is to create a near pixel perfect copy of the original. Focus on your use of containers along the way. Click to open in Tableau Public Requirements Dashboard Size: 1100px by 850 px 9 sheets About 7 vertical containers …

## 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 9: How many patients were admitted every 15 minutes?

Introduction This week we are going to look at hospital admission rates. This data source comes from The Medical Stays dashboard on the Tableau Exchange. This particular challenge is more focused on working with time than it is working with medical data. In this challenge you need to group time into 15 minute increments throughout …

## 2022 – Week 4: How have successful products performed?

Introduction This week’s challenge looks at products in Tableau’s superstore dataset. In this challenge you will have to find the products that have been profitable in each of the four years in this dataset. That means profitable in 2018, 2019, 2020, and 2021.  Once you have identified successful products (the consistently profitable products) then you …

## WOW2021 – Week 52: Can you build a table with one measure?

Introduction For the last week of 2021 we’ve got a straightforward challenge: create a table with one measure. For fans of the (The Great British) Bake Off note the simple instructions for this technical. Click to open in Tableau Public Requirements Dashboard Size: 1000px by 600 px Match the values in the table using Sales, …

Scroll to Top