Prompts for Working with Data
Ready-made queries for creating formulas, writing SQL queries, data visualization, and report automation
ChatGPT
Claude
Gemini
Copilot
DeepSeekPower BI DAX Formula
Creates DAX formulas for Power BI reports and dashboards
Format: DAX formula with explanation. Context: You write Power BI DAX formulas. ...
RegEx Data Extractor
Extracts data using regular expressions with match explanations
Format: Regex pattern with examples and explanation. Context: You create regex p...
Statistical Analysis Helper
Performs statistical analysis with interpretation of results
Format: Test recommendation with interpretation guide. Context: You recommend st...
Excel Formula Helper
Creates Excel formulas with step-by-step explanations
Help me with a formula in {platform} (Excel / Google Sheets). Task: {task} Dat...
Pivot Table from Data
Creates pivot table configurations from your data structure
Help me create a pivot table. Platform: {platform} (Excel / Google Sheets / Pyt...
Data Cleaning Script
Creates scripts for cleaning and preprocessing data
Format: Script code with comments. Context: You write data cleaning scripts. Tas...
Dashboard Design for Data
Designs data dashboard layouts with KPIs and visualizations
Design a data visualization dashboard. Domain: {domain} (sales / marketing / fi...
Excel Formula Wizard
Creates complex Excel formulas with nested functions
Format: Formula with explanation. Context: You are an Excel expert creating effi...
Text Data Extraction
Extracts structured data from unstructured text using patterns
Help extract data from text. Text/example: {text} What to extract: {data} (ema...
Google Sheets Automation
Creates automation scripts and formulas for Google Sheets
Format: Apps Script code with comments. Context: You write Google Sheets automat...
Data Visualization Advisor
Recommends the best chart types for your data
Format: Recommendations with pros/cons per visualization type. Context: You reco...
KPI Dashboard Designer
Designs KPI dashboards with metrics and layout
Format: Dashboard layout specification with KPI cards. Context: You design KPI d...
Pivot Table Builder
Builds pivot tables from your data requirements
Format: Step-by-step pivot table creation guide. Context: You create pivot table...
CSV Transformer
Transforms and reshapes CSV data structures
Format: Script with step-by-step transformation. Context: You transform CSV file...
Data Storytelling Narrator
Turns data insights into compelling narratives
Format: Narrative structure with data-backed statements. Context: You craft comp...
SQL Query Optimizer
Optimizes SQL queries for better performance
Format: Original query → Optimized query with explanation. Context: You optimize...
Python Data Analysis
Writes Python scripts for data analysis with pandas and visualization
Write Python code for data analysis. Task: {task} Data description: {data_descr...
Data Transformation & Cleaning
Transforms and cleans data with step-by-step processing
Help me transform and clean data. Source data format: {format} (CSV / Excel / J...
Analyst Prompts — Excel, SQL, and Visualization
Data prompts turn AI into an analyst assistant: creating complex Excel and Google Sheets formulas, writing SQL queries from descriptions, data visualization, and report generation. No need to remember syntax — describe the task in words.
Prompts support various SQL dialects (MySQL, PostgreSQL, ClickHouse), work with complex Excel formulas, and generate code for Python visualizations. Specify the data structure — get a ready query or formula with explanation.
Currently 18 prompts in this category — choose an AI model via the filter to find the right one.