Business intelligence
Zoho Analytics: the complete independent guide
Zoho Analytics is Zoho's business intelligence tool. It pulls data from your CRM, your accounting, your help desk and outside sources, and turns it into dashboards. This guide explains what it does beyond the reports built into each app, how its plans are counted and how to build numbers your team will trust.
- Best for
- Companies that need reports across several apps or data sources
- Plans
- Free, Basic, Standard, Premium, Enterprise
- Billing
- Per plan, each with a number of users and rows
- Deployment
- Cloud, with an on-premise version available
- Data sources
- Zoho apps, files, databases and hundreds of business apps
What it is
Each Zoho app has its own reports, and they stop at the edge of that app. Zoho Analytics starts where they end. It copies data from several sources into one workspace, lets you join them, and builds reports and dashboards over the combined result: revenue by lead source, margin by salesperson, support tickets against contract value.
It is a complete BI tool, comparable in purpose to Power BI or Tableau: connectors, data preparation, a drag-and-drop report builder, calculated fields, SQL queries for advanced users, scheduled emails, alerts and sharing with fine-grained permissions.
Its advantage is the Zoho connection. The connectors for Zoho CRM, Books, Desk and Projects create ready-made data models and dozens of standard reports in minutes, which would take days to rebuild in a generic tool.
Who it fits
A good fit when
- Your key numbers require data from two or more systems, and someone assembles them in Excel every month.
- You use several Zoho apps and want one dashboard for management.
- You want reports sent automatically to people who never log in.
- You want to embed dashboards in a client portal or in your own product.
Look elsewhere when
- All your questions are about one app. Its built-in reports are probably enough.
- Your company has standardized on Power BI with Microsoft data everywhere. A second BI tool rarely pays.
- Your source data is unreliable. A dashboard shows bad data faster, it does not fix it.
What it does well
- Connectors and sync
- Prebuilt connectors for Zoho apps and many others (accounting, advertising, e-commerce, databases, files), with scheduled synchronization.
- Data preparation and blending
- Clean and reshape data, then join tables from different sources through lookup columns or query tables written in SQL.
- Reports and dashboards
- Charts, pivot tables, KPI widgets and maps assembled by drag and drop, with filters that apply across a whole dashboard.
- Ask Zia
- Type a question in plain language and get a chart. Zia also writes short explanations of what changed in a report.
- Sharing, schedules and alerts
- Share with users or groups, email dashboards on a schedule, and trigger an alert when a number crosses a threshold.
- Embedding
- Publish dashboards inside Zoho apps, websites, portals or your own software, with white-label options on higher plans.
Editions and pricing explained
Zoho Analytics is not priced purely per user. Each plan includes a number of users and a number of data rows, and you add more of either as needed. Rows are usually what decides the plan. Check Zoho's price list for current limits and prices.
| Edition | Made for | What it adds |
|---|---|---|
| Free | Trying the tool on a small data set | Two users and a small row limit, with unlimited reports and dashboards. |
| Basic | A small team with one or two sources | A couple of users, a modest row limit, the main connectors and scheduled sync. |
| Standard | Companies reporting across several apps | More users and rows, more frequent sync and data alerts. |
| Premium | Teams that share reports widely | More users and rows again, logo and branding options and private links. |
| Enterprise | Data-heavy companies | The highest limits, the fastest sync and better performance on large data. |
Before choosing, estimate your rows: count the records in each table you will sync, including history. A CRM with a few years of activities reaches the low limits quickly. Zoho Analytics is also included in Zoho One and in the Ultimate edition of Zoho CRM, with their own limits.
How to set it up properly
Start from the decisions, not the data
List the five to ten numbers management actually uses to decide, with a written definition for each. 'Revenue' means three different things in three departments until someone writes it down.
Connect the sources and check the sync
Add each connector, choose the modules and fields you need rather than everything, and set the sync frequency. Compare a few totals with the source app before building anything.
Model the data once
Create the joins between sources and the calculated fields in one place, so that every report uses the same definitions.
Build one dashboard per audience
Management, sales and support do not need the same screen. Six to ten widgets per dashboard is a good ceiling.
Share, schedule and review
Give each person the narrowest access that works, schedule the weekly email, and after a month remove the reports nobody opened.
Rather have a specialist do it? Talk to TECHMA
Common problems and how to fix them
The numbers do not match the source app
Check, in order: the last sync time, filters hidden in the report, deleted or archived records, currency conversion and time zone. One of the five explains most gaps.
You are running out of rows
Stop syncing modules and fields you do not report on, and limit history to the years you analyse. Upgrade only after that.
Dashboards are slow
Too many widgets on one screen, or reports built on heavy query tables. Split the dashboard and pre-aggregate large tables.
Nobody looks at the dashboards
They answer questions nobody asked. Rebuild from the decisions people make each week, and send the result to them rather than waiting for a login.
Adding AI
Ask Zia answers questions typed in plain language, explains movements in a chart and can forecast a trend. It works best on a clean model with clearly named columns.
A different approach is gaining ground: connecting an assistant such as Claude or ChatGPT directly to your data, so that people ask their question in a chat and receive the analysis, the chart and the explanation without opening a BI tool. For companies whose reporting needs are occasional and varied, this can replace part of a dashboard project. For figures tracked every week, a dashboard remains the better tool.
Questions people ask
What is the difference between Zoho CRM reports and Zoho Analytics?
Zoho CRM reports cover CRM data only. Zoho Analytics combines CRM data with accounting, support, advertising or any other source, and offers far more powerful calculations and dashboards.
Zoho Analytics or Power BI?
Power BI is the stronger choice in a Microsoft environment and for very large data models. Zoho Analytics is simpler to start with, and its Zoho connectors produce usable reports in minutes. If most of your data lives in Zoho, Zoho Analytics is usually the faster route.
Is Zoho Analytics included in Zoho One?
Yes, with limits on users and rows that can be extended.
Can Zoho Analytics connect to data outside Zoho?
Yes. It connects to files, cloud storage, databases and a long list of business apps, and it has an API for anything else.
Want it set up right the first time?
TECHMA implements Zoho for companies in Canada, the United States and abroad: setup, data migration, automation, AI and team training. The first call is free.
Book a free consultationYou will continue on techma.ai