Understanding Zoho Finance Data in Zoho Analytics
Start With a Superb Setup
Collapse
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
Expand
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
Expand
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
Expand
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
