Conversational Analytics using Excel or CSV file
This section explains how to use conversational analytics in Kyvos with Excel or CSV files. It describes the steps for uploading and parsing file data, integrating it with natural-language queries, and generating insights.
Important
The user interaction for Kyvos Dialogs is the same in both the Web and Desktop interfaces. However, the screenshots for the Kyvos Dialogs Desktop and Web applications may differ. For demonstration purposes, the Web-based user interface is used to illustrate the functionality of Kyvos Dialogs.
Enabling conversational analytics using an Excel or CSV file from Kyvos Manager
You can also start conversational analytics using an Excel or CSV file. To upload a file, you need to set a property from Kyvos Manager. To do this, perform the following steps.
Log in to Kyvos Manager.
Navigate to Utilities > Manage Configuration Files.
On the page, click to expand Kyvos > Web Portal > kyvos/jakarta/webapps/kyvos/client/config/
Download the portal.properties file.
In the file, search for allowDataUpload property and set the value to true. By default, the value is set to false.
Upload the file again and you will be able to start conversational analytics with Kyvos Dialogs using Excel or CSV file.
On the Kyvos Dialogs, you will view the plus icon () that allows you to upload the Excel or CSV file.
Working with Excel or CSV File in Kyvos Dialogs
Important
Excel (.xlsx) and CSV (.csv) files are supported, with a maximum file size of 15 MB.
Click the plus icon to upload the Excel sheet or CSV file from your machine. If you have already uploaded a file, click Select Existing file.
Once the file (Excel sheet or CSV) is opened, do the following:
For Excel sheet: You can set the sheet and column settings.
Click Sheet Settings, the Settings -Data pane is displayed.
Note: The Data list is displayed only when an Excel file has multiple sheets.Set the range (start cell and end cell) that you want to use for processing semantic model and for conversation.
Select the Contains header row checkbox if the data file contains column header.
For a CSV file: You can set the file and column settings.
Click the File Settings, the Settings pane is displayed.
Specify the Line Seperator, Field Seperator, Escape Character, Enclosed by, and Skip Top Lines. For more information about these fields, click the i icon.
Select the Contains header row checkbox if the data file contains column header.
Select the Ignore empty rows checkbox to remove the empty rows in the data file.
Select the File name as column to add source file path as column.
Select the Column Settings for Excel sheet or CSV file. The procedure to set the column settings are the same for both the file types.
Select the column that you want to modify.
Modify the name of the column
Specify the data type.
Select the Hide column checkbox to exclude the column from the semantic model. Hidden columns will not be used in the conversation.
Click Next to proceed. The system processes your data and creates a semantic model.
On the Process File dialog, complete the following steps:
Select sheet in case of Excel file. This field is not available if you process a CSV file.
For Excel: The Data checkbox is selected by default. Select the required sheets that is available in Excel file.
Select the existing AI Space or you can create a new space. If you want to create a new space, enter the name of the space.
Enter the Business context that will help the Kyvos Dialogs to understand your data. You can include business context and sheet relationships. For example, This excel file contains data related to bank's customer churn information. This can help doing churn analysis.
Click Process. The following message will appear.
After the semantic model is created, you can specify metadata by clicking the Define Metadata option. The predefined questions related to the selected semantic models will be displayed.
Clicking on these questions instantly generates the answers, further streamlining your analysis.
Alternatively, to add a query manually, enter your query in the input box and click the Submit Query button ().
To modify your input visualization according to your business requirement, use the additional options listed below on this page.
To save your chat session click Save. The chat will be saved in the default folder created with the email ID you used to log in to Kyvos Dialogs app.
To change the name of the chat session or create copy of the chat session, click the Save as option to save the chat. The Save dialog box is displayed.
Click Add Workbook. To do this, click Add Folder. A new folder will be created.
Add a unique name in the Workbook Name text box and click Add. The workbook will be added to the folder. After saving the workbook, the chat session will display in the Recent pane.
Working with existing Excel or CSV File in Kyvos Dialogs
You can choose to update existing data or initiate fresh analysis by creating new AI spaces, providing greater flexibility and improved data management.
When you upload a file that already exists in the Kyvos Dialogs and has been previously processed, a Process File dialog is displayed with options to determine how the process the existing file during upload.
You can choose one of the following actions:
Update the existing semantic models: Selecting this option will check for new or changed data in the file and refresh the semantic models with the latest version.
Click Continue. The Process File dialog is displayed.
Select the column and click Next.
Select the sheet and an AI Space.
Add description for AI Space and click Process. The AI Space or semantic model is updated with the latest column data.
Skip processing and use existing space: Selecting this option will skip processing this file and continue your analysis using the AI space that’s already created for this space.
Process file as new: Selecting this option will process this file again and process new semantic models for separate analysis. For more details about how to process a new file, see the Working with Excel or CSV in Kyvos Dialogs section.