Click animation to open on Tableau Public
DataGoogle Sheet here data.world here
- Dashboard size 1000 x 800
- Separate customers into weekly cohorts, where the cohort is defined by each customer’s first order week in the data set
- Remember, weeks need to start on Monday in this challenge
- For each cohort, track the percentage of “week 0” customers who came back anywhere from 10-26 weeks later
- Create a parameter that defines how many weeks our retention model should have
- The heat map should only display cohorts who have completed the full length of the retention model
- Notice how the viz never goes into the traditional triangular shape of a retention chart
- If the cohort week is the last week of the model, don’t display in the heat map, and create a 50% bar chart to be layered next to the heat map
- This bar chart should be hard coded to range from 0-50%
- Make sure the bar chart for the last week of the retention adds the label of “Week” to the cohort week, where the heat map should just display the week number (see image)
- Make sure the label updates as the length of the retention curve changes
- Create a summary/BAN worksheet that displays the overall n-week retention for all cohorts combined
- Match tooltips exactly
- Match formatting and colors as closely as you’d like – any sequential color scale should be fine
ShareAfter you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 and tag @AnnUJackson, @LukeStanke, @lorna_eden, and @curtisharris_!
Track your progressAlso, don’t forget to track your progress using this Workout Wednesday form.
When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.