Applied Gen AI for Analytics, Data Science & Business

I went from zero Google usage last year → now ~20% of my work runs on their stack. Here’s my current short list of practical tools. AI Studio (Gemini 2.5 Pro)for code generation & analysis Gemini Buildfor building basic working app Backend APIs (Flash Models)for reliable, low-cost automation Gemini CLImy workhorse for scripting & backend tasks Notebook LMtechnical videos into actionable notes OpalAI micro-apps workflows – assessing..

Dictate logic → AI codes. My Workflow for AI Code Generation. 𝗪𝗵𝗮𝘁 𝗜 𝗰𝗼𝘃𝗲𝗿 1. xlwings Lite - quick start 2. Robust workflow -...

I am sharing my workflow and documents for using AI to reliably generate xlwings Lite Python code. This is not a theoretical guide. It's...

On costing, a hard rule: Published API rates are a fantasy. Always test your specific use case and check the actual charged cost....

Required reading. They are dense, practical guides from builders who have clearly felt the pain of agents going rogue and burning...

Live at: app.tigzig.com . You need top-tier reasoning? Use Claude Sonnet 4. Need the latest model for testing? Swap in GPT-5. Need a...

DATS-4 is live at app.tigzig.com Path: Database AI & SQL Apps -> DATS-4 (Database AI Suite -v4.) The process is direct: 1. Dump your credentials into the text box. The format doesn't matter; a credential-parsing AI step standardizes it to a valid JSON object. 2. Start asking questions in natural language

Supabase: Auth integration. Aiven: Most generous free tier (5GB) and supports both Postgres & MySQL. I use these for creating a 'one-time-use' database for testing to live client projects. See live in action on app.tigzig.com -> Database AI & SQL Apps

↳ 𝗜𝗻𝘀𝘁𝗿𝘂𝗰𝘁: the agent to add derived variables or perform data transformations ↳ 𝗘𝘅𝗲𝗰𝘂𝘁𝗲: the agent writes the SQL and creates a new, transformed table and logs the entire process ↳ 𝗩𝗮𝗹𝗶𝗱𝗮𝘁𝗲: review agent reasoning, SQL and debugging carried out by the agent ↳ 𝗘𝘅𝗽𝗼𝗿𝘁: the finished table to CSV for further analysis from right within the app

Analysis generated by the Quants Agent, one of my open-source tools. The agent was instructed to run a full SPR on these securities. Key...

AI Technical Report for Traders- An Open Source Tool. A supporting input for trade setups. It covers stocks, crypto, and commodities on daily/weekly timeframes, generating a 6-section report (PDF/HTML) with an AI-driven technical outlook.

A 50-page, in-the-trenches document based on 15+ months of live client deployments. This guide bundles my practical lessons, the 8 live apps I built, and the full source code. The Asset Includes: The 50-Page Field Guide (PDF): A practitioner’s rulebook 8 Live Apps (4 Variants): Fully functional apps for testing, including the flagship DATS-4 suite. Full Source Code & System Architecture: All GitHub repositories and architectural diagrams.