AI Prompts for Data Analysts: 50 Copy-Paste Prompts for SQL, Excel & Power BI

Stop starting from a blank ChatGPT window. 50 ready-to-use prompts to write, debug, and optimize your SQL, Excel, and Power BI work — plus land the interview.

Most analysts use AI wrong. They type "help me with this SQL" and get a generic, half-useful answer — then give up and do it manually anyway.

This guide gives you the exact prompts that get AI to actually think like a data analyst: specific, structured, and ready to paste into ChatGPT or Copilot right now.

WHAT'S INSIDE (50 prompts):

📊 15 SQL Prompts:

Turn plain English into queries, debug errors instantly, optimize slow queries, convert between SQL dialects, write window functions, and more.

📈 15 Excel + Copilot Prompts:

Build formulas from a description, debug broken ones, clean messy data, plan dashboards, write VBA macros, and set up what-if analysis.

⚡15 Power BI + DAX Prompts:

Write DAX measures from scratch, fix filter context bugs, design a star schema, set up row-level security, and optimize slow reports.

🎯 5 Bonus Career Prompts:

Turn your projects into resume bullets, build STAR interview stories, and run a mock interview — all with AI as your practice partner.

Every prompt is copy-paste ready with the exact wording to use, plus a short tip on how to get the best result out of it. No fluff, no theory — just prompts you'll actually use.

WHO THIS IS FOR:

Data analysts, BI developers, and anyone learning SQL/Excel/Power BI who wants to work faster with AI instead of fighting with it.