Workout Wednesday 2020 Week 38: Can you Visualize Daily and Weekly Ticket Sales in the Same View?
I took up the Week 38 Challenge and it turned out to be a splendid learning for my Data visualization skills. This time challenge was more intensive from a data modeling perspective and understanding how to manipulate dates; But we also have an extract data file if we want to dive right into the viz part.
Let me start by introducing the Challenge to all, Jami Delagrange, published this amazing challenge where we have to visualize weekly and daily data in a single view or you can say a single dashboard. For the ease of this challenge we were provided a generic ticket sales datasets.
This technique can give us many useful insights in a single view and also great for display in marketing proportions. The weekly view is a quick way to recognize pacing across the event year or YoY event comparison and, daily view to compare sales of launch dates to that of regular event dates.
Requirements of the Challenge
- Dashboard Size: 1600 px by 900 px
- Number of Sheets — 1
- Create a dual axis chart showing Total Daily Ticket Sales and Total Weekly Ticket Sales.
- Set each event to start during the week of the launch date
- Set each event to end during the week of the event date
- Set each week to start on a Monday
- The full 7 days are always available within each week
- Color — For Daily view use color on the basis of important dates (launch date, event date, regular)
- Color — For Weekly view use color money green #7a996d depicting percent of total sales.
♦ Build the data model from scratch —
♦ Jump into the visualization —
Approach to Data Viz
This problem looks very challenging to start, but if someone has the knowledge to make Gantt Charts in Tableau then they will have no issue completing this challenge.
Some New Parameters and Calculated Fields were created in completing this challenge so that we get our desired Gantt chart with appropriate spacing and marks of the size we want. Calculated Fields were created first to calculate weeks from the Date data and then the Total Running sales and the Total sales at the end of an event.
I split the challenge in two halves, firstly where I created the Daily Gantt Chart and second part was to make a dual synchronized axis with the Weekly Gantt Chart and with little use of parameters and filters we get our end result.
Some useful filters are also added to the Dashboard to get full utilization of the viz we create and a legend for the percentage of total sales was also added.
What Do You Get Out of This?
My experience and journey of completing this challenge made me realise that there are hundreds of solution for a particular problem, but being a data analyst/visualizer or a business analyst, you have to find the optimal solution which is easy to understand even for a person with zero visualization skills.
Here, we made Gantt Charts as they were giving us the optimal result when we have to view Daily Sales and Weekly Sales of a particular event. As each block is giving the detail of Total Running sales at that week/day and gives us the information about the selected week or day, which anyone can alter to their needs by editing Tooltip.