Skip to main content

Varicent ELT Help Center

Varicent ELT Assistant

Abstract

Varicent ELT Assistant is an AI assistant that helps end users perform specific functions within the application.

Important

The Varicent ELT Assistant is available only as a paid subscription add-on. If you are interested in using the Varicent ELT Assistant, please contact your Varicent sales representative.

Varicent ELT Assistant is an AI assistant that helps end users answer almost any query about  Varicent ELT or perform actions within the application.

The Varicent ELT Assistant is available in the pipe. Open your pipe and look for the Assistant icon chatbotAssistanticon.png.

Note

Varicent ELT Assistant is not available to use with all tools. For a list of tools that use Varicent ELT Assistant, see: List of supported tools using Varicent ELT Assistant.

You can use the Assistant in the following ways:

  • General Varicent ELT questions.

  • Answering questions about your pipe by adding tools.

  • Document the pipe and where you can append the information to your pipe documentation.

  • Interacting with the Assistant to create, copy, delete, rename pipes.

  • Navigate to pipes, dashboard, settings, and data pages.

    Note

    The Assistant does not navigate to the destination but provides a link where you can click.

  • Contacting support.

To learn more about the Varicent ELT Assistant, take our Academy course on Exploring Varicent AI Assistant.

Privacy and security

Understanding what data the Varicent ELT Assistant can and cannot access is an important matter of privacy and security. Varicent ELT Assistant has the following guidelines in place:

  • Data uploads:

    • Varicent ELT Assistant does not have access to the data uploaded into Varicent ELT, as seen in the Row Viewer.

  • Pipe and tool configurations:

    • Varicent ELT Assistant can access to pipe and tool configurations.

    • Varicent ELT Assistant can access the configurations, which include the column names and types. If there are two data tools, the Varicent ELT Assistant will only access the data pertaining to those specific two tools, not any others.

    • Varicent ELT Assistant knows which tool the user has selected.

Example questions and responses

The following section shares example questions and responses for the Assistant. If you ask the Varicent ELT Assistant a question that is not related to Varicent ELT, it will respond notifying you that it can only answer questions pertaining to Varicent ELT.

Table 125. Example questions and responses

Ask the Assistant

Sample question

Sample response

Suggestions about Varicent ELT

How do I import data?

To import data into the Varicent ELT application, you can follow these steps:

  1. Upload Data Manually: You can manually upload data files directly into the application. This is useful for one-time data imports or when working with static datasets.

  2. Connect to External Data Sources: Varicent ELT supports integration with various external data sources. You can connect to these sources and import data directly into the application. This is ideal for dynamic datasets that require regular updates

  3. Use Sample Datasets: If you're exploring the application or need sample data for testing, you can use the available sample datasets.

  4. Schedule Data Updates: For data coming from external sources, you can set up schedulers to automate regular data updates, ensuring your data is always current.

If you need assistance with a specific method of importing data, feel free to ask!

Documenting the pipe

Document this pipe in two paragraphs.

The current pipe, named "Untitled," is designed to process customer-related data, focusing on various aspects of customer interactions and service usage. The initial data source is a file input tool with ID bGFw4nQJMzRkFQ, which contains columns such as "Customer ID," "Age," "Gender," "Voicemail Plan," and several metrics related to call usage, including "Day Calls," "Day Mins," "Eve Calls," "Eve Mins," "Night Calls," and "Night Mins." Additionally, the dataset includes financial metrics like "Day Charge," "Eve Charge," and "Night Charge," as well as customer service-related data such as "Weeks Subscribed," "Customer Service Calls," and a boolean column "Canceled" indicating whether a customer has canceled their service.

The pipe is structured to facilitate the analysis of customer behavior and service usage patterns. By examining the call metrics and charges, users can gain insights into customer preferences and potential areas for service improvement. The inclusion of customer service call data and cancellation status allows for a deeper understanding of customer satisfaction and retention challenges. This pipe serves as a foundational setup for further data transformations and analysis, enabling users to derive actionable insights from the customer data.

Creating a pipe, deleting a pipe, copying a pipe or renaming a pipe

Can you create a new pipe named My Pipe?

A new pipe has been created.

Note

The ELT Assistant displays a clickable icon to go directly to the new pipe.

The new pipe named "My Pipe" has been successfully created.

Answering questions by adding tools to your pipe

Count the number of Territory ID by territory name

To count the number of "Territory ID" by "Territory Name," we can use the Aggregate tool.

I've added the Aggregate tool to count the number of "Territory ID" by "Territory Name". You can now see the counts in the new node Aggregate.

Asking what a particular node does

What does the Predictor tool do?

The Predictor node in your pipe is designed to predict a column's value using classification and regression models. In this specific setup, the Predictor node is configured to predict the "Canceled" column, which is a boolean column indicating whether a customer has canceled their service.

Here's a breakdown of its configuration:

  • Label Column: The "Canceled" column is the target for prediction. The model will attempt to predict whether a customer will cancel their service based on the input data.

  • Excluded Columns: The "Age" column is excluded from the model training process, meaning it will not be used as a feature for prediction.

  • Auto Exclude: The auto-exclude feature is enabled, allowing the application to automatically exclude columns that do not help predict the target column. This helps in optimizing the model by removing irrelevant or redundant features.

Overall, the Predictor node is used to analyze patterns in the data and make predictions about customer cancellations, which can be valuable for understanding customer behavior and improving retention strategies.

Navigating to a different area of Varicent ELT

Can you take me to my dashboard?

Navigate to the Dashboards page here.

Note

The ELT Assistant displays a clickable icon to go directly to the new pipe.

You have been successfully navigated to your dashboard. If you need further assistance, feel free to ask!

Contacting support

Can I talk to support about an issue I've been having?

Can I talk to support about an issue I've been having?

The support chat has been opened for you to discuss the issue you've been experiencing. If you need any more assistance, just let me know!



Multilingual feature

ELT Assistant is multilingual. Not only can it answer questions in English, it and can also answer any questions in other languages. For example, you can ask it to document your pipe in French and it will return a French response.

If you ask the ELT Assistant a question in another language other than English, it will return an English response. For example, the prompt of Créer un nouveau tuyau (Create a new pipe), returns a response in English.