This week’s #workoutwednesday by Ann Jackson was to prepare dataset using Tableau Prep then to design visualisation to show customers spend more on their first or second purchase.
The list of full requirements can be found here but on a high level:
- Create a dataset using Tableau prep which will return customer level first and second order information with regards to sales, no. of categories and no. of products sold in the order
- Dataset will have 9 columns i.e. Customer id, 1st Purchase Date, 2nd Purchase Date, 1st Purchase Sum Sales, 2nd Purchase Sum Sales, 1st Purchase # Categories, 2nd Purchase # Categories, 1st Purchase # Products, 2nd Purchase # Products
- Create scatter plot with First purchase sales vs second purchase sales with 2 strip plots
- Sheets aligned in dashboard using float method
It was good reason to try out Tableau prep for first time and create the dataset for the challenge. Here is how my workflow looked like in Tableau prep:
developing the viz was pretty straight forward with scatter and strip plot but the tricky part was to arrange all the sheets into float order with pixel perfect output. Took a bit of time to arrange but was able to make it at last. Overall, enjoyed working on Tableau Prep. I will be writing on Tableau prep in coming days to explain how it works.
Here is my output for the challenge (Click on Image for interactive version)
Thanks for visiting blog. Please do let me know your feedback and if any particular topic you would like me to write on.
Do subscribe to Tabvizexplorer.com to keep receive regular updates.