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?
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