Understanding Zoho Finance Data in Zoho Analytics
Start With a Superb Setup
3 Topics
Enable The Integration from Zoho Books to Analytics
Adjusting The Sync And A Few WARNINGS
Clean Up Folders and Look at The Sync
Dive Into the Data
6 Topics
Where Do All These Tables of Data Come From?
Let’s Look at An Example — Invoices and Invoice Items
The Confusing Product ID Field
Example 2 — Credit Notes and Items/Refunds
Example 3 — Payments
Understanding All Other Finance Tables
Build A “Most Common Items Sold” Report
4 Topics
Identify The Data We Need for This Report
Create A Pivot Table Using the Invoice Items Table
Ensure The Tables Are Connected Properly
Finish And Use Your New Report
Begin Improving Your Finance Reporting with SQL Queries
4 Topics
Our Use Case — A Stock On Hand Report
Write and Test the Code
Build A Pivot Table to Summarize the Data
Wrapping It All Up
Previous Topic
Next Lesson
Finish And Use Your New Report
Understanding Zoho Finance Data in Zoho Analytics
Build A “Most Common Items Sold” Report
Finish And Use Your New Report
Make any cosmetic changes.
Go to view mode.
Does your user filter work correctly?
Do you need to add any filters?
Link to other useful Analytics courses for sharing/filters/etc.
Previous Topic
Back to Lesson
Next Lesson
Understanding Zoho Finance Data in Zoho Analytics
Build A “Most Common Items Sold” Report
Finish And Use Your New Report
close
Pricing
Get Help With Zoho
Free Zoho Learning Paths
Zoho Resources
Zoho Codebase
Zoho App Guides
Login
Previous Topic
Back to Lesson
Next Lesson
