Primary Blog/Use Case/Analytics Explainer - Hours vs Revenue Analysis

Analytics Explainer - Hours vs Revenue Analysis

Understand how much you sell per hour worked

Intro / Purpose
• We need way to compare our hours worked vs revenue earned to see how efficient we are
• Need to be able to see how the hours/revenue comparison breaks down for our beer and food
• Important to highlight where we currently are but also see recent trends

Data Used
• Datasource: Consolidated demand and Hours
• Key Fields: Date, Category, Sales, Employee, Job Role, Hours

Topics
• Overview of the ratio of sales/hours for Bar and Kitchen
• Long term trending and comparison to prior period
• Recently weekly results and trend line

Features
• Filter on timeframe

Sample Questions Answered
• How does our revenue/hours ratio look? How is it trending?
• Is either our Bar or Kitchen getting more or less efficient recently?

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