Primary Blog/Use Case/Analytics Explainer - Wine Sales Share

Analytics Explainer - Wine Sales Share

Intro / Purpose
• We need a way to see how individual wines are doing this year vs last year
• It is helpful to see the rank of each wine sales compared to others (share) and how they trend one year to the next
• Sales share by wine varies by state, and it would be good to see which states are low compared to peers

Data Used
• Datasource: Sales Transactions
• Key Fields: Wine, Wine Group, Sales Region, State, Sales $ Amt, Date

• Year over Year change in sales share rank (importance of individual wine sales to the total)
• Each wine share of sales by individual state
• How each state compares against the average and others

• Filter by wine

Sample Questions Answered
• What are our most important wines? Has that changed from last year?
• For each wine, what is the sales share % by state? Where are there opportunities to sell more?
• Do any states have an unusual wine mix that we should look into more?

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