
Trino
Fast distributed SQL query engine for big data analytics.

Transform natural language into high-performance analytical expressions and complex data scripts instantly.

Formula AI, integrated within the TIBCO Spotfire environment, represents a significant shift in self-service analytics architecture for 2026. Leveraging a specialized Large Language Model (LLM) framework fine-tuned on the proprietary Spotfire Expression Language and IronPython/R scripts, it enables users to generate complex analytical logic via natural language prompts. Technically, it bridges the gap between semantic business intent and execution-ready code, reducing dependency on data engineering teams for complex data transformations. The architecture is designed with enterprise-grade governance, ensuring that AI-generated formulas adhere to organizational data schemas and security protocols. Positioned as a core component of the 'Spotfire Copilot' suite, it prioritizes accuracy and safety through a 'human-in-the-loop' verification interface. As of 2026, the tool has evolved to support multi-step logic derivation, allowing for the creation of sophisticated calculations such as weighted moving averages or multi-layered conditional logic without manual syntax entry. This capability is pivotal for organizations scaling their data-driven decision-making by empowering non-technical analysts to perform advanced statistical modeling within the familiar Spotfire dashboard environment.
Formula AI, integrated within the TIBCO Spotfire environment, represents a significant shift in self-service analytics architecture for 2026.
Explore all tools that specialize in automated column creation. This domain focus ensures Formula AI by TIBCO Spotfire delivers optimized results for this specific requirement.
Analyzes the existing metadata and column headers to suggest precise column names in formulas without user specification.
Translates English prompts into IronPython or TERR (TIBCO Enterprise Runtime for R) for complex data functions.
Reverse-engineers existing legacy formulas and provides a step-by-step plain English breakdown of the logic.
Uses AI to generate mock data structures based on formula requirements for testing purposes.
Prevents the AI from suggesting scripts that bypass row-level security or utilize restricted functions.
The AI suggests the most appropriate visualization type for the generated calculation result.
Directly links with Spotfire Information Links to understand data relationships before generating join logic.
Deploy TIBCO Spotfire Server (v14.x or higher) with Copilot extensions enabled.
Authenticate via OIDC or SAML 2.0 through the Spotfire Analyst client.
Connect to a validated data source (SQL, Snowflake, or local file).
Open the 'Calculated Column' or 'Data Function' dialog box.
Select the 'Formula AI' icon within the expression editor.
Define the LLM provider (OpenAI, Azure, or Private LLM) in the Administration Manager.
Input a natural language prompt (e.g., 'Calculate 3-month rolling average of sales by region').
Review the AI-generated code and the 'Logic Explanation' pane for accuracy.
Click 'Apply' to execute the script and validate the output in the data table visualization.
Save the expression to the Library for cross-organizational reuse.
All Set
Ready to go
Verified feedback from other users.
"Users praise the tool for its ability to lower the barrier for IronPython scripting, though some note it requires clear column naming conventions for best results."
Post questions, share tips, and help other users.

Fast distributed SQL query engine for big data analytics.

Unlocking insights from unstructured data.

A visual data science platform combining visual analytics, data science, and data wrangling.

Open Source OCR Engine capable of recognizing over 100 languages.

Liberating data tables locked inside PDF files.

Move your data easily, securely, and efficiently with Stitch, now part of Qlik Talend Cloud.

Open Source High-Performance Data Warehouse delivering Sub-Second Analytics for End Users and Agents at Scale.