Understanding Zoho Finance Data in Zoho Analytics
Start With a Superb Setup
Expand
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
Collapse
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
Previous Lesson
Next Topic
Identify The Data We Need for This Report
Understanding Zoho Finance Data in Zoho Analytics
Build A “Most Common Items Sold” Report
Identify The Data We Need for This Report
We need data from the following tables:
Items
Invoices
Invoice Items
Previous Lesson
Back to Lesson
Next Topic
Understanding Zoho Finance Data in Zoho Analytics
Build A “Most Common Items Sold” Report
Identify The Data We Need for This Report
close
Pricing
Get Help With Zoho
Free Zoho Learning Paths
Zoho Resources
Zoho Codebase
Zoho App Guides
Login
Previous Lesson
Back to Lesson
Next Topic
