Intro / Purpose
• We need a dashboard to better understand our Taproom Traffic
• Need to be able to see traffic based on different calendar dimensions (month, day, hour)
Data Used
• Datasource: Sales Transactions
• Key Fields: Date, Transactions
Topics
• Summary of total transactions and broken down by busiest month, weekday, and calendar day
• Breakdown of traffic by hour and weekday
• Transactions for each calendar day
Features
• Filter on year
Sample Questions Answered
• What are our traffic patterns in different periods of time?
• What are the busiest and slowest months, weekdays, and hours?
• How can we use previous traffic info to better plan for the future and staff accordingly?
Thanks for viewing!
I created this content hub to offer insights on all things analytics but primarily focused on:
Use Cases
Analytics Best Practices
Tableau Training
Central Coast Analytics Info/Approach
I'd love to hear any feedback you have on these blog posts or if you have suggestions about future topics!
My email is: jeremy@centralcoast-analytics.com