Applied Gen AI for Analytics, Data Science & Business

xlwings Lite turns Excel into a live Python app. No Python install on the user's machine. Just a browser-based add-in with code editor, console, and deep Excel integration. It launched earlier this year and I've been using it ever since. When you use AI coders like Claude, Cursor, or Gemini to write xlwings Lite code, they don't know its constraints. They generate desktop xlwings syntax that looks right but fails silently. So I started maintaining an instruction file - a docu

Two Clicks. Zero Setup. No Database, No Server, No Login needed. With 9 LLM options, Python & SQL to torture your data till it confesses. App live here: app.tigzig.com/analyzer See PDF for step-by-step guide What's New I've enhanced the sample datasets in my Database AI app (DATS-4). Previously, the test files were tiny, 50-60 rows. Now there's a full range: 64 rows to 11.8 million rows. File sizes from 14 KB to 1.6 GB. For the 1.6 GB file, setup takes around 9 minutes. Fully

Andrew Ng released an 'Agentic Reviewer' for research papers. Started it as a weekend project.   Think about it. One of the world's top AI researchers is building tools. Deploying them live.   That report you keep generating manually. That dashboard someone keeps asking for. That AI app idea you've been 'meaning to build'.  Why aren't you?   The barrier is gone. AI coders (Claude Code, Cursor) turned domain experts into builders. In Andrew's own words "I've long been fan of C

As Buffett says "As “bandwagon” investors join any party, they create their own truth - for a while"   If you had bought it at it previous rising tide (like now) in 2011 you would be waiting for nearly 10 years till 2020 just for it to reach your buying levels.   If it happens again - and it could - do you have the stomach to wait till 2035 or beyond?   Gold has been on a rise since COVID. Central banks loading up, especially emerging markets after the U.S. froze Russian asse

My analyst and data scientist friends - are you?   And no, I don't mean copy-pasting from ChatGPT. I mean Claude Code, Cursor, Gemini CLI - the agentic AI coding tools.   What they let you do: Build full analytics apps. React frontends, database backends, multi-user dashboards. Deploy on your company VPN or bundle as single-file HTML. Go way beyond Excel/VBA. Large codebases get done many times faster. Even for ML model work, Mito AI works inside Jupyter - proper agentic iter

Get a technical analysis report from my quants agent at: quants.tigzig.com   Open Source. Free. Prompt: 'Run technicals for Bitcoin' You get the report - daily and weekly charts with AI analysis and outlook.   Default model is Gemini 2.5 Flash (~30-45 seconds). Want a deeper analysis? Ask the agent to switch to GPT 5.1 or Claude Sonnet 4.5 or any of the other models. Trade-off: premium models take 2-4 minutes but catch more patterns. Need different timeframes? Just ask the ag

Go to quants-suite.tigzig.com   Enter Yahoo Finance symbol, choose time frames, pick your LLM.   You get a technical analysis report with daily and weekly charts (price, volume, technicals) with AI analysis and outlook - PDF and HTML format. I use this as a 2nd opinion against my own analysis.   LLM choices: Fast tier (~30 seconds): Gemini 2.5 Flash/Lite Mid tier (~1 min): GPT 4.1/Mini/Nano, Haiku 4.5 Premium tier (2-5 mins): GPT 5.1, Claude Sonnet 4.5   The time-quality trad

Process multi-GB files, build datamarts, and run AI-powered analysis entirely in your browser with DuckDB + text-to-SQL AI. When server deployment isn't an option - or will take 6 months and $1M in approvals - this runs off a single HTML file on your laptop. DABX-1 (Database AI, Browser, eXtended) - built on SQL Rooms (sqlrooms.org) by Ilya Boyandin, customized for analytics workflows that need to move fast without infrastructure headaches. Live at app.tigzig.com/sql-rooms. O

Google Antigravity just launched. For analysts and data scientists: If you're already on Cursor/Claude Code, this gives you an extra option when you hit message limits. If you're just starting with AI coders, this is the easiest entry point I've seen.   Free agentic IDE with Gemini 3 Pro, Claude Sonnet 4.5, and GPT-OSS built in. Built on top of VS Code. One-click install with pretty good rate limits.   I've been testing it for low & medium complexity tasks. Solid performance

"𝘌𝘹𝘦𝘤𝘶𝘵𝘦 𝘈𝘚𝘈𝘗. 𝘈𝘱𝘱𝘳𝘰𝘷𝘢𝘭 𝘨𝘳𝘢𝘯𝘵𝘦𝘥. 𝘎𝘰𝘰𝘨𝘭𝘦 - 𝘢𝘨𝘢𝘪𝘯𝘴𝘵 𝘔𝘪𝘤𝘳𝘰𝘴𝘰𝘧𝘵 & 𝘔𝘦𝘵𝘢 past 15 𝘺𝘦𝘢𝘳𝘴, 𝘣𝘦𝘯𝘤𝘩𝘮𝘢𝘳𝘬 𝘷𝘴. 𝘚&𝘗 500, 𝘵𝘦𝘤𝘩𝘯𝘪𝘤𝘢𝘭𝘴 & 𝘲𝘶𝘢𝘳𝘵𝘦𝘳𝘭𝘪𝘦𝘴 𝘧𝘰𝘳 𝘢𝘭𝘭 𝘵𝘩𝘳𝘦𝘦." That's the prompt.   Pass it on to my Quants Agent at quants.tigzig.com Get the full report pack: PDF, HTML and CSV for offline analysis.   Be patient. Takes around 2 mins to generate the full set.   - What you get: Security Perform

Gemini 3 Pro Added to Database AI Suite. Tested Against Claude Sonnet 4.5 and GPT-5.1. Results: Claude still leads. GPT-5.1 is solid. Gemini 3 Pro lands third. ▪️ Performance Scores Multi-step database analysis workflows: Claude Sonnet 4.5: 115 GPT-5.1: 100 Gemini 3 Pro: 90 90-tier: Gemini 2.5 Pro, GPT-4.1, KIMI 2 Thinking 85-tier: Gemini 2.5 Flash, Qwen 3 Max, GLM 4.6, DeepSeek R1 80-tier: Gemini 2.0 Flash ▪️ Model Findings - Claude Sonnet 4.5: Creates multiple segmentation

Two models added to Database AI Suite this week: GPT-5.1 and KIMI 2 Thinking. KIMI 2 Thinking is close to Gemini 2.5 Flash in quality. Costs are higher and more volatile. GPT-5.1 is 20% cheaper than GPT-5 for database execution. Token bloat is down. Default reasoning set to none instead of medium. For advanced analysis planning (single API call, reasoning step): → Gemini 2.5 Flash: strong quality, predictable costs → KIMI 2: similar quality, cost are higher and more volatile