AI Workers for Analytics

Not just Claude: ChatGPT Work and Google Antigravity

The playbook on this page is mostly Claude because that is what I use, but almost none of it is Claude-only. If you already pay for ChatGPT or Google, there is a good chance you already have an AI worker sitting unused inside that subscription.

• ChatGPT Work Comes With Your ChatGPT Go or Pro Subscription. Here Is What It Can Do.ChatGPT Work does the same job as Claude Cowork: reads your CSVs and parquet files, runs the analysis, builds the models, reports and decks. Already included if you are on Go or Pro.
• If You Pay Rs 1,950 a Month to Google, You Already Have Antigravity, a Full AI Coding Agent.Google's agentic coding tool, at raised limits on the paid plan, with a free tier if you want to try it first.
• Google Antigravity Just Launched. For Analysts and Data Scientists: Worth Adding to Your ToolkitThe review at launch - an agentic IDE on VS Code with Gemini 3 Pro, Claude Sonnet 4.5 and GPT-OSS, tested against Cursor and Claude Code on real tasks.

What is new

Recent guides, builds and reading on driving analyst work with an AI, newest first.

• In analytics the SQL was always the easy partSep 2026. Anthropic's data team put a figure on how little of the work is the query itself.
• An Anthropic field marketer built his own weekly sales digest with Claude CodeAug 2026. No engineering background, a Slack digest that reaches every rep on Monday morning, wired to BigQuery over MCP.
• Pulling Yahoo Finance data into your own trackersAug 2026. Power Query, Python-in-Excel through xlwings Lite, VBA, a WEBSERVICE formula, or straight from an agent.
• Send a TREMOR macro chart to the agent sitting on the pageAug 2026. Get a read on the chart with the latest news alongside it, without leaving the dashboard.
• Pull India mutual fund NAVs straight into ExcelAug 2026. Fifty, a hundred or more schemes in a few clicks, free and without signing in. Comes out as a plain CSV.
• An Excel tracker for hundreds of tickers, built with xlwings LiteAug 2026. A downloadable workbook for prices, dividends and earnings calendars, for when WEBSERVICE keeps failing.
• Getting 429s on an Excel WEBSERVICE formula?Aug 2026. WEBSERVICE is a volatile function, so it recalculates on any change anywhere in the sheet. What that does to your rate limit, and what to use instead.

Claude in Excel: build models, dashboards and reports

What Claude actually does once it is inside a spreadsheet - real, one-shot builds from a practitioner's sheet, not demos.

• Claude in Excel Just One-Shotted an XGBoost Response Model - Train-Test Split, AUC, Full WorkupThe one that started it. A full ML model, built in the sheet.
• Claude in Excel Built a 50-Chart India Macroeconomic Dashboard from RBI Data in Under an HourFrom raw RBI data to a live dashboard, no manual charting.
• Claude in Excel - Nifty50 Return Distribution Analysis (30 Days Forward), 2008 to 2026Distribution analysis over 18 years of index data.
• NIFTY50 - 30-Day Forward Return Analysis, Feb 2008 to 2026 (Claude in Excel with Python, Lambda)Forward-return study built with Python + LAMBDA in the sheet.

The working guides: Excel, PowerPoint, what works

The how-to playbooks - Excel and PowerPoint tips, an honest "is it worth it", and how Claude in Excel stacks up against Python-in-Excel.

• Power User Guide to Claude in Excel & PowerPoint - 26 Working TipsThe tips list - what to do, what to avoid.
• Claude in Excel & PowerPoint - Is It Worth It? What Works and What Doesn't PDFHonest limits, not a sales pitch.
• Python in Excel - Claude vs xlwings Lite? Who Wins?When to reach for which.
• Claude in Excel + MCP + xlwings Lite + Claude Code: Pull Data, Build a Model, Validate ItThe four tools working together, end to end.

Pull live data into Excel: databases and quant metrics over MCP

Connect Claude in Excel to your databases and analytics backends over MCP, so numbers come straight into the sheet - no copy-paste, no export dance. Start with the setup guide.

• FRED, 845,000 US Economic Series - Your AI Can Pull Any of Them Directly. No MCP, No Plugin, No Install.The no-MCP route: Claude Cowork and Claude in Excel reach into FRED (and hundreds of other public APIs) and pull any series directly, via their Python sandbox. Just ask.
• MCP Guide for Claude in Excel - and Any MCP Client PDFThe setup guide. Start here to wire Claude to your data.
• QREP in Excel: 81 Risk and Return Metrics Inside Your Sheet Through Claude in ExcelPortfolio quant metrics pulled live into Excel.
• Pull Your Quant Numbers Directly with Claude / ChatGPT in Excel (with MCP)The quants-in-a-sheet pattern.
• Talk to Your Database from Excel - Postgres, DuckDB - via Claude in Excel with MCPQuery millions of rows from inside Excel.
• Talk to Your Database from Excel via Claude & MCP - Part 2Deeper patterns and gotchas.
• Claude in Excel with MCP Connector - Talk to Your Backends from Inside ExcelUsing the MCP connector, step by step.
• Connect Excel to a Database with Tens of Millions of Rows? Tigzig Has 15+ Apps and GuidesThe full map of Excel-to-database options on the site.

Connect Claude to your data: MCP servers and APIs

Claude does not just work on the sheet in front of it - it can pull your live data in. There are two ways, and Claude Cowork opens a second door that Claude in Excel does not have.

• Claude in Excel connects to an MCP server, through the MCP connector. Point it at a server and it can query your data from inside the sheet.
• Claude Cowork can use an MCP server too, and because it can reach the internet it can also call an API endpoint directly. That opens the whole API hub to it.
• The MCP connector is open source. Use mine, or if you would rather not route through someone else, deploy your own in a few minutes.
• Most of the servers and their code are open source. The full endpoints, setup and links live on the hub.

• Database MCP - query Postgres or DuckDB from inside ExcelOpen source. Host your own endpoint.
• Tremor - macro, credit and insurance data (330+ indicators)API is public; the MCP wrapper is open source, so you can run your own wrapper.
• QRep - compare securities on returns, risk and drawdowns (QuantStats behind it)Open source.
• Yahoo Finance - prices and fundamentalsOpen source.
• Technical analysis - a charted report on any tickerAsk for a ticker, get a PDF and web report back.
• Markdown to PDF - have your agent typeset a documentPaste text or send it over MCP. No signup, no key.
• Mutual Fund NAV, India (AMFI) - API only, no MCPPublic API (not open source). Cowork can call it directly.
• Vigil - India corporate red flags - API only, no MCPPublic API (not open source).
• All servers, endpoints and setup -> MCP + API hubThe full directory with every link.

Ask your AI, no clicking: agent-first routes into the data

You do not have to visit a page to use any of this. Point ChatGPT, Claude, Gemini or Meta AI at the site and ask. These are the worked examples, one per dataset or tool.

• Tigzig is built AI-agent first. 300+ assets, and the fastest way in is to ask your AIStart here. Worked prompts for ChatGPT, Claude, Gemini and Meta AI, and why the site is organised for a machine to read.
• Point your agent at api.tigzig.com and it works out which dataset it needsOne address, close to 38 million rows across India and the US, and the agent pulls the file itself.
• Have your AI analyze the cricket data: one pasted instructionThe agent finds the service from the catalog, reads the spec, discovers the tables and runs the SQL. A clean demonstration of the whole route.
• Technical analysis on any ticker without visiting the siteAsk for a ticker, get a charted PDF and web report back through the agent.
• Four routes into QuantStats, depending on what your AI can doA chat that cannot run Python takes one route, an agent with a sandbox takes another. Pick by capability.
• Have your agent typeset a document: Markdown to PDF over MCPPaste text and get a properly set PDF, or let the agent do it as a step in its own work.
• An AI agent inside the TREMOR macro dashboard reads the charts for youSend it the whole dashboard, a selection, or one chart, and get a read with the latest news.

Beyond Excel: Claude as a universal agent

Excel is one front end. The same Claude drives PowerPoint, files, databases, coding and analysis from one place - Cowork and Claude Code. Lighter reading, and the research behind why it works.

• AI Is Not Just Chat: Cowork Apps Are Where the Action HappensWhy Cowork apps - Claude Cowork, and now ChatGPT Work - do the actual work (run code, pull data, build reports and decks), not just chat. The framing for this whole hub.
• Jamie Dimon Uses Claude Code to Generate Dashboards. Are You? You Need an AI Worker or AI Coder, Not an AI Chatter.The distinction the whole hub rests on: a chatbot answers you, an AI worker does the job.
• Claude Cowork Guide PDFClaude Cowork and Claude Code as my universal front end - how the day-to-day workflow actually looks now.
• Claude Cowork Runs a Real Python Sandbox. I Put 37 Million Rows of Mutual Fund NAV Data Through It.What the sandbox will and will not take, tested on a genuinely large file.
• Anthropic's Business Development Team Runs Inbound and Outbound With Claude Cowork. What the Post Actually Says. PDFRoughly five hours a day of inbox and research work moved onto Cowork, read against what it means for a small team.
• Anthropic's Marketing Ops on Using Claude for Campaign Reporting - and How I Do the Same for Small Businesses. Notes on Skills. PDFHow Anthropic runs campaign reporting on Cowork, how I run small-business campaign ops the same way - and why every recurring task should become a skill.
• In analytics the SQL was always the easy part. Anthropic's data team put a figure on it PDFTheir own evals: under 21% accuracy without skills, above 95% with them, same model and same warehouse. Read with a practitioner note at the end.
• AI coders are not just for developers. An Anthropic field marketer built his own weekly sales digest with Claude CodeNo engineering background, a Slack digest wired to BigQuery over MCP. The clearest case yet for a non-developer picking up an AI coder.
• Claude - The Universal Agent PDFThe thesis, as a slide deck.
• Claude Code: Top 10 Tips from Boris ChernyPractical Claude Code habits.
• Agentic Coding and Persistent Returns to Expertise: Anthropic's 400k Sessions, Summarized PDFAnthropic's study on agentic coding and expertise.
• Claude Code Was Getting Dumber. Stopped It Auto-Spawning Sub-Agents. Performance Came BackA real fix from running it hard.

See it for real: files built with Claude in Excel

Actual workbooks Claude built or analyzed. Open them and look at the formulas, charts and models yourself. Best opened in Google Sheets, or download to Excel.

• S&P 500 - 30-day forward-return scenario analysisScenario modelling over 18 years of index data.
• Nifty50 - 30-day forward-return analysisForward returns, Feb 2008 to 2026.
• Nifty50 - return distribution analysisDistribution of 30-day forward returns.
• XGBoost response model - one-shot build in the sheetTrain-test split, AUC, full workup.
• India macro dashboard - 50 charts from RBI data50 indicators across 4 frequencies (weekly to quarterly), RBI and macro data, charted.
• Claude in Excel connected to a database - live data into charts and a tableData pulled live from a backend DuckDB / Postgres warehouse (over MCP), then compiled into a table and charts inside the sheet.
• Folder: all analyses and dashboards built with Claude in ExcelBrowse everything in one Drive folder.

Official docs and resources (Anthropic / Claude)

Straight from Anthropic - the official setup and best-practice pages for Claude in Excel, PowerPoint and Cowork.

• Claude for Excel - official setup and helpInstall the add-in and get started.
• Claude for Excel - product pageWhat it does, which plans.
• Claude for PowerPoint - official helpBuild slides in your template.
• Work across Microsoft 365 - Excel, PowerPoint, Word, OutlookOne task that spans several Office apps.
• Claude Cowork - product pageClaude Code power for knowledge work.
• Getting started with Claude Cowork - best practicesHow to get good results.
• Advancing Claude for Excel and PowerPointLatest capability updates.
• Best practices for Claude in Excel and PowerPoint - webinarAnthropic walkthrough.
• Anthropic research - agentic coding and expertiseWhat decides whether a session succeeds.

FAQ

Short answers. Each one points to a guide or resource if you want to go deeper.

Security, and all the apps

The security side of running AI-coded apps, and the full app directory.

• Security checklist for AI-coded analytics apps108-point checklist from building and running these apps.
• Claude the Hunter-Killer - Claude Runs a Penetration Test on Your Own SetupClaude on the offensive-security side.
• My Public MCP Server Got Hammered - Security Lessons from a Bot AttackWhat running a public MCP server actually teaches you.
• Browse all apps - built with Claude Code, most open sourceAnalytics apps and tools, free.