Primary Blog/Use Case/Analytics Explainer - Wine Sales by State per Capita

Analytics Explainer - Wine Sales by State per Capita

Intro / Purpose
• We need to monitor our sales performance by state to see where we have opportunities to sell more
• States have varying populations, so we don’t expect the same sales volume in each
• Sales by Capita helps determine our sales performance relative to State size

Data Used
• Datasource: Sales Transactions, Census State Population
• Key Fields: Customer State, Sales $ Amount, State population

Topics
• Map showing Sales per Capita by State compare to State size
• Ranking of Sales per Capita by State against average
• Plot of Sales per Capita vs Population by State

Features
• Filter by year and wine group
• Highlight by State

Sample Questions Answered
• What is our average Sales per Capita?
• How does each State rank against the average?
• Do we have any opportunities with larger population states that have a low Sales per Capita currently?


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