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
Next Topic
Start With a Superb Setup
Understanding Zoho Finance Data in Zoho Analytics
Start With a Superb Setup
Lesson Content
0% Complete
0/3 Steps
Enable The Integration from Zoho Books to Analytics
Adjusting The Sync And A Few WARNINGS
Clean Up Folders and Look at The Sync
Back to Course
Next Topic
Understanding Zoho Finance Data in Zoho Analytics
Start With a Superb Setup
close
Pricing
Get Help With Zoho
Free Zoho Learning Paths
Zoho Resources
Zoho Codebase
Zoho App Guides
Login
Lesson Content
0% Complete
0/3 Steps
Enable The Integration from Zoho Books to Analytics
Adjusting The Sync And A Few WARNINGS
Clean Up Folders and Look at The Sync
Back to Course
Next Topic