September 6, 2024

Savant Copilot: Generate Custom Data Functions with Gen AI

By
Chitrang Shah
,,

As someone familiar with the transformative potential of low-code, no-code analytics automation, you understand how it streamlines operations, democratizes data access and accelerates data-driven decision-making. 

Yet, there's always room to push the boundaries further. There’s always scope to amplify your automation efforts even further  — to make good on the promise of truly accessible, comprehensive analytics.

That’s where Savant Copilot comes in — the Transform tool. 

Whether you're looking to refine existing workflows or explore new analytic possibilities, Copilot makes it easy. 

Just describe what you need in natural language, and watch as Copilot transforms your words into precise, executable actions using its advanced Generative AI technology.

What is Savant Copilot? 

Imagine being able to tell your analytics tool what you need in plain English, and it just... understands. 

That's Savant Copilot for you! 

From simplifying complex data queries to cleaning up your datasets and even performing advanced analytics like segmentation and geospatial analytics, Copilot handles it all. It uses cutting-edge Generative AI technology to turn your commands into action, automating the coding and analytics in the background.

Why We Built It

Traditionally, data workers spend a whopping 82% of their time just preparing and managing data, with only about 18% left for actual data analysis​ (Source: IDC)​. 

It’s the classic 80/20 rule, but not the one we like! That's a lot of time we could use elsewhere. 

Copilot flips this on its head, automating the tedious data prep tasks. This frees up your time to dive into deeper analysis and strategic thinking—where the real value lies. 

With Copilot, you're not just working on data; you're making it work for you.

Create Custom Codes and Functions With Copilot

Getting started with Savant Copilot is straightforward and user-friendly. 

Type what you need to be done (e.g. Make text uppercase) in a command and click ‘Ask Savant’

Here’s how you can harness its capabilities: 

  • Begin by typing what you need in a command and click ‘Ask Savant’. 
  • Instantly, Copilot interprets your request and suggests an optimal expression or function. 
  • You can review this recommendation and, with a simple click on ‘Confirm’, apply it directly. 
  • If it's not quite what you were looking for, you can refine your command and ask again, ensuring that the output precisely matches your requirements. 
  • Once satisfied, make sure to hit confirm to finalize your input.
Custom function code to make text uppercase is ready with the help of Savant Copilot

This intuitive interaction not only makes data manipulation accessible but also highly efficient. Whether you're looking to build new columns, update existing fields or craft complex functions, Savant Copilot guides you through each step with ease, transforming how you engage with your data.

Text is now uppercase with the help of Savant Copilot

What You Can Do with Copilot 

Savant Copilot transforms how you interact with your data by leveraging natural language to facilitate the creation and modification of data fields. 

Here’s a closer look at what you can achieve with Copilot:

  • Split or Extract Values: Easily split or extract specific values from a column, allowing you to parse and rearrange data according to your needs.
  • Remove Punctuation: Clean up your data by removing unnecessary punctuation, ensuring that your datasets are neat and consistent.
  • Create Conditional Statements: Utilize IF/THEN/ELSE logic to build dynamic columns that respond to data conditions, enhancing the adaptability of your analysis.
  • Extract Date Information: Pull specific year or other date-related information from a date column, which is essential for time series analysis and trend tracking.
  • Create Email Addresses: Generate email addresses by combining relevant fields or formatting existing data into a standardized email format.
  • Combine Text Fields: Merge multiple text fields to create new columns, perfect for creating comprehensive labels or categorizing information.
  • Text Transformation: Convert text to uppercase to standardize text data, making it easier to perform comparisons and analyses.

How to Get Started with Savant Copilot 

  1. Navigate to Tools: Once you sign up and are logged in, head over to the Tools section of the dashboard.
  1. Add Transform Data Tool: In the Tools section, find and select the “Transform Data” tool to begin shaping your data.
  1. Click on Add Column: Choose the option to add a new column to your dataset, which will allow you to input additional data or derived calculations.
  1. Enter the Column Name: Assign a name to your new column that reflects the data or calculation it will contain.

  1. Activate Savant Copilot: With the new column selected, click on the Savant Copilot option to start automating the process with natural language commands.
  1. Type Your Command: Simply type out what you need in plain English in the command box—for example, “create email from first name initial last name @domain.”
  1. Click on ‘Ask Savant’: After entering your command, click the ‘Ask Savant’ button to submit your request to Copilot.
  1. Confirm the Formula: Copilot will process your command and provide a recommended formula or action. Review this suggestion and if it aligns with your needs, click ‘Confirm’ to proceed.
  1. Review and Confirm Again: Take a moment to review the changes. If everything looks good, confirm again to finalize the addition of the new column.
  1. New Column Created: Once confirmed, the new column will be added to your dataset with the specified calculations or data transformations applied as per your command.

By following these steps, you can leverage Savant Copilot’s capabilities to enhance your data processing tasks efficiently.

Accelerate Analytic Outcomes

Embrace the future of data analysis automation with Savant Copilot.  

It isn't just a tool; it’s your partner in data strategy. By automating the tedious parts of data analysis, Copilot lets you focus on what truly matters — gaining insights and making informed decisions faster than ever. 

Sign up for a free trial today and experience the transformative power of Savant Copilot firsthand!

About the author

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

Chitrang Shah