Applied Gen AI for Analytics, Data Science & Business

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.

I’ve released a new field guide covering full campaign build with Python in Excel with AI (xlwings Lite) Campaigns are where analysis and...

I've put up a new guide on my site: Module 02 of my practitioner's series on xlwings Lite, focused on data cleaning.   My go-to for any...

𝐓𝐨𝐨𝐥: A 1,450-line context file. 𝐏𝐮𝐫𝐩𝐨𝐬𝐞: To ensure clean, efficient xlwings Lite code generation. The final output: a curated file with 1,450 lines of tight, most relevant content. ▪ 5 Golden Rules to prevent the most common script failures ▪ 13 sections covering interface, limitations, API integration, security ▪ 6 advanced working examples – database connections, web scraping with LLM, AI schema detection, XGBoost model ▪ Complete what works / what doesn’t

Launching 𝐱𝐥𝐰𝐢𝐧𝐠𝐬 𝐋𝐢𝐭𝐞 𝐏𝐫𝐚𝐜𝐭𝐢𝐜𝐞 𝐋𝐚𝐛 - a free, hands-on guide for Excel professionals who want to use Python in...

I built an AI Technical Analysis Tool to challenge my own charts and spot biases I'm blind to. For my technical analysis I use Trading...

I analyzed 18 years of data for three iconic Indian investments: the Nifty 50, L&T, and the Nifty Midcap 100.   The results on paper are...

Imagine asking ChatGPT: 'Compare TCS, Gold, and Oil for me' ... and getting a full performance report back in seconds.   Quick recap for those who missed it: This tool compares cross market securities - imagine Apple vs TCS vs Gold vs Nifty in seconds. Daily returns, drawdowns, CAGR, Sharpe ratios, CSV downloads - the works. All in one place. In 30 seconds or less. I just added a third way to use it: ChatGPT