One year ago, we introduced Analyst Studio, ThoughtSpot’s unified workspace for preparing and managing AI-ready data, with a vision: to transform analysts from report generators into business catalysts. SQL, Python, and visual analysis finally worked together in one workspace, letting data teams move seamlessly between ad-hoc queries and advanced modeling, all while preparing data for the AI revolution we knew was coming.
Organizations embraced the unified workflow, and analysts finally had the tools to match their ambitions. But as adoption grew, one theme stood out: preparing data for AI at scale requires more than unified analytics. It demands intelligent preparation, cost control, and the flexibility to work in the right mode for each task.
Today, we're excited to share the next chapter of Analyst Studio with four new capabilities that complete the vision of end-to-end data readiness within a single platform.
Scaling AI Demands A New Approach for Data Prep
The shift from "Can we do AI analytics?" to "Is our data ready for it?" happened faster than many expected. But AI agents, conversational search, and automated insights aren't just demos anymore—they're production workloads that data teams must support at scale.
This creates two critical challenges.
Cost: AI workloads on live connections can generate thousands of queries against cloud data warehouses, turning into an unpredictable expense.
Preparation: data needs to be modeled, joined across disparate sources, and refined before AI can reliably use it—and doing this quickly becomes the new competitive advantage.
The foundation we built in 2025—native AI-powered SQL IDE, integrated Python notebooks, live connections with extract options—remains essential. But to truly prepare data for AI analytics in production, you need something more.
You need to control cloud costs without restricting access. You need to be able to blend data from anywhere. You need to work in interfaces that match how you think. And you need intelligence built into the preparation process itself.
Four Capabilities that Define the Next Generation of Analyst Studio
Each new capability solves a specific barrier to data readiness, and together they transform Analyst Studio into your complete solution for preparing AI-ready data.
1. SpotCache: Query Without Limits, Control Your Costs
When business users and AI agents can query data freely through natural language search and Spotter, that's exactly what happens. And while that democratization of data is transformative, it can turn cloud data warehouse bills into a moving target.
SpotCache changes the equation. You can create optimized data snapshots that can be queried an unlimited number of times within ThoughtSpot, without touching your cloud data warehouse.
This isn't about choosing between live or cached—it's about having both options and using each where it makes sense. When real-time dashboards stay live and high-volume AI workloads use SpotCache, you stay in control.
The result: Business teams can leverage Spotter and AI agents without hesitation, while data leaders maintain predictable cloud spend. It’s the caching layer that makes unlimited queries practical at enterprise scale.
2. Data Mashups: Unify Data From Anywhere
Business context doesn't respect data boundaries. Customer information lives in your CRM, sales data sits in your warehouse, and budget numbers and product feedback often arrive in spreadsheets. But meaningful analysis requires bringing all of this together.
Data mashups in Analyst Studio make this seamless. Blend data from cloud data warehouses, business applications, Google Sheets, and Excel files directly within the native SQL IDE to create reusable, governed datasets. Unlike queries that must be repeated for every conversation, these unified datasets become a trusted foundation that powers any interaction with AI agents, AI-augmented dashboards, and other analyses across ThoughtSpot.
The benefit: Your users query consistent, pre-validated data with AI agents. And because your dataset works on SpotCache, you also maintain control of cloud costs when users are performing repetitive queries on the same data.
No more running isolated analysis in disconnected tools or updating warehouse schemas to bring data together. With data mashups, you can combine data from anywhere directly in the SQL IDE, accelerating the path to AI-ready data.
3. Native Spreadsheet Interface: Enterprise Governance Meets Familiar Functions
For every analyst comfortable writing SQL, there are dozens more who think in spreadsheets. Their expertise is real; they can build complex cohorts, write sophisticated formulas, and manipulate data with precision. The problem has always been that spreadsheet flexibility and enterprise governance seemed mutually exclusive.
The new native spreadsheet interface in Analyst Studio solves this. You can perform advanced data manipulations exactly the way you're used to—user cohorts, complex formulas, calculations—without leaving the governed environment of ThoughtSpot. Unlike standalone spreadsheets, your work persists as governed datasets that can be reused across the organization, eliminating the download, email, and reupload cycle with Excel files. Your skills transfer directly, and your prepared data becomes immediately available for AI agents to use.
You can now work the way you think: SQL for those who think in queries, Python and R for those who think in code, and now spreadsheets for those who think in cells and formulas. All three modes live together in one platform, all producing AI-ready data.
4. Your AI Agent for Data Preparation
Understanding complex schemas, profiling unfamiliar datasets, cleaning columns, and troubleshooting joins—these tasks are necessary but time-consuming. What if you had an agent to handle this work for you?
That's exactly what this agent will enable. You’ll be able to ask your new data prep agent to profile datasets, generate queries, and troubleshoot complex schemas instantly.
Need to understand the distribution of values in a column? Ask.
Want to know the best way to join two tables? Ask.
Trying to identify data quality issues before they cause problems downstream? Ask.
Available later this year, your data prep agent will bring agentic AI capabilities across your entire data prep workflow—whether you're working in SQL, spreadsheets, or notebooks. This AI agent will autonomously profile data, clean data from multiple sources, detect anomalies, and validate quality, making data prep faster and more reliable.
Want to simplify data prep, control cloud costs, and make your data AI-ready? Schedule your live demo today.
Agentic Data Prep in Action: How It All Works Together in the ThoughtSpot Platform
These capabilities are powerful individually, but together they enable something greater: a complete, intelligent workflow for preparing AI-ready data in the ThoughtSpot platform.
Imagine you need to build a comprehensive customer 360 view for business users to explore with Spotter and AI agents. Here's how it comes together:
Start by using data mashups to blend your CRM data, CDW transactions, and a spreadsheet of customer segment data that your marketing team maintains.
Ask your data prep agentto profile the combined dataset and identify any data quality issues or anomalies before you proceed.
Switch to the spreadsheet interface to create customer cohorts and calculate complex lifetime value metrics using Excel formulas you already know.
Use your data prep agent again to validate your cohort logic and ensure the segmentation makes sense.
Finally, with SpotCache, set your cached data to refresh every Monday at 7 AM, and publish the dataset as a governed ThoughtSpot Model.
Now your business teams can query the new Model unlimited times through Spotter, AI agents can reference it in their autonomous workflows, and you maintain complete control over cloud costs.
This isn't a theoretical workflow—it's what's possible with the next generation of Analyst Studio.
Why This Matters: Impact Across Your Organization
The value of a complete data preparation platform extends far beyond the data team.
For data leaders:
Predictable cloud costs even as AI adoption scales
Reduced vendor sprawl through platform consolidation
Faster time-to-value from AI investments because data is always ready
For analysts and data engineers:
Less time wrestling with tools and more time on strategic analysis
The freedom to work in the interface that makes sense for each task
Confidence that comes from having AI assistance throughout the preparation process
For business teams:
Trustworthy AI that delivers deterministic insights grounded in governed data and business context
Spotter and AI agents they can depend on as true decision-making partners.
Insights that combine information from across the entire business, not just what happens to live in one system
That’s the value of Analyst Studio. It’s not just for analysts, but for every team that depends on data to make decisions.
Get Your Data AI-Ready: Faster, Smarter, and on Your Terms
In the age of AI, data readiness isn't optional; it's foundational. Analyst Studio and SpotCache are how analysts become business catalysts—how you can turn the promise of AI analytics into production reality.
Analyst Studio and SpotCache are available now for all ThoughtSpot Analytics and ThoughtSpot Embedded customers. The native spreadsheet interface and the data prep agent are rolling out in early access over the next few months.
Ready to see it in action? Schedule a demo.
