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
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.
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
- Import Data
- Import Options
- Connect to Any Data Source
To create a chart, click New -> New Chart View, upon selecting the corresponding table or Query Table.
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
Multiple Y - Axis
You can create charts with multiple Y - axis. Below is an example chart having Sales, Cost & Profit in the 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
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
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
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 Creation
- Drag & Drop
- Multiple Y - Axis
- Applying Powerful Filters
- Dynamic Filters
- Drill Down
- Chart Types
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
Multi-level Pivot View
Multi-level pivots can be created too. In the pivot table, data from multiple columns are summarized.
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
View Underlying Data
Data underlying any point in the pivot can be seen by clicking on the same. Learn more
You can export the pivot tables created into CSV, XLS, XLSX, PDF, HTML and image formats. PDF export generates a printer friendly document.
Conditional formatting feature allows you to visually highlight data cells in a pivot table with different styles based on matching conditions. Learn more
- Pivot Table
- Multi-level Pivot View
- View Underlying Data
- Printer-friendly Export
- Conditional formatting
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.
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
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
KPI Widgets are single number view components, with possible trend indicators, providing a quick & easy visualization of any data metric. Learn more
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
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
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
- Drag & drop
- Flexible Layout Options
- Add Widgets
- Add Rich Formatted Text
- Export Share, & Publish
Sharing & Publishing
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
Sharing to Group
A group is nothing but a collection of email addresses of individuals. Setting a workspace group helps in easy collaboration within a group of people.
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
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
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
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
- Sharing to Group
- Embed Reports
- Make Views Public
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.
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
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
Click on Add
Aggregate Formula in the table view, to create your own formula column based on your need.
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.
Model diagrams give a panoramic view of your reporting workspace. They give a visual representation of the tables and their relationships.
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
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
- Interesting Features
- Data Blending
- Formula Engine
- Click on Add
- Query Table
- Model Diagrams
- Printer Friendly
- Mobile BI