Primary Blog/Use Case/Analytics Explainer - Beer Sales Dashboard

Analytics Explainer - Beer Sales Dashboard

Intro / Purpose
• We need a dashboard to quickly show our sales performance based on different metrics
• Need to be able to see how we are performing based on different business segments
• Important to understand performance to individual periods and trends over time

Data Used
• Datasource: Taproom and Wholesale Sales Transactions
• Key Fields: Date, Source, Container, Beer Type, Customer Type, Sales, Margin, Volume

Topics
• Sales, Margin, Volume KPI performance to a prior period
• Trending of each metric over time with comparison periods highlighted
• Each segment’s performance to prior periods

Features
• Choose Current and Comparison Periods
• Visuals are filterable

Sample Questions Answered
• How are we currently doing compared to prior periods? Is it a trend or short-term blip?
• How is the performance of each business segment? Is anything unexpected that we should focus on?
• Based on recent trends, what should we look forward to in future periods?


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