Skip to main content

The AI Way · Blog

Practical AI for analysts

Real workflows, real numbers, no hype. Built and run in real BI work.

South Asian woman data analyst reviewing SQL code on a laptop in a dark home office lit with purple light
AI Skills

How to write and debug SQL with AI (without it hallucinating joins)

AI writes SQL that looks right, runs clean, and returns the wrong number. Here is the practitioner pattern that makes AI-generated SQL trustworthy, plus how to debug it.

Rwitapa Mitra
Rwitapa Mitra·9 min
South Asian woman data analyst standing confidently in a dark office reviewing a glowing dashboard, purple light
Career

Will AI replace data analysts? A BI Director's honest 2026 take

No, and yes. AI will not replace analysts. The analyst who uses AI will replace the one who does not. A no-hype field report on what AI actually takes and what it cannot touch.

Rwitapa Mitra
Rwitapa Mitra·10 min
South Asian woman data analyst comparing three AI tools on screens in a dark office with purple lighting
AI Skills

Gemini vs ChatGPT vs Claude for data work: which to actually use

I use all three every week as a BI Director. Here is the honest, task-by-task breakdown of which AI to reach for: SQL, exploration, big messy schemas, and automation.

Rwitapa Mitra
Rwitapa Mitra·9 min
South Asian woman data analyst building an automation workflow on a screen in a dark office with purple lighting
Automation

n8n for data analysts: the no-code automation starter (with 3 workflows)

n8n is the free, no-code tool that lets an analyst automate the boring half of the job without waiting on engineering. What it is, why it fits analysts, and the first 3 workflows to build.

Rwitapa Mitra
Rwitapa Mitra·8 min
South Asian woman data analyst reviewing a data quality alert on a screen in a dark office with purple lighting
Automation

Automating data quality checks with AI (catch the broken pipeline first)

The worst way to learn your pipeline broke is a stakeholder pointing at a zero. Here is a free AI-assisted data health check that catches NULLs, zeroes, and impossible values before anyone else sees them.

Rwitapa Mitra
Rwitapa Mitra·8 min
Empty modern conference room after meeting, half-erased whiteboard, scattered cups, evening city skyline
BI Strategy

Why your AI pilot failed: the 4 mistakes every BI team makes

4 AI pilots died in 18 months at 3 companies. Same patterns, same 4 mistakes. Here they are, plus what a pilot that actually ships looks like.

Rwitapa Mitra
Rwitapa Mitra·10 min
Overhead flat-lay of a wooden desk with sticky notes, laptop, mug, fountain pen
Prompts

4 AI prompts I use three times a week (as a BI Director)

Four quick ChatGPT and Gemini prompts BI analysts run every week. Then the 6 power-prompts that actually replace busywork, delivered free by email.

Rwitapa Mitra
Rwitapa Mitra·6 min
Indian analyst at floor-to-ceiling window with Bengaluru skyline at twilight, laptop under arm
Career

AI for business analysts in India: what actually changes in your day (2026)

Three things I was told would happen to my analyst job. None did. One thing I never expected: I got 4 hours back. A no-hype field report from India BI.

Rwitapa Mitra
Rwitapa Mitra·9 min
Close-up of smartphone showing a Slack chat with a data answer, purple LED accent
Slack Bots

Natural language to SQL: the Slack bot pattern that stops stakeholders DM-ing you

A small n8n + Gemini Slack bot that answers ad-hoc data questions before they hit your DMs. Plus the clarify gate that stops garbage queries.

Rwitapa Mitra
Rwitapa Mitra·8 min
Indian woman analyst sipping chai at her home office desk on a Monday morning, laptop with purple glow
Automation

How I automated my weekly report and got 4 hours back every Monday

A 90-minute n8n workflow that pulls SQL, writes the narrative with Gemini, drops it in Slack for approval, and auto-sends. Cost: ₹0/month.

Rwitapa Mitra
Rwitapa Mitra·7 min
Free Download

Steal 6 AI prompts senior analysts use to skip busywork

The prompts a practicing Director of BI uses to skip the busywork.

6promptsFree10+ yrs
  • Fix SQL that won't run
  • Turn any dashboard into plain English
  • Pin down why a metric moved
  • Monday-morning TL;DR
  • Root cause to hypothesis
  • Metric definitions that stick

No spam. One email with your free guide.

Preview 2 prompts first →

Ready to build?

Stop reading. Start shipping.

The 3-Hour Champion Sprint takes one Saturday. You leave with 3 working AI workflows pointing at a real database. ₹1,999.

See the Sprint →