ThoughtSpot boosts Analyst Studio with AI data prep

ThoughtSpot has released a new generation of Analyst Studio, adding caching and AI-assisted data preparation features that it ties to a broader enterprise push to deploy AI agents and natural language analytics.

The update focuses on new tools for data teams and analysts who prepare datasets for reporting and AI workloads. ThoughtSpot frames the release as a response to an "AI readiness gap", where organisations want AI-driven analytics but run into data quality, governance and cloud cost issues.

Analyst Studio is part of ThoughtSpot's analytics platform for customers using ThoughtSpot Analytics and ThoughtSpot Embedded. The updated package is generally available, with some features rolling out via early access later this year.

Cost controls

A key addition is SpotCache, which creates data snapshots that can be queried within ThoughtSpot without sending every request back to the underlying cloud data warehouse. ThoughtSpot says this can keep analytics performance consistent while making cloud costs more predictable.

SpotCache complements existing connection options, letting teams choose live connections for real-time needs or cached snapshots for defined analytics requirements.

ThoughtSpot also positions SpotCache as support for its natural language search and AI features, aiming to keep business-user workflows steady while data leaders manage cloud data warehouse consumption.

Agentic prep

Another update is what ThoughtSpot calls "agentic data prep", which uses natural language interaction for common preparation tasks that often require specialist skills and repeated iterations.

In the new workflow, analysts can profile datasets, generate queries and troubleshoot schemas through a chat-style interface. ThoughtSpot says this shortens the time from request to an analysis-ready dataset.

"The journey to effective AI starts with data readiness, but for too many teams, that journey is stalled by rigid tools and unpredictable cloud costs," said Anjali Kumari, vice president of product management at ThoughtSpot.

"With the all new Analyst Studio and SpotCache capability, we are reimagining the process and simplifying data readiness. With a native spreadsheet interface and AI agent for data prep, we aren't just improving productivity, we are giving every analyst the power to build the trusted data foundation required for the age of AI," Kumari said.

Spreadsheet workflow

ThoughtSpot is also introducing a native spreadsheet interface inside Analyst Studio, aimed at analysts who routinely work in Excel-style environments but need to stay within governed data workflows.

The interface supports functions such as cohorting and complex formulas. ThoughtSpot describes it as a low-code way to prepare data without leaving Analyst Studio, rather than exporting to an external spreadsheet and re-importing later.

The spreadsheet interface is part of a phased early access rollout and is due later this year alongside the new data-preparation agent.

Data mashups

The refreshed Analyst Studio adds a unified data mashup workflow for blending data across cloud data warehouses, business applications and flat files, including sources such as Google Sheets and Microsoft Excel.

The mashup feature runs within a native SQL IDE in Analyst Studio. ThoughtSpot also pointed to integrated Python and R notebooks as part of its broader tooling for analytics development and data work.

More broadly, the update reflects an industry shift toward moving more data preparation into shared, governed environments. The goal is to reduce duplication across spreadsheet-based analysis, ad-hoc extracts and centralised pipelines, while still letting analysts assemble datasets quickly.

ThoughtSpot is also using the release to highlight the link between analytics products and the next phase of enterprise AI adoption. While vendors are promoting natural language interfaces and agent-style assistants to broaden access to data, organisations still need consistent definitions, trusted datasets and predictable platform costs.

Analyst Studio, including SpotCache and data mashups, is available now for ThoughtSpot Analytics and ThoughtSpot Embedded customers. The spreadsheet experience and data-prep agent are due via early access later this year.