Intro / Purpose
• We need a dashboard to better understand our Customer Profile
• Need to be able to see how much volume goes to each customer attribute type
• Important to highlight total volume but also see recent trends
Data Used
• Datasource: Consolidated demand
• Key Fields: Date, Product, Customer, Region, Group, Sales, Margin
Topics
• Categorize each customer into 8 different attributes
• Summary of wholesale customer related measures
• Volume of demand for each attribute type
• Trending of demand in each attribute type
• Detail for each customer
Features
• Filter on timeframe
Sample Questions Answered
• Do we mostly sell to big or small customers? How profitable is each category?
• Do our customers normally order frequently or sporadically? Can we take action to change their behavior?
• Are we doing better with new or old customers, local or out of region, or a certain customer type?
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