Primary Blog/Use Case/Analytics Explainer - Customer Margin Explorer

Analytics Explainer - Customer Margin Explorer

Interactive Customer Margin Explorer

Intro / Purpose
• We need way to explorer our wholesale margins
• Need to be able to see how much margin we get across account groups and individual customers
• Important to highlight total margin but also see recent trends

Data Used
• Datasource: Consolidated demand
• Key Fields: Date, Customer, Customer Group, Beer Type, Sales, Cost

• High level performance and trending for Sales, Margin %, Margin $
• Ranking of customers for Margin $ and Margin %
• Sales v Margin relationship for each customer
• Margin trending as compared to peer set

• Filter on timeframe, Account Group, Beer Type

Sample Questions Answered
• What is our overall Sales and Margin trend? Are we getting better or worse?
• When we rank our customers does anything stand out as surprising that we should dive into more?
• How do individual customers compare to their peer set? Are they doing better or worse over time?

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