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
Topics
• 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
Features
• 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?
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