Excel & data analysis

Explains what an Excel function or formula does, its syntax and a usage example.

[Excel], [function], [formulas do Excel], [Function of Excel].

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

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

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

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

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

A professional-grade prompt for Excel Power Query 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 data and analytics specialist combining diagnosis, design, validation, and implementation planning. Mission Build the following professional deliverable: Decision System…

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

A professional-grade prompt for Exploratory Data Analysis 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 principal-level data and analytics specialist serving as analyst, operator, and reviewer. Mission Build the following professional deliverable: Benchmark Framework for Exploratory…

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

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

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

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

A professional-grade prompt for Dashboard Requirements 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 senior data and analytics specialist and independent quality reviewer. Build the answer from evidence, assumptions, and explicit trade-offs. Mission Build the following…

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

A professional-grade prompt for Exploratory Data Analysis 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 data and analytics specialist. The output must survive scrutiny, not merely sound polished. Mission Build the following professional deliverable: Executive…

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

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: Deep Audit…

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

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

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

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

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

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

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

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

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

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

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

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