2023: Week 37 Order Sequence Analysis

 Created by: Carl Allchin

When data doesn't have a field to set the order in which the records are formed, some easy questions suddenly become a lot harder; this week we are facing that problem. 

I'm trying to analyse some of the wholesale purchases of my books and see how the orders are changing over time - can you help? (this is fake data before my publisher starts to worry about commercial sensitivities).


One Excel workbook but two worksheets of data.


  • Input the data but add a Row ID
    • Try not to type in order in Excel as this is part of the challenge
  • Pull the two tables together
  • Use the file names to create a date 
  • Create a sequence ID for the first order through to the last
  • Create a field to determine how the current order differed to the previous order
    • Call this field 'Bigger Order?'
  • Output the data


6 fields:
  • Customer
  • Book
  • Date
  • Sequence ID
  • Quantity
  • Bigger Order?
18 rows (19 incl. headers)

You can download the output from here.

After you finish the challenge make sure to fill in the participation tracker, then share your solution on Twitter using #PreppinData and tagging @Datajedininja@JennyMartinDS14 & @TomProwse1

You can also post your solution on the Tableau Forum where we have a Preppin' Data community page. Post your solutions and ask questions if you need any help! 

Popular posts from this blog

2023: Week 1 The Data Source Bank

2023: Week 2 - International Bank Account Numbers

How to...Handle Free Text