Primary Blog/Use Case/Analytics Explainer - Finished Beer Inventory

Analytics Explainer - Finished Beer Inventory

Intro / Purpose
• We need a dashboard to better understand our Finished Beer Inventory Balances
• Need to be able to see inventory balances by individual beer and keg vs can
• Important to highlight current inventory data but also see recent trends

Data Used
• Datasource: Inventory Detail
• Key Fields: Date, Product, Category, Sub Category, Container, Qty, Cost,

• Summary of # of items and inventory $’s in each group with trending over time
• Current balance by beer and trend over time
• Current balance for kegs and cans and trends over time

• Filter on timeframe

Sample Questions Answered
• What is our current finished beer inventory and how has that changed over time?
• Do any high selling beers have low inventory that might be a concern?
• Do we have too much or little inventory in kegs or cans for a specific beer?

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:

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