Ask Zia in Microsoft Teams

Combine the generative AI capabilities of Zoho Analytics' Ask Zia with Microsoft Teams. Get answers to your data queries, access key business insights quickly, predict future trends, and build reports without switching between applications.

Setting up the Zoho Analytics AI Bot - Ask Zia

  1. Login to your Microsoft Teams account.
  2. Click Apps on the side navigation panel.
  3. Search and select Zoho Analytics (Ask Zia). You can also install this from the Marketplace of Microsoft Teams.
  4. A preview dialog will be displayed; Go through the conditions and click Add.
  5. The Zoho Analytics AI Bot, Zia, will open with a welcome card. Sign in to your Zoho Analytics account using Zoho or Microsoft. Refer to the below section to learn how to use Ask Zia.

Using Ask Zia Bot

This section provides guidance on how to effectively interact with Ask Zia to extract business insights and reports. 

  1. Sign in: When you integrate the Ask Zia bot for the first time, sign in to the Zoho Analytics application using a Zoho or Microsoft account.
  2. Select Organization and Workspaces: The Zoho Analytics framework comprises organizations, which contain workspaces. These workspaces include tables where the data resides, and visualizations are created over these tables.
    • Choosing Organizations: Zia needs information about your organizations and workspaces to provide accurate insights. In the prompt area, type "List Organizations"; Zia will then display all the organizations associated with your account. Select a specific organization to ask questions about the data.
    • Choosing Workspaces: Type List Workspaces and select the one for which you would like to get insights. Zia will confirm your selection by displaying information about the workspace selected and the organization to which it belongs.
      Use the commands List Owned workspace or List Shared Workspace for easy identification. Zoho Analytics will list the first ten workspaces for the organization; use the command, "Show More Workspaces", to get the extensive list of all the workspaces.
  3. Creating Views using Ask Zia: Type your questions into the text area, such as requesting a specific KPI metric like "Total sales in the East region" or "What is the Sales prediction for the next 3 months?" Zia will display the report as an inline image. 
    • Follow-up questions: Zia will understand the pattern of the questions and provide suggestions for follow-up questions. Choose the relevant follow up questions.
    • Interactive View: Click "Open Interactive View" to get detailed insights and interact with the data, such as changing chart types and viewing underlying data. Additionally, you can save the generated report to your workspace or add it to your dashboard.
    • Zia Insights: Click Zia Insights to get the key insights from the report.
  4. Viewing Reports: Use the command, List Reports, to get the list of all the reports in the workspace and select a specific report to view it. The report will be displayed as an image. Click Open Interactive View to Apply filters and view underlying data. Click Zia Insights to get the key insights from the report.
  5. Viewing Dashboards: Enter List Dashboards to view the existing dashboards in the selected workspace. 
  6. Remove Access: Enter Revoke to remove the authorization between Microsoft Teams and Zoho Analytics.
  7. Use the command Authorize to interact with Ask Zia again.

The below table consolidates the commands that can be used to interact with Ask Zia.

Action

Command

Example

Integrating Microsoft Teams and Zoho AnalyticsAuthorizeAuthorize
To get the list of organizationsList organizationsList organizations
To get the list of all workspacesList WorkspacesList workspaces
To get the list of all owned workspacesList Owned WorkspacesList owned workspaces
To get the list of all the shared workspacesList shared workspacesList shared workspaces
To get the list of all the tables in a selected workspaceList tablesList tables
To view all the reportsList reportsList reports
To choose a specific reportSelect {Report Name}Select Sales trend report
To view all the dashboards in the selected workspacesList dashboardsList dashboards
To create reportsGive me the {explain the query} reportGive me the total sales in the East region
To view Zia insights for a reportGenerate Zia InsightsGenerate Zia insights
To view the suggested or follow up questions for a reportFollow up questions or suggested questionsFollow up questions
To revoke authorizationRevokeRevoke