Excel & data analysis

Excel formulas, SQL queries, reports and data analysis.

325 prompts
Data & AnalyticsFree

Turn SQL Window Functions into a Step-by-Step Action Plan

A practical prompt for SQL Window Functions 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 SQL Window Functions. 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

Review Excel Power Query Against Practical Best Practices

A practical prompt for Excel Power Query 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 Power Query. 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

Turn SQL Data Validation into a Step-by-Step Action Plan

A practical prompt for SQL Data Validation 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 SQL Data Validation. 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

Design a Lightweight SQL Data Validation Workflow

A practical prompt for SQL Data Validation 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 SQL Data Validation. Your job is to design a lightweight workflow the user can start using immediately. Produce the working artifact, not a lecture about how to do it.

Data & AnalyticsFree

Clarify SQL Data Validation Requirements Before Execution

A practical prompt for SQL Data Validation 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 SQL Data Validation. 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

Compare SQL Window Functions Options with Clear Trade-offs

A practical prompt for SQL Window Functions 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 SQL Window Functions. 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

SQL Window Functions Example Pack with Reusable Patterns

A practical prompt for SQL Window Functions 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 Window Functions. Your job is to produce realistic examples and reusable patterns. Produce the working artifact, not a lecture about how to do it.

CodingFree

Turn SQL-backed Application into a Step-by-Step Action Plan

A practical prompt for SQL-backed Application 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 SQL-backed Application. Your job is to convert the goal into sequenced, achievable actions. Produce the working artifact, not a lecture about how to do it.

Planning
CodingFree

Troubleshoot Common SQL-backed Application Problems

A practical prompt for SQL-backed Application that helps the user identify common failure points and propose practical fixes. It produces a diagnostic checklist and fixes while keeping assumptions, evidence, and constraints explicit.

Basic Troubleshooter for SQL-backed Application. Your job is to identify common failure points and propose practical fixes. Produce the working artifact, not a lecture about how to do it.

Data & AnalyticsFree

Draft a Usable Excel Formula Engineering from Raw Inputs

A practical prompt for Excel Formula Engineering that helps the user produce a clean and usable first draft. It produces a ready-to-edit draft while keeping assumptions, evidence, and constraints explicit.

Structured Draft for Excel Formula Engineering. Your job is to produce a clean and usable first draft. Produce the working artifact, not a lecture about how to do it.

Excel
Data & AnalyticsFree

Exploratory Data Analysis Example Pack with Reusable Patterns

A practical prompt for Exploratory Data Analysis 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 Exploratory Data Analysis. Your job is to produce realistic examples and reusable patterns. Produce the working artifact, not a lecture about how to do it.

Data & AnalyticsFree

Compare SQL Query Optimization Options with Clear Trade-offs

A practical prompt for SQL Query Optimization 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 SQL Query Optimization. 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

Draft a Usable Exploratory Data Analysis from Raw Inputs

A practical prompt for Exploratory Data Analysis that helps the user produce a clean and usable first draft. It produces a ready-to-edit draft while keeping assumptions, evidence, and constraints explicit.

Structured Draft for Exploratory Data Analysis. Your job is to produce a clean and usable first draft. Produce the working artifact, not a lecture about how to do it.

Data & AnalyticsFree

Troubleshoot Common SQL Window Functions Problems

A practical prompt for SQL Window Functions that helps the user identify common failure points and propose practical fixes. It produces a diagnostic checklist and fixes while keeping assumptions, evidence, and constraints explicit.

Basic Troubleshooter for SQL Window Functions. Your job is to identify common failure points and propose practical fixes. Produce the working artifact, not a lecture about how to do it.

Data & AnalyticsFree

Build a Reusable Excel Pivot Analysis Template

A practical prompt for Excel Pivot Analysis 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 Pivot Analysis. 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

Exploratory Data Analysis: Practical Quick-Start Guide

A practical prompt for Exploratory Data Analysis 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 Exploratory Data Analysis. 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.

Data & AnalyticsFree

Troubleshoot Common SQL Query Optimization Problems

A practical prompt for SQL Query Optimization that helps the user identify common failure points and propose practical fixes. It produces a diagnostic checklist and fixes while keeping assumptions, evidence, and constraints explicit.

Basic Troubleshooter for SQL Query Optimization. Your job is to identify common failure points and propose practical fixes. Produce the working artifact, not a lecture about how to do it.

Data & AnalyticsFree

Troubleshoot Common Excel Pivot Analysis Problems

A practical prompt for Excel Pivot Analysis that helps the user identify common failure points and propose practical fixes. It produces a diagnostic checklist and fixes while keeping assumptions, evidence, and constraints explicit.

Basic Troubleshooter for Excel Pivot Analysis. Your job is to identify common failure points and propose practical fixes. Produce the working artifact, not a lecture about how to do it.

Excel
CodingFree

SQL-backed Application: Practical Quick-Start Guide

A practical prompt for SQL-backed Application 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 SQL-backed Application. 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.

Data & AnalyticsFree

Review Tableau Dashboard Against Practical Best Practices

A practical prompt for Tableau Dashboard 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 Tableau Dashboard. Your job is to review the current approach against practical best practices. Produce the working artifact, not a lecture about how to do it.

Data & AnalyticsFree

SQL Data Validation Checklist: What to Verify Before You Finish

A practical prompt for SQL Data Validation 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 Data Validation. 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

Design a Lightweight SQL Query Optimization Workflow

A practical prompt for SQL Query Optimization 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 SQL Query Optimization. Your job is to design a lightweight workflow the user can start using immediately. Produce the working artifact, not a lecture about how to do…

Data & AnalyticsFree

Clarify Tableau Dashboard Requirements Before Execution

A practical prompt for Tableau Dashboard 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 Tableau Dashboard. 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

Draft a Usable Excel Pivot Analysis from Raw Inputs

A practical prompt for Excel Pivot Analysis that helps the user produce a clean and usable first draft. It produces a ready-to-edit draft while keeping assumptions, evidence, and constraints explicit.

Structured Draft for Excel Pivot Analysis. Your job is to produce a clean and usable first draft. Produce the working artifact, not a lecture about how to do it.

Excel

More collections