2019: Week 27

At Chin & Beard Suds Co (our Preppin' Data fake company), one of our non-executive directors has asked about the effects of Valentine's Day on our store sales. Sadly, the non-exec director isn't very good with Table Calculations in Tableau Desktop so we have promised a data set to allow them to build their own views with all of the calculations pre-computed.

Here's the dashboard the non-exec director wants:

Here's my version

Requirements:

• Input the Data
• Determine if the sales date is pre- or post- Valentine's day
• Work out the running total of sales for each store, restarting after Valentine's day to allow us to compare the two 14 day periods

Output:

• One data set (and dashboard for bonus points - remember no table calcs!)
• Your output date should have:
• 56 rows (57 including headers)
• 5 columns:
• Date
• Store
• Pre / Post Valentine's day flag
• Daily Sales Value
• Running Sales Value (remember this should restart per store and post-Valentine's day)

For comparison, here's our output files. Don't to forget to fill in our participation tracker!

Hint

If you haven't tried to build a Running Total in Prep Builder before then this blog might help