Intro / Purpose
• We need a quick way to see our Taproom pricing
• Need to be able to see how each beer is priced and how they compare
• Important to highlight total margin but also see recent trends
Data Used
• Datasource: Consolidated demand
• Key Fields: Date, Beer, Beer Type, Price, Qty
Topics
• High level pricing performance and trends
• Comparison of individual top beer pricing for each category
• Deep dive to see variability over time and how much falls into each price range
Features
• Filter on timeframe
Sample Questions Answered
• What is our total average sales price for a draft and how has that trended over time?
• What are our top beers priced at in each category? Are they consistent?
• For an individual beer, is there a lot of variability in pricing? Why is that happening?
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