Primary Blog/Use Case/Analytics Explainer - Transactions

Analytics Explainer - Transactions

Intro / Purpose
• We need a dashboard to better understand our recent product transactions
• Need to be able to break down by product group with details
• Important to highlight total volumes but also see recent trends

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

Topics
• Total volume by product category with trending over time
• Total volume by Purchased Item and trend
• Total volume by WIP Processed and trend
• Total volume by Beer Sold and trend

Features
• Filter on timeframe

Sample Questions Answered
• What does our recent transaction volume look like? Anything unusual?
• What has had the most volume for purchase receipts and WIP processed?
• What beers have been selling the most? Does that follow normal trend?


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