Primary Blog/Use Case/Analytics Explainer - Location Summary

Analytics Explainer - Location Summary

Track demand at a specific location


Intro / Purpose
• We need a dashboard to better understand the customer demand in our locations
• Need to be able to see what the demand is like across all of our categories and highest sellers
• Important to understand total volume but also see recent trends; and highlight outliers

Data Used
• Datasource: Consolidated demand
• Key Fields: Date, Product, Product Group, Visits, Sales

Topics
• High level metrics for period of time
• Total demand performance by day and weekly moving average
• Total volume, trends, and outliers for main categories
• Total volume, trends, and outliers for top 5 items in each category

Features
• Filter on timeframe and location

Sample Questions Answered
• How is the overall volume for this location? Trending up or down?
• What categories are doing well, how much of our sales do they make up, and how are the trending?
• Are there any outliers in our main product categories that we should understand and potentially action further?

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