Excel & data analysis

Excel formulas, SQL queries, reports and data analysis.

325 prompts
Data & AnalyticsPro

Design an End-to-End Excel Formula Engineering Workflow with Controls

A professional-grade prompt for Excel Formula Engineering that helps the user design an end-to-end workflow with handoffs, controls, review gates, and automation opportunities. It produces a operating workflow with controls and ownership while keeping assumptions, evidence, and constraints explicit.

Operate as a lead data and analytics specialist. Treat this as production work that may be reviewed by senior stakeholders. Mission Build the following professional deliverable: Advanced…

ExcelDesign
CodingPro

SQL-backed Application Executive Decision Memo

A professional-grade prompt for SQL-backed Application that helps the user synthesize the evidence into a concise decision document for a senior stakeholder. It produces a executive memo with options, recommendation logic, risks, and next actions while keeping assumptions, evidence, and constraints explicit.

Take ownership as a principal software engineer. The output must survive scrutiny, not merely sound polished. Mission Build the following professional deliverable: Executive Decision Memo…

Data & AnalyticsPro

Turn SQL Data Validation into an Implementation-Ready System

A professional-grade prompt for SQL Data Validation that helps the user turn the objective into an implementation-ready system with dependencies and controls. It produces a implementation architecture and phased roadmap while keeping assumptions, evidence, and constraints explicit.

Operate as a lead data and analytics specialist. Treat this as production work that may be reviewed by senior stakeholders. Mission Build the following professional deliverable:…

Data & AnalyticsPro

Optimize SQL Query Optimization: Bottlenecks, Trade-offs, and Measurable Gains

A professional-grade prompt for SQL Query Optimization that helps the user optimize the current approach against explicit performance and quality criteria. It produces a optimization blueprint with measurable targets while keeping assumptions, evidence, and constraints explicit.

Work as an expert data and analytics specialist combining diagnosis, design, validation, and implementation planning. Mission Build the following professional deliverable: Optimization…

Data & AnalyticsPro

Turn SQL Window Functions into an Implementation-Ready System

A professional-grade prompt for SQL Window Functions that helps the user turn the objective into an implementation-ready system with dependencies and controls. It produces a implementation architecture and phased roadmap while keeping assumptions, evidence, and constraints explicit.

You are a senior data and analytics specialist accountable for both the recommendation and the quality of the decision process. Mission Build the following professional deliverable:…

Data & AnalyticsPro

Turn Excel Power Query into an Implementation-Ready System

A professional-grade prompt for Excel Power Query that helps the user turn the objective into an implementation-ready system with dependencies and controls. It produces a implementation architecture and phased roadmap while keeping assumptions, evidence, and constraints explicit.

Act as a principal-level data and analytics specialist serving as analyst, operator, and reviewer. Mission Build the following professional deliverable: Implementation Architecture for…

Excel
Data & AnalyticsPro

Audit SQL Window Functions for Hidden Gaps, Risks, and Failure Points

A professional-grade prompt for SQL Window Functions that helps the user conduct a rigorous audit, identify material weaknesses, and prioritize fixes. It produces a audit report with severity and priority while keeping assumptions, evidence, and constraints explicit.

Act as a principal-level data and analytics specialist serving as analyst, operator, and reviewer. Mission Build the following professional deliverable: Deep Audit for SQL Window Functions.…

Data & AnalyticsPro

Excel Formula Engineering Executive Decision Memo

A professional-grade prompt for Excel Formula Engineering that helps the user synthesize the evidence into a concise decision document for a senior stakeholder. It produces a executive memo with options, recommendation logic, risks, and next actions while keeping assumptions, evidence, and constraints explicit.

Act as a senior data and analytics specialist and independent quality reviewer. Build the answer from evidence, assumptions, and explicit trade-offs. Mission Build the following…

Excel
Data & AnalyticsPro

Stress-Test Tableau Dashboard Across Scenarios and Risks

A professional-grade prompt for Tableau Dashboard that helps the user stress-test the topic across scenarios, assumptions, and downside risks. It produces a scenario matrix, risk register, and triggers while keeping assumptions, evidence, and constraints explicit.

You are a senior data and analytics specialist accountable for both the recommendation and the quality of the decision process. Mission Build the following professional deliverable:…

Data & AnalyticsPro

Design an End-to-End Excel Pivot Analysis Workflow with Controls

A professional-grade prompt for Excel Pivot Analysis that helps the user design an end-to-end workflow with handoffs, controls, review gates, and automation opportunities. It produces a operating workflow with controls and ownership while keeping assumptions, evidence, and constraints explicit.

Take ownership as a principal data and analytics specialist. The output must survive scrutiny, not merely sound polished. Mission Build the following professional deliverable: Advanced…

ExcelDesign
Data & AnalyticsPro

Tableau Dashboard Strategy: Priorities, Sequencing, and Stop-Doing List

A professional-grade prompt for Tableau Dashboard that helps the user create a strategy that explicitly prioritizes what to do, defer, and stop. It produces a prioritized strategy with rationale and sequencing while keeping assumptions, evidence, and constraints explicit.

Take ownership as a principal data and analytics specialist. The output must survive scrutiny, not merely sound polished. Mission Build the following professional deliverable: Strategy and…

Data & AnalyticsPro

Benchmark SQL Query Optimization Without Inventing External Data

A professional-grade prompt for SQL Query Optimization that helps the user create a defensible benchmark framework without inventing external benchmarks. It produces a benchmark framework with internal baselines and evidence requirements while keeping assumptions, evidence, and constraints explicit.

Act as a senior data and analytics specialist and independent quality reviewer. Build the answer from evidence, assumptions, and explicit trade-offs. Mission Build the following…

Data & AnalyticsPro

Design an End-to-End Tableau Dashboard Workflow with Controls

A professional-grade prompt for Tableau Dashboard that helps the user design an end-to-end workflow with handoffs, controls, review gates, and automation opportunities. It produces a operating workflow with controls and ownership while keeping assumptions, evidence, and constraints explicit.

Act as a principal-level data and analytics specialist serving as analyst, operator, and reviewer. Mission Build the following professional deliverable: Advanced Workflow Design for Tableau…

Design
Data & AnalyticsPro

Dashboard Requirements Strategy: Priorities, Sequencing, and Stop-Doing List

A professional-grade prompt for Dashboard Requirements that helps the user create a strategy that explicitly prioritizes what to do, defer, and stop. It produces a prioritized strategy with rationale and sequencing while keeping assumptions, evidence, and constraints explicit.

Work as an expert data and analytics specialist combining diagnosis, design, validation, and implementation planning. Mission Build the following professional deliverable: Strategy and…

Data & AnalyticsPro

Diagnose the Root Causes Behind SQL Query Optimization Problems

A professional-grade prompt for SQL Query Optimization that helps the user diagnose root causes before recommending corrective action. It produces a root-cause tree with evidence needs and corrective actions while keeping assumptions, evidence, and constraints explicit.

You are a senior data and analytics specialist accountable for both the recommendation and the quality of the decision process. Mission Build the following professional deliverable:…

Data & AnalyticsPro

Diagnose the Root Causes Behind Excel Power Query Problems

A professional-grade prompt for Excel Power Query that helps the user diagnose root causes before recommending corrective action. It produces a root-cause tree with evidence needs and corrective actions while keeping assumptions, evidence, and constraints explicit.

Act as a senior data and analytics specialist and independent quality reviewer. Build the answer from evidence, assumptions, and explicit trade-offs. Mission Build the following…

Excel
Data & AnalyticsPro

Stress-Test Excel Pivot Analysis Across Scenarios and Risks

A professional-grade prompt for Excel Pivot Analysis that helps the user stress-test the topic across scenarios, assumptions, and downside risks. It produces a scenario matrix, risk register, and triggers while keeping assumptions, evidence, and constraints explicit.

Take ownership as a principal data and analytics specialist. The output must survive scrutiny, not merely sound polished. Mission Build the following professional deliverable: Scenario and…

Excel
Data & AnalyticsPro

Diagnose the Root Causes Behind Dashboard Requirements Problems

A professional-grade prompt for Dashboard Requirements that helps the user diagnose root causes before recommending corrective action. It produces a root-cause tree with evidence needs and corrective actions while keeping assumptions, evidence, and constraints explicit.

Act as a senior data and analytics specialist and independent quality reviewer. Build the answer from evidence, assumptions, and explicit trade-offs. Mission Build the following…

Data & AnalyticsPro

Diagnose the Root Causes Behind Excel Pivot Analysis Problems

A professional-grade prompt for Excel Pivot Analysis that helps the user diagnose root causes before recommending corrective action. It produces a root-cause tree with evidence needs and corrective actions while keeping assumptions, evidence, and constraints explicit.

Take ownership as a principal data and analytics specialist. The output must survive scrutiny, not merely sound polished. Mission Build the following professional deliverable: Root-Cause…

Excel
Data & AnalyticsPro

Optimize SQL Window Functions: Bottlenecks, Trade-offs, and Measurable Gains

A professional-grade prompt for SQL Window Functions that helps the user optimize the current approach against explicit performance and quality criteria. It produces a optimization blueprint with measurable targets while keeping assumptions, evidence, and constraints explicit.

Act as a principal-level data and analytics specialist serving as analyst, operator, and reviewer. Mission Build the following professional deliverable: Optimization Blueprint for SQL…

Data & AnalyticsPro

Red-Team Excel Pivot Analysis: Quality Gates and Acceptance Criteria

A professional-grade prompt for Excel Pivot Analysis that helps the user review the work against a strict quality standard and expose hidden failure modes. It produces a QA report, acceptance criteria, and revision plan while keeping assumptions, evidence, and constraints explicit.

Act as a principal-level data and analytics specialist serving as analyst, operator, and reviewer. Mission Build the following professional deliverable: Quality Assurance Review for Excel…

Excel
Data & AnalyticsPro

Diagnose the Root Causes Behind Excel Formula Engineering Problems

A professional-grade prompt for Excel Formula Engineering that helps the user diagnose root causes before recommending corrective action. It produces a root-cause tree with evidence needs and corrective actions while keeping assumptions, evidence, and constraints explicit.

You are a senior data and analytics specialist accountable for both the recommendation and the quality of the decision process. Mission Build the following professional deliverable:…

Excel
Data & AnalyticsPro

Exploratory Data Analysis Strategy: Priorities, Sequencing, and Stop-Doing List

A professional-grade prompt for Exploratory Data Analysis that helps the user create a strategy that explicitly prioritizes what to do, defer, and stop. It produces a prioritized strategy with rationale and sequencing while keeping assumptions, evidence, and constraints explicit.

Operate as a lead data and analytics specialist. Treat this as production work that may be reviewed by senior stakeholders. Mission Build the following professional deliverable: Strategy…

Data & AnalyticsPro

Measure Exploratory Data Analysis: KPI Tree, Thresholds, and Review Cadence

A professional-grade prompt for Exploratory Data Analysis that helps the user design a measurement system with leading and lagging indicators, thresholds, and review cadence. It produces a measurement framework with thresholds and review cadence while keeping assumptions, evidence, and constraints explicit.

Operate as a lead data and analytics specialist. Treat this as production work that may be reviewed by senior stakeholders. Mission Build the following professional deliverable: Measurement…

More collections