What's New in Zoho Analytics
Nov 15, 2018
Zoho Analytics Release 4.0
We are happy to announce the much awaited Zoho Analytics 4.0 public release. Zoho Analytics comes with several exciting features and a fresh look that you will love. Here is a summary of what's new in Release 4.0.
Reporting to Analytics
Zoho Reports is now renamed as Zoho Analytics!! Since we offer in-depth data analytics beyond reporting already, it is only fitting that we make this name change to reflect the power of the product.
Refreshed User Interface
Introducing an all new user interface with the following key features.
All your workspaces in one place
Access all your owned and shared workspaces in one place. You can preview, search, sort and mark favorite for quick access.
Easily access your dashboards
Access Dashboards across all your workspaces. You can preview, filter and search.
View items in the form of preview cards or as a list.
Connect to any data source
Our extensive import options are now grouped for convenience.
Now we support to customize the Theme for overall product.
Learn More about the new Home page.
Easily navigate across all your dashboards, reports and data tables in your workspace.
Search across all your views in this workspace using the global search bar.
Easy inline renaming option for views and workspaces.
Learn More about the new Workspace Explorer.
Dashboards has got a major facelift. Here are the key highlights.
Flexible Dashboard Layouts
Dashboard now supports a flexible m x n layout. With this, you can add multiple views in a single row and have any number of rows.
Note: This feature will be incrementally enabled to users very soon.
Smart Align With
Smart align option, Zoho Analytics will intelligently auto align the components of the Charts embedded in a Dashboard depending on the space available. This removes clutter and enhances readability.
Dashboard Themes Presets
Dashboard now offers a set of cool preset themes along with a range of customization options to increase the visual appeal. Learn more
Merging User Filter
Now you can merge multiple user filters, based on similar text columns from different tables into a single filter. This reduces duplicate filters and enhances user interactions. Learn more
Colored KPI widgets
Now you can add background color for your KPI widgets.
Ask Zia - AI Powered Assistant
Ask Zia is the new search driven analytics assistant. Ask natural questions and get visualization answers. Zia is powered by machine learning and natural language processing.
Users can ask Zia questions such as, "What was my monthly sales for the last year across regions?" Zia converts such questions to complex SQL queries in the back end and gives answers in the form of visual reports, without users having to create them manually.
Zia can auto-blend data and understand questions that span across business apps - e.g., "Give me the revenue per employee" - where revenue comes from the accounting app, and employee count comes from the HR app. Zia comes up with multiple suggestions as possible answers, from which users can choose the relevant report.
Note: This feature will be incrementally enabled to users very soon.
Auto Blending of Data
Data is typically siloed in departmental business apps. If a CEO wants to see this month’s new sales, marketing spend, support tickets got, and invoices sent, she has to go to each of the different apps. Let’s say she also wants to know revenue (data in accounting or CRM app) per employee (data in HR app), it becomes even more arduous.
This is where Zoho Analytics can help with its intelligent auto-blending capability. Zoho Analytics makes it easier to analyze data from across apps by automatically identifying the connection between this apps and making it easy to create interactive reports and dashboards.
Forecasting enables you to easily predict your future data trends. It uses powerful forecasting algorithms which analyzes your past data deeply and comes up with the best forecast for the future. Learn more
Smart Data Alerts
Catch them before it's too late - smart data alerts notifies you of any anomaly or change in your key business metrics as it happens. Configure alerts in a snap, then sit back and relax. Learn More
Customizing Lookup Path
Custom lookup path selection for every report is now possible in instances where multiple lookups are used. Learn more
Report specific formulas
Create a report level formula using "Report Formula" feature to solve a wide range of aggregation challenges.
New Summary Functions for Pivot Table
New Advanced Summary Functions, % of Row in Group, % of Column in Group and Lookup Value, have been included in Pivot Table. Learn more
New Data Connectors
Zoho Analytics enriches its third-party integrations with seven new connectors for popular business apps, expanding the number of connectors to over 100. Each of these connectors come with more than 100 pre-built domain-specific reports and KPI dashboards that users can benefit from right away.
What's analytics without cool visualizations? The following new visualization options have been added to Zoho Analytics to enable you narrate.
Geo Map chart
Zoho Analytics now supports location based analysis with Geo Maps. Learn More
Heat map chart Heat map is pretty useful for categorizing and visualizing data based on factors like volume of occurence, intensity, performance scale (bad to good) etc., Learn More
Zoho Analytics now provides full and half dial charts as widgets in Dashboards. These dial charts are the best to visualize a key metric in comparison to the target. Learn More
New Color Palette
New vibrant color palates have been introduced for charts. Default color palate has also been changed.
Collaborative analytics has taken a new form. No more paperwork or lost email threads. Start commenting in real time and make data driven decisions together. Learn more
Zoho Analytics now enables you to track the activity of all users in your account, from administrator to public users, through Audit Logs. Learn more
Column Level Sharing
You can control what data your users get to see and create reports upon by sharing selective columns alone. Learn More
Zoho Analytics On-Premise
Do you have concerns moving data to the cloud for analytics from in-house databases or applications? We heard you. Zoho Analytics now announces the on-premise edition, which can be installed in both Windows and Linux machines. You can easily setup and use in your private network or private cloud. Download now
Not just the above, Zoho Analytics Release 4.0 is enriched with 50+ new features. As you use the product, you will come across a lot more features. Some key ones:
Try the new Release 4.0. We are sure you will like it. Please do write us your valuable comments/feedback to email@example.com. We would love to hear from you!
Note: We are running webinars explaining about what’s new in Zoho Analytics. Please register here.
Oct 5, 2018
New settings to customize Interactions in Dashboards
As part of Zoho Analytics 4.0 release, we are introducing a new set of options to customize the interactions in Dashboards. You can customize the following:
These options are available only in the new 4.0 interface, which is currently in beta. More exciting dashboard enhancements are awaiting in the Zoho Analytics 4.0 release. Stay tuned...
Sept 19, 2018
New Advanced Summarizing Functions for Pivot Table
Zoho Analytics now supports the following advanced summarizing functions in Pivot Table to enhance the analytical ability.
Click here to learn more about the advanced summary function for pivot.
Sept 14, 2018
Cool Preset Themes for Dashboards
Zoho Analytics now introduces a set of six cool preset themes for Dashboards. These elegant preset themes applies specific colors for every element in the Dashboard with single click. Previous Dashboard themes were single color based.
Customizing themes has also been enhanced now. The entire dialog has been revamped. A new magic band option, to auto suggest matching colors for all elements based on the selected Dashboard background color, has also been added. This allows you to quickly setup a custom theme for your dashboard.
Sept 4, 2018
Share Selective Columns from your Tables
Zoho Analytics now allows sharing selective columns from your data table to your users.
So far when you share a table all the columns will be shared to the user. Now you can choose columns to be shared. This enables you to control what data your users get to see and create reports upon. This will particularly helpful in case you have sensitive data in your table.
Click here to know how to share selective columns.
Merging User Filters
Zoho Analytics now allows you to merge multiple user filters (Text Column) into a single a filter. The below animation shows merging User Filters.
Merging User Filters is pretty useful when you have a dashboard with reports created over similar columns from different tables.
So far, the Dashboard User Filters are bound to a specific column in a table and will only filter the reports based on them.
Now, this can be overridden. You can map similar columns into a single User Filter to filter all reports using the Merged User Filter. This avoids the tedious process of adding multiple User Filter and filtering the dashboard back and forth.
Only user filters which are based on Text column types (categorical columns) can be merged.
Click here to know how to use the Merging User Filters option.
Configure Lookup Path
Zoho Analytics now allows you to customize the join path to be used for a report.
You might have joined multiple tables using various Lookup columns in your Workspace. When creating reports, Zoho Analytics will use the appropriate Lookup column (Lookup path) created between them and generate the report using the auto join capability.
However, in some cases this might not suit your specific need. To address this, Zoho Analytics allows you to choose the appropriate Lookup path between tables to be used for report creation using the Configure Lookup Path option.
To know more on this refer, to the Customise Lookup path section.
Revamped Share and Formula Dialog interface
We have completely changed the User Interface of the share and formula dialogs for an enhanced user experience.
Aug 10, 2018
Important Terminology Change
We are doing an important terminology change in Zoho Analytics today.
Database renamed as Workspace
Database Owner renamed as Workspace Administrators
To learn more on user roles in Zoho Analytics, refer here.
Note: This is just a terminology change and will not affect any of the existing functionality.
If you have any questions please write to us at firstname.lastname@example.org.
Aug 10, 2018
User Access Log Details
Zoho Analytics now enables you to track the activity of all users in your account, from administrator to public users, through Audit Logs.
A reporting database will be automatically created in your account and the activity logs will be updated in this reporting database. You will also get an insightful Dashboard, the Access Log Analytics capturing the essentials of user activity such as Daily Access Trend, Access Count by View Type and by Users, etc.
This option is available for all paid plans of Zoho Analytics. You can choose to log the users' activities in your account using the Access Logs toggle button in the Settings page Audit tab. Click here to learn more on this.
July 31, 2018
Enhancements in Exporting
Exporting in Zoho Analytics has been enhanced with the following options.
Exporting into Zoho Sheet
Now Zoho Analytics supports exporting Tables, Query Tables, Chart, Pivot Table and Summary View into Zoho Sheet.
For Chart, Pivot Table and Summary View you can either choose to export the underlying data or the summarised data of the current view into your Zoho Sheet account.
Exporting Personal Data
Zoho Analytics takes additional care in handling your personal data. From now on, columns marker as personal will be excluded from export by default. This avoids accidentally sharing the personal data with others. However, you can choose to export them by explicitly selecting them.
Emailing Reports - Configurable From Address to handle DMARC
Until now, the reports that you mail from Zoho Analytics will be sent to the specified users from your email address.
In case your receiver has set up DMARC for mail sender validation, then these emails might be blocked or sent to spam. To avoid this, you can choose to mail the reports directly from Zoho Analytics common mail address (email@example.com). You can select this in the From field on Email Setting page.
July 24, 2018
Enhancement for Dashboard User Filters
Now User Filters in the Dashboard will be anchored as you scroll.
So far the User Filters will be available in the place you have added them in the Dashboard. When you scroll down the Dashboard the User Filters will be hidden.
Now they will be retained till the end of the Dashboard while scrolling. This allows you to quickly access the User Filter when required.
Support to Pick Location for Geo Data
Previously you need to provide the Latitude and Longitude of the location to identify the location for Geo data.
From now you can easily pick the location using in the Location Picker map. This also provides a field to search the location in the map. Click here to learn more on this.
Enhancements in Teamworks Projects Advanced Analytics
Now Zoho Analytics allows you to import data from projects across Companies in Teamworks Projects into a single reporting database in Zoho Analytics.
Previously, you need to create multiple databases to import data from each company. Click here for more details.
July 5, 2018
Zoho Analytics Release 4.0 Beta
We are delighted to announce the new Zoho Analytics Release 4.0 Beta. Your favorite Zoho Analytics now comes with a fresh new-look and exciting features.
The new Zoho Analytics 4.0 includes the following features:
Dashboards in Single Click
Geo Map Charts *
Dark Themed Dashboards *
Colored KPI Widgets *
Zoho Analytics on-premise
Those are just some of the major changes done in Release 4.0 Beta. As you use the product to visually analyze your data, you will come across a lot more features.
Not just that, more new exciting features are in development which will be rolled out as part of Release 4.0 public release. Stay tuned...
To access the New Zoho Analytics 4.0, login to your Zoho Analytics account at https://reports.zoho.com, click the Try 4.0 button at the top right. You'll get switched to the 4.0 version (This will not be enabled for trial users. You can avail this once the trial period ends).
Please do give Zoho Analytics 4.0 Beta a try and let us know what you think. Post them to firstname.lastname@example.org. Looking forward to your valuable feedback....
* - Some of the features were already enabled in the existing UI.
June 12, 2018
Split Column Option for Data Preparation
Do you have a concatenated values in your columns which you want to split for making better sense of your data and analytics? A simple example is splitting a customer name column as a first name and last name. The new Split Column option helps you do this exactly.
The Split Column option allows you to split the value in a column into multiple columns based on a separator. This can be applied over the columns with data type Text, Multi-line Text, Email and URL. The split columns will be created as Formula columns with string data type.
To learn how to split a column refer here.
June 7, 2018
Importing from MS Access Database using Import Wizard
Now you can import data from the MS Access database files you have stored in Local Drives, Web URLs, FTP servers or Cloud Drives right from the Import Wizard in Zoho Analytics user interface. Previously MS Access database files can be imported only using the Upload Tool.
You can choose a Single table, Multiple tables or write a custom SQL query to fetch the data for importing. You can schedule the import in periodic intervals if the Access database files are stored in a Web URL or FTP server or Cloud Drives. You can also choose to sync data instantly from your database in a few clicks.
To learn how to import data from MS Access database files, refer here.
Importing from Secured Web URL with OAuth authentication
So far you can import data from authenticated Web URLs which supports only basic authentication system. Now, this has been enhanced to support import data from Web URLs using OAuth 1 and OAuth 2 authentication system.
Click here to learn more on this.
Supporting Dynamic Parameter in Web URL Import
With this update, you can set dynamic values for the parameter while importing data from Web URLs. You can specify Current Date, Current Time and Current Date & Time as a dynamic value for the parameter of the import URL.
Learn how to set dynamic value for import parameter from here.
New Options in Importing from Email Attachment
Zoho Analytics now provides the following new options for Importing from Email attachment:
Learn more on these options from here.
Multi-date Format Support in Imports
Now Zoho Analytics supports importing data with multiple date formats.
Previously, when your data has date columns in different date format, then the column with the first date format alone will be identified as a date while importing. The rest of the columns will be imported as text columns.
Now Zoho Analytics will identify multiple date columns with their corresponding date formats. You can also choose to modify the identified date format for each column using the Change Date Format option in preview menu.
To learn how to configure multiple date format while importing, refer here.
May 28, 2018
In compliance with the General Data Protection Regulation (GDPR) effective from May 25, 2018, we have made the following enhancement in Zoho Analytics.
Follow the below links to know more
New Enhancements in Dashboards
We are excited to introduce 6 Dark themes that will enhance the look and feel of your dashboards. Not just visual appeal, these themes have been designed to increase usability and break monotony on repeated access.
You can customize all the elements in the dashboard theme right from background color to picking report colors specific to the dashboard. This enables you to design a theme that not only captures your organization's branding but also add a character/theme to your reports.
These dark themed layouts are in addition to the existing 6 light themed dashboards. You can quickly check out the theme types using the radio button in the Dashboard Themes dialog.
KPI Widget Themes:
From now on, you can apply themes/background colors for both single numbered and chart type widgets. This new feature further enhance the appearance of widgets in dashboard.
Secure your Private URLs and Exported Files with Password
In this update, we have introduced password protection for exported files and privately embedded views or URLs for enhanced Data security on export and private URLs.
Password Protection for Exported Files
You can choose to protect the exported data from unauthorized access using password protection.
Password protection for Privately Embedded Views and URLs
You can protect your private URLs (without Login) with password. This way you will be able to restrict the access only through password.
May 16, 2018
Geo Maps for Zoho Analytics (Beta)
Zoho Analytics users can now visualize their geographical data using a new chart called Map Chart (also called as Geo Maps). A map chart is a map of a world, continent, or country, with the data values assigned to specific regions through chart visualizations.
At present Zoho Analytics supports 5 types of Geo map types - Map scatter, Map bubble, Map pie, Map bubble pie and Map filled. These map charts will help you in analyzing your geospatial data using cool and interactive chart visualizations. You can easily create a map chart by dragging and dropping the Geographical columns in the X or Y axis of the chart designer.
This feature is currently in public beta testing. Therefore you may encounter certain functional bugs and limitations. We request you to try it out and share your valuable feedback to email@example.com.
Teamwork Desk Advanced Analytics
We at Zoho Analytics are happy to announce the general availability of Teamwork Desk Advanced Analytics. Zoho Analytics advanced analytics for Teamwork Desk enables you to easily analyze your helpdesk data in Teamwork Desk. With this, you can easily slice and dice your helpdesk data, derive key metrics and transform them into actionable insights with the power of analytics.
The integration comes with 75+ reports and dashboards organized functionally as Teamwork Desk overview, agent performance, traffic insights, customer analytics, satisfaction, users, and much more.
April 10, 2018
New Formatting options for Charts and KPI Widgets:
Zoho Analytics now provides flexible formatting options to format all the elements in charts and KPI Widgets.
You can now format all the data elements used in creating a chart. Earlier, Zoho Analytics allowed you to only format the columns dropped in Y-axis shelf. With this new update, you can customize the formatting for all the columns that are used in creating the report. Watch the below video to learn how.
We have added an option to format the 'Group by' column used in creating a KPI widget. With this update, Zoho Analytics allows you to format all the components of a KPI Widget.
New options in Advanced Summary Functions
The widely used Advanced Summary functions in Pivots has become even more powerful with the new set of functions.
Following are the new options that are provided in the Advanced Summary Function:
March 27, 2018
New and Improved Google Analytics Integration
We at Zoho Analytics are happy to announce the new version of Google Analytics advanced reporting connector. This new and improved integration allows you to seamlessly import your website data from Google Analytics into Zoho Analytics. It also allows you to create and import custom modules (modules that are created by combining data from selective dimensions and metrics). That apart, we have extended support to data import from E-commerce and Site speed modules.
These improvements will help marketers slice and dice their site's data, analyze key metrics, and make informed decisions in optimizing SEO/SEM campaigns. The new version comes with a refreshed set of pre-built reports and dashboards that will help you jumpstart your analysis.
Henceforth this integration is available only in the paid plans of Zoho Analytics. Users who have set up this integration from a free plan prior to this release can continue to use their existing integration for free. But, if they wish to set up a new integration they will have to upgrade to any of the paid plans.
Import from Email Attachment
Zoho Analytics now enables you to import data into an existing table from an email attachment. This allows data to be automatically uploaded into a table by just sending an email to a specified email id as an attachment.
This option is available only for Premium and Enterprise plan users.
Support for 'User' module in Zoho Finance apps
Zoho Analytics now supports User module in Zoho Finance apps. From now on, you can import the data from User module either at the time of the setup or by editing the setup.
March 13, 2018
Zoho Campaigns Advanced Analytics
We at Zoho Analytics are very happy to announce the release of Zoho Campaigns Advanced Analytics connector. Zoho Campaigns advanced analytics integration powered by Zoho Analytics enables you to easily analyze your email campaigns and derive great insights.
Product marketers and analysts can slice and dice their campaign data and derive key campaign metrics such as campaigns trend, conversion rate, click rate, open rate, unsubscription trend and do much more.
Zoho Analytics also enables you to blend your campaign data with a variety of data sources and popular business applications such Zoho CRM, Salesforce, Dynamics CRM etc to perform cross-functional analytics.
The connector comes with 50+ hand-picked reports and dashboards organized functionally as campaign & email analytics, email domain analytics, subscriber analytics and list analytics, thus enabling you to easily jumpstart on your analysis.
Feb 22, 2018
SurveyGizmo Advanced Analytics
We at Zoho Analytics are happy to announce the availability of the SurveyGizmo Advanced Analytics integration. This enables you as an analyst to proactively manage, measure and derive analytical insights from your surveys.
Using this connector you can easily slice and dice your survey responses, derive key metrics and transform them into actionable insights with the power of analytics.
The SurveyGizmo Advanced Analytics comes with a unique set of hand-picked reports and dashboards that enables you to easily jumpstart your analytics.
Jan 17, 2018
HubSpot CRM Advanced Analytics
We are happy to announce the general availability of HubSpot CRM Advanced Analytics powered by Zoho Analytics. This integration empowers you with deep sales analytical capabilities and helps you keep track of your Key Sales Performance metrics.
HubSpot CRM Advanced Analytics comes with over 60+ handpicked sales analytics reports and dashboards that you will find of great value. You can also create your own insightful reports to track your sales pipeline, visualize your sales conversion funnels, measure sales team performance, forecast your sales and do much more with ease.
Support for Median and Mode Function
You can now apply Median and Mode function over your columns while creating reports.
To apply this,
Import Data from Multiple Excel Sheets in a Single Click
Zoho Analytics now allows you to import all the data from your Excel workbook in one go. Earlier, users were allowed to select only one sheet at a time while importing data from an Excel workbook.
From now on, when importing an Excel workbook, you can select multiple sheets at a time to be imported into Zoho Analytics (in Step 2 of the Import Wizard). Each sheet will be stored as an individual table in the Workspace.
Unified Data Sources page to manage all your Data Imports
Zoho Analytics has enhanced the Data Sources page to easily view and manage all the import data sources setup in a Workspace. Earlier this feature listed only the advanced analytics connectors in the Workspace. From now on this page will contain details of all the Import Sources in the Workspace.
You can access this page by clicking the Data Sources button in the Explorer tab of the Workspace.
You can view and manage the data sources from this page by selecting them.
Track Resource Usage and Manage Users of a Workspace
Zoho Analytics allows you to keep a track of the resources that are used at the database level. This feature enables you to monitor and manage the resources used for that particular Workspace.
You can view these details by clicking Settings > Resource Usage.
You can perform operations such as adding, deleting and deactivating a user from the Workspace. Click the Users tab to perform these operations.
Option to Schedule Email on the Last Day of the Month
With this update, you can set schedules to email reports on the last day of the month. Earlier if you had to email a report on the last day of the month, you will either have to select 30 or 31.
Now, you can select the option Last day under the Repeat By section. This will automatically send emails on the last day of the month.