Dashboards people open every week, because they answer real questions.
A good dashboard answers the questions a team asks every week, at a glance, without anyone needing to export data or ask an analyst. Zoho Analytics has the tools to build that, but the difference between a dashboard people use and one they ignore is mostly in the planning. This tutorial walks through building custom dashboards in Zoho Analytics, from choosing the questions to sharing the finished result. It is part of our Zoho Analytics guide.
Start with the questions the dashboard must answer, connect and model the data behind them, build one report per question with the right chart type, add KPI widgets and filters, arrange the most important items top left, then share with permissions and schedule email delivery. Review usage after a month and remove what nobody looks at.
| Audience | Typical questions |
|---|---|
| Leadership | Revenue versus target, cash position, pipeline coverage, customer churn |
| Sales manager | Pipeline by stage, rep performance, win rate, deals at risk |
| Support lead | Open tickets, response times, SLA breaches, satisfaction |
| Marketing | Leads by source, cost per lead, conversion to customers |
Pick five to eight questions per dashboard. More than that, and nothing stands out.
Connect only the modules and tables you need. Extra tables use data rows on your plan and make the workspace harder to navigate.
Connect the sources that answer your questions, such as Zoho CRM, Zoho Books or Zoho Desk, using the built-in connectors. Check the sync frequency on your plan, and note when data last refreshed, so viewers know how current the numbers are.
If you are new to data modelling, start from the prebuilt reports that come with Zoho connectors. They are already joined correctly, and you can copy and adjust them before building your own from scratch.
| You want to show | Use |
|---|---|
| A single number against a target | KPI widget |
| Change over time | Line or area chart |
| Comparison across categories | Bar chart |
| Share of a whole (few parts) | Pie or donut, used sparingly |
| Detail for drill-down | Pivot table or tabular view |
| Stages of a process | Funnel chart |
Create one report per question. Drag fields onto the axes, set the aggregation, such as sum or count, apply default filters, and give each report a title that states the question, such as Pipeline by stage this quarter. Clear titles make dashboards readable without explanation.
Put the most important KPI widgets in a row across the top.
Place the main trend chart below, where the eye goes next.
Group related charts together, such as all pipeline charts in one area.
Keep supporting detail, such as tables, at the bottom.
Leave white space; crowded dashboards are hard to read.
Set sensible default filter values, such as this quarter and all regions, so the dashboard opens with a useful view. Viewers can change filters, but most will rely on the defaults.
Add dashboard-level filters for date range, region, team or product, so one dashboard serves several needs. Enable drill-down so viewers can click a bar to see the records behind it. User filters can also limit each viewer to their own region or team.
| Metric | How it is calculated |
|---|---|
| Win rate | Won deals divided by won plus lost deals in the period |
| Average deal size | Total won value divided by number of won deals |
| Gross margin | Revenue minus cost of goods, divided by revenue |
| First response time | Time from ticket creation to first agent reply |
| Pipeline coverage | Open pipeline value divided by remaining target |
Define each of these once as a formula column, then reuse it across reports so every chart shows the same number.
Not every question deserves a permanent chart. Ask Zia lets viewers type questions in plain language and get a chart or number instantly. Use it for one-off questions, and turn answers that come up repeatedly into dashboard reports.
| Area | Widget or chart |
|---|---|
| Top row | Revenue this month vs target, cash in bank, pipeline value, open support tickets |
| Middle | Revenue trend for 12 months, pipeline by stage |
| Lower | Leads by source this quarter, top 10 customers by revenue |
| Filters | Date range, region, business unit |
| Area | Widget or chart |
|---|---|
| Top row | Closed revenue vs target, pipeline value, win rate, average deal size |
| Middle | Pipeline by stage and close month, revenue trend by month |
| Lower | Rep scorecard table, deals with no activity in two weeks |
| Filters | Date range, team, product line |
Assign an owner to each dashboard. Review usage after the first month, remove reports nobody looks at, and update definitions when the business changes. A smaller dashboard that is trusted beats a large one that is ignored.
Connect your data, build reports for each question you want answered, then create a dashboard and add those reports and KPI widgets, with filters for date range and team.
Use KPI widgets for single numbers against targets, line charts for trends, bar charts for comparisons, funnels for process stages and tables for detail.
Yes. Share dashboards with colleagues, set permissions or user filters so each person sees the right data, schedule email delivery and embed dashboards where appropriate.
Yes. Zoho Analytics lets you connect several sources and join tables on shared IDs, so one dashboard can combine CRM, accounting and support data.
Ask Zia is Zoho Analytics' AI assistant. You type a question in plain language and Zia returns a chart or number from your data.
Most effective dashboards answer five to eight questions. More than that makes it hard to see what matters at a glance.
Yes. User filters and permissions let one dashboard show each viewer only their own region, team or accounts.
Review usage after the first month and then quarterly. Remove reports nobody uses and update definitions when the business changes.
Yes. You can schedule dashboards and reports to be emailed to colleagues on a regular basis, such as every Monday morning, with the latest data.
Start from the prebuilt reports that come with Zoho connectors, then adjust them. Build from scratch only when no prebuilt report is close to what you need.
We plan dashboards around your real questions and build them on clean, well-modelled data.