Zoho Analytics Cheat Sheet

Back to Business IntelligenceUpdated 2026-05-15

Zoho Analytics is a cloud-based, AI-powered business intelligence and data analytics platform designed for small to mid-sized businesses and enterprises. It democratizes self-service BI by combining 500+ native data connectors, drag-and-drop report building, and Zia AI assistant for natural language querying and predictive analytics. Unlike traditional BI tools that require steep technical expertise, Zoho Analytics emphasizes accessibility and affordability — offering pre-built templates, embedded/white-label analytics, and seamless integration with the Zoho ecosystem. The platform's architecture supports data blending across disparate sources, AutoML for predictive modeling, and flexible deployment options (cloud or on-premise). A key differentiator: Zoho Analytics delivers enterprise-grade features — row-level security, scheduled data sync, API extensibility, custom ML models via Python Code Studio — at a fraction of the cost of Tableau or Power BI, making advanced analytics viable for organizations without dedicated data teams.

What This Cheat Sheet Covers

This topic spans 12 focused tables and 163 indexed concepts. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.

Table 1: Data Source ConnectorsTable 2: Zia AI Assistant FeaturesTable 3: Report and Visualization TypesTable 4: Formulas and FunctionsTable 5: Dashboard and Sharing FeaturesTable 6: Data Security and Access ControlTable 7: Data Blending and RelationshipsTable 8: Data Synchronization and RefreshTable 9: API and ExtensibilityTable 10: Machine Learning and Advanced AnalyticsTable 11: Pre-Built Templates and Analytics AppsTable 12: Comparison with Power BI and Tableau

Table 1: Data Source Connectors

Connector	Example	Description
Zoho applications	`Zoho CRM` `Zoho Books` `Zoho Desk`	Native integration with 40+ Zoho apps; auto-generated dashboards on first connect with pre-built reports for each app.
Cloud databases	`Amazon Redshift` `Google BigQuery` `Snowflake`	Direct live connections to cloud data warehouses; supports query pushdown to execute filtering and aggregation at source for performance.
SQL databases	`MySQL` `PostgreSQL` `SQL Server` `Oracle`	Connect via Zoho DataBridge for on-premise/hosted databases; supports incremental sync, full refresh, and custom SQL queries.
NoSQL databases	`MongoDB`	JSON document integration with automatic schema detection; maps nested structures into relational tables for analysis.
File uploads	`Excel (xls, xlsx)` `CSV` `JSON`	Manual or automated file import from local storage or cloud drives (Google Drive, OneDrive, Zoho WorkDrive); auto-detect column types and relationships.
Google services	`Google Sheets` `Google Ads` `Google Analytics`	Real-time sync with Google Workspace apps; OAuth authentication for secure access; bi-directional updates supported for Sheets.
Marketing platforms	`Facebook Ads` `Mailchimp` `HubSpot` `Klaviyo`	Pre-built connectors for campaign performance tracking; automatic metric mapping to standard KPIs (CTR, conversion rate, ROI).

Table 1: Data Source Connectors

Connector	Example	Description
Zoho applications	`Zoho CRM` `Zoho Books` `Zoho Desk`	Native integration with 40+ Zoho apps; auto-generated dashboards on first connect with pre-built reports for each app.
Cloud databases	`Amazon Redshift` `Google BigQuery` `Snowflake`	Direct live connections to cloud data warehouses; supports query pushdown to execute filtering and aggregation at source for performance.
SQL databases	`MySQL` `PostgreSQL` `SQL Server` `Oracle`	Connect via Zoho DataBridge for on-premise/hosted databases; supports incremental sync, full refresh, and custom SQL queries.
NoSQL databases	`MongoDB`	JSON document integration with automatic schema detection; maps nested structures into relational tables for analysis.
File uploads	`Excel (xls, xlsx)` `CSV` `JSON`	Manual or automated file import from local storage or cloud drives (Google Drive, OneDrive, Zoho WorkDrive); auto-detect column types and relationships.
Google services	`Google Sheets` `Google Ads` `Google Analytics`	Real-time sync with Google Workspace apps; OAuth authentication for secure access; bi-directional updates supported for Sheets.
Marketing platforms	`Facebook Ads` `Mailchimp` `HubSpot` `Klaviyo`	Pre-built connectors for campaign performance tracking; automatic metric mapping to standard KPIs (CTR, conversion rate, ROI).