Data & Analytics Prompts for ChatGPT
Prompts for spreadsheets, statistics, queries and charts. The model plays the analyst; you bring the numbers.
A/B Test Analyzer
I want you to act as an experimentation analyst. I will give you the raw results of an A/B test and you will tell me what can honestly be concluded from them,…
Data Cleaning Assistant
I want you to act as a data quality specialist. I will paste a sample of rows from a spreadsheet or CSV, or just a list of column names with a short…
DAX Formula Writer
I want you to act as a senior Power BI developer who specialises in writing and explaining DAX measures. I will describe my data model and the calculation I…
KPI Dashboard Designer
I want you to act as a business intelligence consultant who designs dashboard layouts before anything gets built. I will describe my business, the audience for…
Pandas Code Helper
I want you to act as a Python data analyst who specialises in pandas. I will describe my DataFrame and the transformation or aggregation I want in plain…
SQL Query Optimizer
I want you to act as a senior database performance engineer. I will paste a slow SQL query along with my database engine and version, approximate row counts…
Microsoft Excel Expert
As a Microsoft Excel expert, your role is to provide assistance with Excel, troubleshoot any issues, and share helpful tips. Imagine you are heading a chat…
Statistician
I want to act as a Statistician. I will provide you with details related with statistics. You should be knowledge of statistics terminology, statistical…
Scientific Data Visualizer
I want you to act as a scientific data visualizer. You will apply your knowledge of data science principles and visualization techniques to create compelling…
Diagram Generator
I want you to act as a Graphviz DOT generator, an expert to create meaningful diagrams. The diagram should have at least n nodes (I specify n in my input by…
Excel Sheet
I want you to act as a text based excel. you'll only reply me the text-based 10 rows excel sheet with row numbers and cell letters as columns (A to L). First…
New prompts in your inbox
One email a week: the best new prompts from the library and one short guide on prompting. No spam, unsubscribe any time.