Free guide · 8 min read
6 AI Prompts BI Analysts Actually Use (Stolen From Real Teams)
Most prompt lists are generic ChatGPT junk. These six are different. They came out of real analyst workflows at FinTech and consumer-internet teams in India. Copy them, paste your data, ship your dashboard faster on Monday.
Who this is for
- BI analysts and data analysts with 1 to 5 years experience
- Analytics managers tired of rewriting the same Monday report
- Anyone who wants AI to do the busywork without breaking SQL
Below are 2 of the 6 prompts in full, free, no email needed. The other 4 (the heavier ones that replace 2 hours of busywork each) are in the free PDF guide. Email box at the bottom.
Prompt 1 of 6
Debug broken SQL fast
When to use it: Your query returns the wrong number, no error message, no idea where it broke. Most analysts spend 30 minutes scrolling. This prompt cuts that to 3.
You are a senior BI analyst reviewing a junior analyst's SQL.
Here is the query:
[paste SQL]
Here is what it is supposed to return:
[describe expected output in plain English]
Here is what it actually returns:
[paste 3 to 5 rows of actual output]
Walk me through, line by line, the most likely reason the query is wrong. Give me the top 2 candidate bugs ranked by likelihood. For each, suggest a specific one-line change.Used this last month to find a JOIN that was silently fan-outing rows because a teammate forgot a DISTINCT in a CTE. Five-minute fix instead of an hour.
Prompt 2 of 6
Turn a dashboard into a one-paragraph story
When to use it: Your VP doesn't open Looker. She reads three Slack messages on the way to a meeting. This prompt converts numbers into the one paragraph that gets her attention.
You are summarising a BI dashboard for a non-technical VP.
Here are the key numbers from this week's dashboard:
[paste 5 to 10 key metric values with WoW deltas]
Context (one line each):
- Business: [your product, your market]
- What the VP cares about most: [revenue, retention, etc.]
- What changed this week in the business: [launch, outage, anything notable]
Write a 4 to 6 sentence Slack-ready paragraph. Lead with the one thing she would screenshot. End with one specific question we should investigate. No buzzwords. No "we're seeing strong momentum". Numbers + plain English only.The 'one specific question we should investigate' line is the unlock. It turns the analyst from reporter to thinker in the VP's eyes.
Unlock prompts 3-6
Drop your email, get all 6 in a PDF
You have read the first 2. The other 4 (the heavier ones) plus the full PDF land in your inbox in 30 seconds. One email. No spam. Unsubscribe anytime.
Steal 6 AI prompts senior analysts use to skip busywork
The prompts used alongside analyst teams at Swiggy, Razorpay, Zomato.
- ✦Debug broken SQL fast
- ✦Dashboard to 1-para story
- ✦Explain a metric drop
- ✦Monday-morning TL;DR
- ✦Root cause to hypothesis
- ✦Metric definitions that stick
No spam. One email with your free guide.
How to actually use these
Three rules that separate analysts who get value from AI from analysts who get noise.
- Give context every time. Every prompt above and in the PDF has a placeholder for context. Don't skip it. The same query about a fintech and a quick-commerce app needs different framings.
- Don't paste raw data with PII. Anonymise user IDs, mask emails, never paste customer names. Use synthetic example rows when the structure is what matters.
- Treat the output like a junior analyst's draft. Read it, check the SQL it suggests against your actual schema, never push to prod without review.
Why I built this
I run a 7-person BI team and built The AI Way after watching most analysts use AI like a smarter Google. The real unlock is using it as a second pair of hands on the busywork: the debugging, the summarising, the metric definitions. The thinking stays with you.
These 6 prompts are the ones I use most. They came out of the same workflows we teach in the 3-Hour AI Sprint for Analysts, where you build a full automated reporting pipeline live against a production database.
Rwitapa Mitra, Director BI. Founder of The AI Way.
Ready to build the workflows behind these prompts?
Stop running prompts one at a time. Wire them into n8n.
The 3-Hour AI Sprint for Analysts shows you how to chain these prompts inside a real n8n + Gemini workflow that runs every Monday morning. One Saturday. ₹1,499 Early-Bird.
See the Sprint →