120 Data Analyst & Business Intelligence AI Prompts
Excel, Google Sheets, SQL, Python, data cleaning, statistics, Power BI, dashboards, forecasting, reporting and remote-career projects.
12 modules · 120 copy-ready prompts · unique DA-001 to DA-120 shortcodes
How to use this library
Search a task or shortcode, choose the module, expand the prompt and copy it. Replace all [BRACKETED] inputs. Shortcodes such as /DA-021 are navigation labels, not native ChatGPT commands. Validate every formula, SQL query, DAX measure, visualization and numerical claim against your real data.
Suggested route: define business KPIs → audit data quality → analyze with SQL/Python → validate statistical claims → build a Power BI dashboard → communicate evidence and limitations. Use only data you are permitted to process.
120 of 120 prompts shown
Explore all prompts
Portfolio tutorial for remote data analyst jobs
Choose an approved public or synthetic dataset, create a data dictionary and KPI definitions, document cleaning decisions, produce reproducible code and a dashboard, then write an evidence-based case study. Clearly distinguish sample figures from measured results. Include your validation checks and screenshots only if you have permission.
Frequently asked questions
Do shortcodes run automatically in ChatGPT?
No. Copy the complete associated prompt; these shortcodes are library identifiers.
Can beginners use these prompts?
Yes. Start with Discovery and Excel, then progress to SQL, Python and BI.
Does AI verify the analysis?
No. Run and check generated calculations and code in the appropriate environment.
