Explore Zoho Analytics

Gain actionable insights from your data and transform your business using the powerful analytical capabilities provided by Zoho Analytics.

Import

Import Data

You can easily import & synchronize data from a wide range of data sources into Zoho Analytics for reporting & analysis. This includes Files, Feeds, Cloud Drives, Local & Cloud databases, NoSQL, Popular Business Applications, Your custom-made applications etc. Learn more

Import Data

Import Options

Data is stored in entities called Tables. You should provide a table name for the data imported into Zoho Analytics. While importing the CSV file, you also have customizing options like modifying the delimiter separating your columns, skipping the top n rows, specifying the comment character etc.

Import Options

Connect to Any Data Source

Synchronize your business data scattered in flat files, feeds, databases, cloud storage services and online/offline applications into Zoho Analytics for analysis & reporting. Data sync is automatic with periodic scheduling. Learn more

Connect to Any Data Source
  • Import Data
  • Import Options
  • Connect to Any Data Source
Import DataImport OptionsConnect to Any Data Source

Charting

Chart Creation

To create a chart, click New -> New Chart View, upon selecting the corresponding table or Query Table.

Chart Creation

Drag & Drop 

Use the intuitive drag and drop based designer to construct the required chart. Drag the columns listed on the left pane and drop them in the appropriate shelves in the design area. Learn more

Drag and Drop

Multiple Y - Axis

You can create charts with multiple Y - axis. Below is an example chart having Sales, Cost & Profit in the Y-axis.

Multiple Y - Axis

Applying Powerful Filters

You can apply powerful filters over charts by selecting the Filters tab in the design area. These are design time filters applied when you create a chart. Learn more

Applying Powerful Filters

Dynamic Filters 

Zoho Analytics allows you to include dynamic filtering capability in the reports you create, known as User Filters. User filters enable your users who access the report, to apply filters on the data displayed. Learn more

Dynamic Filters

Drill Down

With the drill down feature, you can start with a category in the chart to drill down the hierarchy. This helps you to perform exploratory analytics of the category, right away in the same window. Learn more 

Drill Down

Chart Types

Zoho Analytics supports Line, Bar, Combination, Geo Maps, Heat Maps, Scatter, Stacked Bar, Pie, Funnel, Ring, Area, Stacked Area, Web and Table chart types. 

Chart Types
  • Chart Creation
  • Drag & Drop
  • Multiple Y - Axis
  • Applying Powerful Filters
  • Dynamic Filters
  • Drill Down
  • Chart Types
Chart CreationDrag and DropMultiple Y - AxisApplying Powerful FiltersDynamic User FiltersDrill DownChart Types

Pivot Table

Pivot Table 

Variously called as Cross Tabs or Matrix View, Pivot is an important report type useful in data analysis. Zoho Analytics supports a flexible and feature-rich pivot table report type. Learn more 

Pivot Table

Multi-level Pivot View

Multi-level pivots can be created too. In the pivot table, data from multiple columns are summarized.

Multi-level Pivot View

Sorting

The pivot table can be sorted based on any column by either clicking the corresponding sort icon or by selecting the required options from the sort menu. Learn more

Sorting

View Underlying Data

Data underlying any point in the pivot can be seen by clicking on the same. Learn more 

View Underlying Data

Printer-friendly Export

You can export the pivot tables created into CSV, XLS, XLSX, PDF, HTML and image formats. PDF export generates a printer friendly document. 

Printer-friendly Export

Conditional formatting

Conditional formatting feature allows you to visually highlight data cells in a pivot table with different styles based on matching conditions. Learn more

Conditional formatting
  • Pivot Table
  • Multi-level Pivot View
  • Sorting
  • View Underlying Data
  • Printer-friendly Export
  • Conditional formatting
Pivot TableMulti-level Pivot ViewSortingView Underlying DataPrinter-friendly ExportConditional formatting

Dashboards

Dashboards provide a snapshot view of your key business data for quick and easy data analysis / visualization. A dashboard consists of any of the embedded interactive reports along with the rich formatted text.

Dashboards

Drag & drop 

In the dashboard designer, you will see the list of reports on the left pane. Drag & drop any report into the design area to make it a part of the dashboard. Learn more

Drag-and-drop

Flexible Layout Options

You can arrange your reports in a multi-column layout. Use the Expand/Contract option, which comes when you mouse-over a report, to arrange it in your preferred layout. Learn more

Flexible Layout Options

Add Widgets

KPI Widgets are single number view components, with possible trend indicators, providing a quick & easy visualization of any data metric. Learn more

Add Widgets

Add Rich Formatted Text

You can add rich formatted text along with images and URL Links to provide a rich look & feel to your dashboard. Learn more

Add Rich Formatted Text

Export, Share & Publish

You can export a dashboard as a HTML or PDF (printer friendly) file. You can also share, publish, and embed the dashboards. Learn more

Export, Share, and Publish

Themes

Choose from a range of visually appealing themes for your dashboard. Try any of the six themes available, or customize your own theme. Learn more

Themes
  • Dashboards
  • Drag & drop
  • Flexible Layout Options
  • Add Widgets
  • Add Rich Formatted Text
  • Export Share, & Publish
  • Themes
DashboardsDrag-and-dropFlexible Layout OptionsAdd WidgetsAdd Rich Formatted TextExport, Share, and PublishThemes

Sharing & Publishing

Collaboration

Accessible over the web, Zoho Analytics helps you collaborate easily with whoever you choose to - peers, clients, vendors - with its intuitive sharing and publishing options. Learn more

Collaboration

Embed Reports

Zoho Analytics offers a wide variety of publishing options. Reports can be embedded in your websites, intranet, blogs, and other web applications for wider access. All the reports you embed are live and interactive. Learn more

Embed Reports

Permalink

Selecting the Publish-> URL/Permalink for this view gives you a standalone URL to access the particular view selected, directly from the browser. Learn more

Permalink

Make Views Public

You can choose to make the views created in Zoho Analytics public, thus making it accessible to everyone without login. These views can be accessed by knowing the access URL. Learn more

Make Views Public

Slideshow

You will often need to exhibit your reports and dashboards live for a wider audience. The publishing option allows you to display them as slideshows anywhere. Learn more

Slideshow
  • Collaboration
  • Sharing to Group
  • Embed Reports
  • Permalink
  • Make Views Public
  • Slideshow
CollaborationEmbed ReportsPermalinkMake Views PublicSlideshow

More Features

New users will feel comfortable working with Zoho Analytics as the interface closely resembles a spreadsheet. You can use the "spreadsheet-like" interface for easy data collection (add/edit), analysis and reporting.

Interesting Featuresa

Data Blending

Zoho Analytics supports a model called "look up" which is used to merge two different datasets using a common column. This process is known as Joining of tables. Learn more

Data Blending

Formula Engine

Zoho Analytics has simple to use, click & apply pre-built analytical functions. Click on Add->Custom Formula in the table view, to create your own formula column based on your need. Learn more

Formula Engine

Click on Add

Aggregate Formula in the table view, to create your own formula column based on your need.

Click on Add

Query Table

Query the data using SQL to create powerful and flexible reports. You could construct SQL SELECT queries in any of the known database SQL dialects. Click on New -> New Query Tablefor creating your SQL query.

Query Table

Model Diagrams

Model diagrams give a panoramic view of your reporting workspace. They give a visual representation of the tables and their relationships. 

Model Diagrams

Printer Friendly

All the reports can be exported into a printer-friendly PDF files. You can customize the headers and footers in the PDF. You can also generate page numbers and table of contents. Learn more

Printer Friendly

Mobile BI

Access and interact with the reports & dashboards that you create in Zoho Analytics service, on-the-move, from your iOS and Android-powered mobile devices. Learn more

Mobile BI
  • Interesting Features
  • Data Blending
  • Formula Engine
  • Click on Add
  • Query Table
  • Model Diagrams
  • Printer Friendly
  • Mobile BI
Interesting FeaturesData BlendingFormula EngineClick on AddQuery TableModel DiagramsPrinter FriendlyMobile BI