Intro / Purpose
• We need a dashboard to better understand our recent finished beer transactions
• Need to be able to break down by beer category, keg vs can, and see impact on inventory
• Important to highlight total volumes but also see recent trends
Data Used
• Datasource: Transactions Detail
• Key Fields: Date, Product, Category, Container, Qty, Cost
Topics
• Total volume by beer category with trending over time
• Total volume by individual beer and trend
Features
• Filter on timeframe
Sample Questions Answered
• What does our recent volume for produced and sold beer look like? Does anything fall outside of normal ranges?
• Have we built or burned too much finished beer inventory recently?
• Is most of our recent production and sales volume with kegs or cans?
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