# Luke Stanke

## Week 25: Segmentation Drift

This week we start using the analytical tools — specifically clustering. Tableau’s built in cluster algorithm can be used to do customer segmentation. But instead of doing this by customer we are going to keep it simple by using sub-category and region. Intermediate click to view on Tableau Public   Jedi click to view on …

## Week 22: Which city contributes the most sales to each state?

He’s back again! Andy Kriebel shares with a problem that you can only use table calculations to solve Requirements Use only table calculations The bar length is the total sales of each state City must be included in the view. Display only one mark per state. Label each bar by the city with the highest …

## Week 21: Profit and Sales Cat Emoji Map

This week’s Workout Wednesday is an emoji map. The original idea comes from a Dark Sky emoji map of the weather. This worksheet has several major elements you’ll have to work through: Data modeling Percentiles Hex bins of geospatial data Working with emojis Customized “legend” Requirements Dashboard size: 600 x 600, 2 sheets (floating and …

## Week 18: Customer Retention By Cohort and Quarter

If you’ve ever worked with web Google Analytics then you’ve probably seen the cohort analysis chart. To me its the coolest information provided. This week were back with an intermediate and jedi options. Both look basically the same but the jedi forces your thinking to a higher level!   Intermediate Build a cohort analysis heat …

## Workout Wednesday – Week 16: Sales for the last N vs. same time previous year

Sorry for the late post. I’m filling in this week at the last minute. Here is this weeks workout.   click to view on Tableau Public Dashboard size is 700 x 600; tiled; 1 sheet Use a date parameter to select a select end date, limit it to all days in 2017. Use a parameter …

## Week 15 Solution

Let’s take a closer look at this week’s intermediate problem. click to view on Tableau Public   Requirements: Dashboard size is 850 x 600; tiled; 1 sheet Each member of the pictogram is a distinct product name. Each row in the pictogram has 10 members. Members of each new row are included from left-to-right. Sort …

## Week 15: Total Products by Sub-Category OR Top 5 Sub-Categories by Total Product

I’m back from a one month hiatus! Hopefully you enjoyed the guest posts from Curtis Harris and Ann Jackson. This week were giving you two options: Intermediate or Jedi. Both are a play on an olympics visualization I put together a month ago. The Intermediate requires just a handful of calculations. The Jedi looks just …

## Week 10 Solution

Below is a chart built for #WorkoutWednesday. It seems to have thrown people off a bit. Just as a reminder here are the requirements: Use sales for 2017. The size of the dashboard 500px x 600px. If you think of the segments as a clock, Week 1 should be at the 12:00 position. The weeks …

## Week 10: Keep an Eye on Sales

Below is an abstract view of superstore sales by week for 2017. Each set of three lines are the percent of sales by segment for that week. The lines are equally spaced based on the percent of the year complete. There is also a nice space between each of the line segments for each week. …

## Week 8: Is it a trending baby name?

This week we take a look at chart that looks so simple: the number of births by year for any given name. There are few requirements that make this much more tricky. While the dataset is huge, I’d like you to show one name: whatever name you see in the parameter. When the parameter is …

Scroll to Top