Zoho Analytics update June 2023

Zoho has recently launched a range of enhanced features aimed at enriching the business intelligence (BI) and analytics experience for Zoho Analytics users. With a steadfast commitment to empowering businesses with valuable insights, Zoho aims to facilitate informed decision-making and drive overall success. In this update, we’ll explore the exciting new features introduced in our Zoho Analytics update June 2023.

ChatGPT Integration

Introducing the ChatGPT Integration, an exciting addition that streamlines intricate tasks such as query and formula writing in Zoho Analytics. With this integration, you can conveniently access public datasets without switching tabs, receive assistance in creating formulas and SQL queries, and even receive synonym suggestions for column names. Simplify your data analysis process and maximize productivity with the ChatGPT Integration in Zoho Analytics.

Advanced Analytics for Big Commerce

With Advanced Analytics for BigCommerce, small and medium-sized businesses (SMBs) can unlock valuable insights into customer purchase trends and transaction history. This enables efficient inventory management and empowers personalised purchase experiences. By leveraging these benefits, SMBs can boost revenue, reduce costs, and create a competitive edge in the market.

Click here to discover more about Big Commerce from Zoho

Incremental fetch for databases

The incremental fetch feature in Zoho Analytics is particularly advantageous for small and medium-sized businesses (SMBs). It allows the import of only newly added records from databases, eliminating the need to fetch the entire dataset repeatedly. This capability is especially beneficial when working with large datasets, as it saves valuable time and streamlines data management processes for SMBs.

Discover more about incremental fetch in Zoho Analytics here.

Notify Selected Users

For small and medium-sized businesses (SMBs), the enhanced notification feature in Zoho Analytics provides significant benefits. In the event of continuous import failures, SMBs now have the option to inform all Workspace Admins, Organisation Admins, and Custom Users via email. This broader notification capability ensures that the relevant stakeholders are promptly notified, allowing for quicker troubleshooting and resolution, and minimising any potential disruptions to data import processes.

Emailing Views – CC Support

The addition of cc (carbon copy) functionality in Zoho Analytics brings valuable benefits to SMBs. Now, when emailing views, SMBs can easily include team members, clients, and partners in the loop by using the cc option. This ensures that relevant stakeholders are kept informed without overwhelming their inboxes or making them the primary recipients. It promotes effective collaboration, facilitates seamless communication, and allows for wider dissemination of important insights and reports within the organisation and beyond.

Learn more about emailing reports and dashboards here.

Explain Data – Zia Insights

The Explain Data – Zia Insights feature in Zoho Analytics offers valuable benefits for SMBs. By providing information related to selected data points in reports, it enables SMBs to easily identify significant changes or anomalies in their data. This empowers them to gain deeper insights, uncover hidden patterns, and make informed decisions based on a comprehensive understanding of their data. With Explain Data – Zia Insights, SMBs can quickly pinpoint trends, outliers, or areas of concern, allowing them to take proactive actions and optimise their business strategies for improved performance and results.

Learn more about Zia Insights here.

Ask Zia – Geo System Synonyms

Ask Zia can now understand geo system synonyms such as alpha 2 code and alpha 3 code such as USA, IND and give the right answers.

Learn more about constructing questions for Ask Zia here.

SQLite – Live Connect

Zoho Analytics now supports live connect for SQLite database.

If you want to know more about importing data from SQLite using Zoho Databridge, click here.

Variables Support for Window Functions

You can use variables in window functions to change values dynamically, and observe the impact of different variables on the results.

Learn more about in-built aggregate functions here.

In-built Functions

Zoho Analytics now supports two new in-built functions,

  • To email – This helps you convert text columns in email format to email data type.
  • Round Duration – This helps round off the duration values to given duration scale – seconds, minutes, hours, days.

White Label – Trusted Domain

The Trusted Domains tab allows you to configure the domains where you can embed the Zoho Analytics reports/views.

Find out more about customising white label solutions here.


So, that concludes our Zoho Analytics update June 2023 but make sure to follow us on Linked In to see updates to other Zoho solutions and our blog to see more in depth updates like this one.

Got a question? Get in touch

We know we can’t answer all of your questions here, but feel free to get in touch via our contact form, or call us on 01323 409950