Primary Blog/Use Case/Analytics Explainer - Balance Sheet Summary

Analytics Explainer - Balance Sheet Summary

Intro / Purpose
• We need a dashboard to better understand the components of our Balance Sheet
• Need to be able to see high level categories and break down the most critical (Inventory, Current Assets, Current Liability)

Data Used
• Datasource: Quickbooks Accounts
• Key Fields: Account Group, Account Sub Group, Account, Balance

Topics
• Asset, Liability, and Equity balances listed by main account groups.
• Inventory, Current Asset, and Current Liability broken down into individual account totals

Sample Questions Answered
• What is our Asset, Liability, and Equity profile currently?
• What types of inventory are we investing the most $’s?
• What is the profile of our current assets? What do we have immediate access to?
• What is the profile of our current liabilities? Are we covered by current assets?


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