Introduction For this challenge you must re-create a table that describes orders by region. The big challenge will be creating the pie chart. Click to open in Tableau Public Requirements Dashboard Size: 700 x 300px 1 sheet & a few text boxes Create the table using Region, Order ID, and Sales The table should show …
Introduction This challenge you are to recreate a pie chart with some interesting formatting. Click to open in Tableau Public Requirements Use Segment and Sales to divide the pie slices. Have a thin solid exterior with Segment labels on the outside. Have white space between the edge and the interior of the pie. Have a …
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 44: What is the lifetime value of customers? Read More
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 39: Where were COVID-19 Cases most active on December 30th, 2021? 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 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 …
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 24: How is the arctic ice extent trending? Read More
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 …
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 …
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 9: How many patients were admitted every 15 minutes? Read More
