This week I wanted to try and keep things simple. I wanted to show how to build a high level dashboard and use the new feature of explain data to produce another.
Requirements
- Dashboard Size 1000 x 800
- 3 Sheets on first dashboard, 2 auto created sheets on the second
- Sub Category Sales by Year and Quarter
- Sub Category Sales This Year v Last Year
- Sub Category Sales by Order ID, with an Average reference line
- Use Explain Data to create the second dashboard
- Add Captions to secondary dashboard sheets.
Dataset
This week uses the superstore dataset for Tableau 2019.1. You can get it here at data.world
Attribute
When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration. Also include the hashtag #WorkoutWednesday2019 in your description to make it searchable!
Share
After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 and tag @AnnUJackson, @LukeStanke, @lorna_eden, and @curtisharris_!
Solution
[embedyt]https://www.youtube.com/watch?v=V8I3MS_O_F0[/embedyt]
I first ran into a problem with getting explain data to run, but I got it now. I think the culprit was defining the random() function as a dimension, then converting it to continuous (that was the trick I found here: https://www.thedataschool.co.uk/michael-mcfadden/tableau-tutorials-build-jitter-plot/). This somehow prevented Explain Data from working. Once I tried how you did it in the video it worked fine.
Thanks! First time using Explain Data!
Hi Lorna, I’ve a problem.
The first dashboard of the WW was easy, but i could’nt make tableau generate the second’s graphs in any way.
Could you give me an hint about how you did it? (even download your solution and trying woud’nt anchive nothing)
Thanks
Nothing to do… simply my tableau desktop doesn’t shows the same explain data graph as yours… even from your workbook 🙁
Hello Marco,
I hope you are doing well.
I got the same behavior when I was working with 2019.4 version, so I tried to use a different version of Tableau.
And guess what! When I used version 2019.3 it worked accordingly to the provided solution.
I know this doesn’t bring a real explanation for the behavior encountered, but as we are talking about machine learning algorithms…I think this is acceptable.
I don’t know. What are your thoughts on this?
Cheers,
Antonio
It’s simply an amazing Tableau class. I’m currently studying for the professional certification and I’m really shocked and grateful for these solutions videos. They will certainly increase my skills faster than never. I can’t thank you all enough for this help.