Excel & data analysis

Excel formulas, SQL queries, reports and data analysis.

325 prompts
Data & AnalyticsFree

Compare Exploratory Data Analysis Options with Clear Trade-offs

A practical prompt for Exploratory Data Analysis that helps the user compare viable options using explicit criteria and trade-offs. It produces a comparison table with recommendation logic while keeping assumptions, evidence, and constraints explicit.

Option Comparison for Exploratory Data Analysis. Your job is to compare viable options using explicit criteria and trade-offs. Produce the working artifact, not a lecture about how to do it.

Data & AnalyticsFree

Review Excel Pivot Analysis Against Practical Best Practices

A practical prompt for Excel Pivot Analysis that helps the user review the current approach against practical best practices. It produces a review with concrete improvements while keeping assumptions, evidence, and constraints explicit.

Best-Practice Review for Excel Pivot Analysis. Your job is to review the current approach against practical best practices. Produce the working artifact, not a lecture about how to do it.

Excel
Data & AnalyticsFree

Dashboard Requirements: Practical Quick-Start Guide

A practical prompt for Dashboard Requirements that helps the user turn the topic into a practical first-pass solution. It produces a actionable starter guide while keeping assumptions, evidence, and constraints explicit.

Quick Start Guide for Dashboard Requirements. Your job is to turn the topic into a practical first-pass solution. Produce the working artifact, not a lecture about how to do it.

CodingFree

SQL-backed Application Example Pack with Reusable Patterns

A practical prompt for SQL-backed Application that helps the user produce realistic examples and reusable patterns. It produces a example pack with reusable patterns while keeping assumptions, evidence, and constraints explicit.

Example Pack for SQL-backed Application. Your job is to produce realistic examples and reusable patterns. Produce the working artifact, not a lecture about how to do it.

Data & AnalyticsFree

Design a Lightweight Excel Formula Engineering Workflow

A practical prompt for Excel Formula Engineering that helps the user design a lightweight workflow the user can start using immediately. It produces a starter workflow with steps and handoffs while keeping assumptions, evidence, and constraints explicit.

Starter Workflow for Excel Formula Engineering. Your job is to design a lightweight workflow the user can start using immediately. Produce the working artifact, not a lecture about how to…

Excel
Data & AnalyticsFree

SQL Window Functions Checklist: What to Verify Before You Finish

A practical prompt for SQL Window Functions that helps the user build a practical checklist that can be used immediately. It produces a prioritized checklist while keeping assumptions, evidence, and constraints explicit.

Checklist Builder for SQL Window Functions. Your job is to build a practical checklist that can be used immediately. Produce the working artifact, not a lecture about how to do it.

Data & AnalyticsFree

Build a Reusable Excel Power Query Template

A practical prompt for Excel Power Query that helps the user create a reusable structure the user can apply repeatedly. It produces a reusable template with instructions while keeping assumptions, evidence, and constraints explicit.

Template Builder for Excel Power Query. Your job is to create a reusable structure the user can apply repeatedly. Produce the working artifact, not a lecture about how to do it.

Excel
Data & AnalyticsFree

Turn Dashboard Requirements into a Step-by-Step Action Plan

A practical prompt for Dashboard Requirements that helps the user convert the goal into sequenced, achievable actions. It produces a step-by-step action plan while keeping assumptions, evidence, and constraints explicit.

Action Plan for Dashboard Requirements. Your job is to convert the goal into sequenced, achievable actions. Produce the working artifact, not a lecture about how to do it.

Planning
Data & AnalyticsFree

Build a Reusable Tableau Dashboard Template

A practical prompt for Tableau Dashboard that helps the user create a reusable structure the user can apply repeatedly. It produces a reusable template with instructions while keeping assumptions, evidence, and constraints explicit.

Template Builder for Tableau Dashboard. Your job is to create a reusable structure the user can apply repeatedly. Produce the working artifact, not a lecture about how to do it.

Data & AnalyticsFree

Clarify Exploratory Data Analysis Requirements Before Execution

A practical prompt for Exploratory Data Analysis that helps the user turn vague requirements into a clear working brief. It produces a clarified requirements brief while keeping assumptions, evidence, and constraints explicit.

Requirements Clarifier for Exploratory Data Analysis. Your job is to turn vague requirements into a clear working brief. Produce the working artifact, not a lecture about how to do it.

Data & AnalyticsFree

Build a Reusable Excel Formula Engineering Template

A practical prompt for Excel Formula Engineering that helps the user create a reusable structure the user can apply repeatedly. It produces a reusable template with instructions while keeping assumptions, evidence, and constraints explicit.

Template Builder for Excel Formula Engineering. Your job is to create a reusable structure the user can apply repeatedly. Produce the working artifact, not a lecture about how to do it.

Excel
Data & AnalyticsFree

Review Exploratory Data Analysis Against Practical Best Practices

A practical prompt for Exploratory Data Analysis that helps the user review the current approach against practical best practices. It produces a review with concrete improvements while keeping assumptions, evidence, and constraints explicit.

Best-Practice Review for Exploratory Data Analysis. Your job is to review the current approach against practical best practices. Produce the working artifact, not a lecture about how to do…

Data & AnalyticsFree

Build a Reusable SQL Data Validation Template

A practical prompt for SQL Data Validation that helps the user create a reusable structure the user can apply repeatedly. It produces a reusable template with instructions while keeping assumptions, evidence, and constraints explicit.

Template Builder for SQL Data Validation. Your job is to create a reusable structure the user can apply repeatedly. Produce the working artifact, not a lecture about how to do it.

CodingFree

Review SQL-backed Application Against Practical Best Practices

A practical prompt for SQL-backed Application that helps the user review the current approach against practical best practices. It produces a review with concrete improvements while keeping assumptions, evidence, and constraints explicit.

Best-Practice Review for SQL-backed Application. Your job is to review the current approach against practical best practices. Produce the working artifact, not a lecture about how to do it.

CodingFree

Generate Practical SQL-backed Application Ideas Without Generic Filler

A practical prompt for SQL-backed Application that helps the user generate varied, realistic options instead of generic suggestions. It produces a ranked idea set while keeping assumptions, evidence, and constraints explicit.

Idea Generator for SQL-backed Application. Your job is to generate varied, realistic options instead of generic suggestions. Produce the working artifact, not a lecture about how to do it.

Data & AnalyticsPro

Data analysis assistant that writes SQL

Give it your database schema (JSON) once, then turn business questions into SQL queries and code to chart the results.

The ChatGPT assistant that helps with data analysis. The assistant takes a database schema in the JSON format as initial prompt and generates SQL queries using business questions as…

DevOpsDatabases
CodingPro

Turn your data into an SQL table

Paste any data and get the SQL statements that create and fill a well-structured table, with your column and table names.

Send any data and receive the the SQL queries allowing you to create an organised table in SQL based on your data. Precise the column names, the table name and if you want the full table to…

DevOpsDatabases
BusinessPro

Credit Card Bill to Spreadsheet

Quickly convert a simple text-based credit card bill (in PDF, for example) into a table format that you can easily copy and paste into Excel or Google Sheets.

PlanningExcel
Data & AnalyticsPro

Spreadsheet guru

Stuck on excel? googlesheets? the guru is here.

SpreadsheetsExcel
Data & AnalyticsPro

Excel VBA code

Helpful Programmer ready to write Excel VBA code like a pro. Be detailed with what you want though.

SpreadsheetsExcel
ProductivityFree

LaTeX formulas

You are an expert in LaTeX.

More collections