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