Excel & data analysis

Excel formulas, SQL queries, reports and data analysis.

325 prompts
CodingPro

SQL-backed Application Decision Framework with Weighted Criteria

A professional-grade prompt for SQL-backed Application that helps the user build a repeatable decision framework rather than a one-off opinion. It produces a weighted decision framework and decision rules while keeping assumptions, evidence, and constraints explicit.

Work as an expert software engineer combining diagnosis, design, validation, and implementation planning. Mission Build the following professional deliverable: Decision System for…

Data & AnalyticsPro

Stress-Test Dashboard Requirements Across Scenarios and Risks

A professional-grade prompt for Dashboard Requirements 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

Benchmark Excel Power Query Without Inventing External Data

A professional-grade prompt for Excel Power Query 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…

Excel
Data & AnalyticsPro

Optimize Dashboard Requirements: Bottlenecks, Trade-offs, and Measurable Gains

A professional-grade prompt for Dashboard Requirements 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 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

SQL Query Optimization Governance: Ownership, Controls, and Escalation

A professional-grade prompt for SQL Query Optimization that helps the user define ownership, controls, decision rights, escalation paths, and review gates. It produces a governance model with roles and controls 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

SQL Window Functions Decision Framework with Weighted Criteria

A professional-grade prompt for SQL Window Functions that helps the user build a repeatable decision framework rather than a one-off opinion. It produces a weighted decision framework and decision rules 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: Decision…

Data & AnalyticsPro

Diagnose the Root Causes Behind SQL Window Functions Problems

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

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

CodingPro

Red-Team SQL-backed Application: Quality Gates and Acceptance Criteria

A professional-grade prompt for SQL-backed Application 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 senior software engineer and independent quality reviewer. Build the answer from evidence, assumptions, and explicit trade-offs. Mission Build the following professional…

Data & AnalyticsPro

Optimize SQL Data Validation: Bottlenecks, Trade-offs, and Measurable Gains

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

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

Audit Tableau Dashboard for Hidden Gaps, Risks, and Failure Points

A professional-grade prompt for Tableau Dashboard 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 Tableau Dashboard.…

Data & AnalyticsPro

SQL Data Validation Executive Decision Memo

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

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

Benchmark Tableau Dashboard Without Inventing External Data

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

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: Benchmark…

Data & AnalyticsPro

SQL Data Validation Strategy: Priorities, Sequencing, and Stop-Doing List

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

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

Measure Excel Pivot Analysis: KPI Tree, Thresholds, and Review Cadence

A professional-grade prompt for Excel Pivot 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.

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

Excel
Data & AnalyticsPro

Stress-Test Excel Formula Engineering Across Scenarios and Risks

A professional-grade prompt for Excel Formula Engineering 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:…

Excel
Data & AnalyticsPro

Dashboard Requirements Decision Framework with Weighted Criteria

A professional-grade prompt for Dashboard Requirements that helps the user build a repeatable decision framework rather than a one-off opinion. It produces a weighted decision framework and decision rules 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

Tableau Dashboard Decision Framework with Weighted Criteria

A professional-grade prompt for Tableau Dashboard that helps the user build a repeatable decision framework rather than a one-off opinion. It produces a weighted decision framework and decision rules 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

Excel Pivot Analysis Strategy: Priorities, Sequencing, and Stop-Doing List

A professional-grade prompt for Excel Pivot 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.

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…

Excel
Data & AnalyticsPro

Stress-Test SQL Window Functions Across Scenarios and Risks

A professional-grade prompt for SQL Window Functions 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

Measure Excel Power Query: KPI Tree, Thresholds, and Review Cadence

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

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

Excel
Data & AnalyticsPro

Stress-Test SQL Data Validation Across Scenarios and Risks

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

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

Data & AnalyticsPro

Audit Excel Power Query for Hidden Gaps, Risks, and Failure Points

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

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

Excel
Data & AnalyticsPro

Optimize Excel Power Query: Bottlenecks, Trade-offs, and Measurable Gains

A professional-grade prompt for Excel Power Query 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 Excel…

Excel
Data & AnalyticsPro

Audit SQL Query Optimization for Hidden Gaps, Risks, and Failure Points

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

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

More collections