ChatGPT Integration

Zoho Analytics integration with ChatGPT makes working with data much easier and saves time spent finding formulas, building complex queries, and discovering datasets. It also helps to find synonyms for data columns to train Ask Zia effectively and enhance natural language processing capabilities.

ChatGPT Integration - Setup

The Account Admin can configure the ChatGPT integration in Zoho Analytics.

Follow the below steps to integrate ChatGPT with Zoho Analytics,

  1. Login to your Zoho Analytics account
  2. Click Organization Settings > Controls / Configurations > Feature Controls > ChatGPT Integration
  3. Enter your ChatGPT secret key
  4. Select the Features you would like to use.
  5. Enable the Allow all other Organization administrators toggle button if you wish to grant access to the other organization adminstrators to use this integration.

  6. Click Apply. ChatGPT integration will now be enabled.

Formula Suggester

Finding the correct formula for analyzing data can be tedious and time consuming. With the Ask Zia: Formula suggester, you can create formulas by asking questions in simple natural language and get intelligent suggestions.

Follow the below steps to use Formula Suggester while creating formula columns,

  1. From the Explorer tab of the Workspace, select the table to which you want to add the formula column.
  2. Select Add > Formula Column option from the toolbar or right click on a column in the table and select  Add Formula > Formula Column
  3. The Add Formula Column wizard will open.
  4. Click the drop down icon of the Zia Formula Suggester.
  5. Enter your question in the Formula field and then click Generate.
  6. The Hints field gives examples of how a question could be asked.
  7. The formula for the defined use case will appear in the Formula Column dialog box. Review the generated formula and make modifications if needed.
  8. Click Save. 

SQL Query Suggester

You can build complex queries by providing inputs in natural language, thus saving a significant amount of time to construct the queries. Users who don't know SQL or have a basic knowledge of SQL can use this feature to construct complex SQL queries.

 Follow the below steps to use Query Suggester while creating formula columns,

  1. Open the desired workspace and click Create from the explorer tab.
  2. Click the drop down icon of the Zia Query Generator.
  3. Enter your question in the Ask Zia: Query Suggester field and selected the related tables.
  4. The Hints field gives examples of how a question could be asked.
  5. Click Generate SQL.
  6. The query for the defined use case will be generated. Review the generated query and make modifications if needed.
  7. Click Save. 

Discover External Datasets

You can easily find public datasets from the web by asking questions, and import the same into Zoho Analytics. This data can then be used for further analysis.

 Follow the below steps to import public datasets,

  1. From the Zoho Analytics homepage, click Import your Data or click Create from the explorer tab and select New Table/Import Data.
  2.  Select Find External dataset using Ask Zia from the listed data sources.
  3. If you haven’t enabled the ChatGPT integration, then ChatGPT Integration wizard will open. Select the features for which you wish to enable the integration and then click Proceed.
  4. The Find External Data wizard will open. Specify the Table Name.
  5. Explain the case for which you are trying to obtain the public dataset in Ask Zia: Find External Data field and then click Generate.
  6. The Data Preview section displays the first few records of the generated data.
  7. Click Create. A table will be created and you can create reports and dashboards over the imported data.
     

Synonym Suggester

You can get alternative suggestions for column names to get conversational insights using NLP capabilities.

Follow the below steps to use Synonyms Suggester while creating formula columns,

  1. Right click the column name and select Ask Zia Settings from the list.
  2. Click Suggest to get the related words.
  3. The synonyms for the selected column will be listed.
  4. Select the words to be listed in the Column Synonyms field.
  5. Click Save.

Frequently Asked Questions

1. Will my data be shared with ChatGPT while using this integration?

No, the data will not be shared with ChatGPT. However, the meta data, like the column names, will be shared while using Synonyms Suggester and SQL query Suggester. Additionally, the data model of the table will be shared while using the Formula Suggester.

2. Who can configure the ChatGPT integration?

The Account Admin can configure the ChatGPT integration.

3.Who can access the ChatGPT integration?

The Account Admin can access the integration and he/she can allow other Organization Administrators to use this integration.

4.Is it possible for me to modify the formulas or SQL queries generated by Zia?

Yes, the Account Admin and the Organization Admin can modify the formulas or SQL queries generated by Zia.

5. I get no responses for a few prompts. Why?

The response generated in the formula field or the query field is provided by ChatGPT. If your prompts do not contain sufficient information or context for the AI model to understand your request, it may not be able to provide a response. Please try rephrasing your prompt with the necessary information and try again.

6. What are the plans that support the ChatGPT integration?

The ChatGPT integration is available for Premium and Enterprise Plans.