Solution to this challenge where we have to visualize weekly and daily data in a single view or you can say a single dashboard, is done by using Gantt Chart.
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.
ticket sales in Spring fest per week
of the Total Sales was done in the Last Weeks of every Fest
more sales in 2019-year events than 2020 Events
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.
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.
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.