Primary Blog/Use Case/Analytics Explainer - Tap Density

Analytics Explainer - Tap Density

Intro / Purpose
• We need a dashboard to better understand what we’ve had on draft in the taproom
• Need to be able to see what beers have been selling each day and in what volumes
• Important to highlight where we have an overlap or a gap in a single beer style

Data Used
• Datasource: Taproom Sales Transactions
• Key Fields: Date, Beer, Container, Sales, Margin, Volume

Topics
• Visual representation of daily beer sales
• Sales, Margin, Volume totals for each beer

Features
• Date and Container filter

Sample Questions Answered
• How long has each beer been on draft?
• In a beer category, have we had too much overlap of individual beers or gaps when nothing in the category has been on draft?
• Have any beers sales drastically slowed down and we should offer a special before quality drops?


CCA Logo 3 png

Welcome to the
CCA Content Hub

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

Click Below to Receive 'Enlightened Brewers' Weekly Email and Access to Free Resources