Primary Blog/Use Case/Analytics Explainer - Payroll and Operations Expenses

Analytics Explainer - Payroll and Operations Expenses

Intro / Purpose
• We need a dashboard to better understand our main payroll and operating expenses
• Need to be able to see expenses broken down by person/vendor to see how each is trending
• Important to highlight current expense volume but also see recent trends

Data Used
• Datasource: QB Payroll and Expenses
• Key Fields: Date, Account Group, Vendor, Amount

Topics
• Total Payroll and Operations expenses and comparison to previous period
• Scatter plot to show the size, $ change, and % change from previous period
• Detail of top 25 by person/vendor

Features
• Filter on time periods

Sample Questions Answered
• How have our overall expenses been trending? Up or down from recent periods?
• Do any specific categories stand out that we should dive into more?
• Is our spend by vendor what we expect? Any surprises that we should research 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