📊 Promptolis Originals · Data & Analytics
SQL, spreadsheets, and dashboards that answer the real question.
Prompts for analysts, operators, and PMs — SQL query debugging, Excel formula translation, dashboard design, KPI framework selection, and the difference between a number and an insight.
18 Originals in this category · Curated by Promptolis Editorial · Last updated
🥇 Tier 3 — Gold / Moat
Premium Originals with low volume but high intent. The ones worth your full attention.
A/B Test Design Rigor — Statistical Power + Proper Experimentation
The structured A/B test design covering sample size calculation, statistical significance, common pitfalls (peeking, multi-comparison…
Analytics Event Taxonomy — Naming Standards That Scale
The structured event tracking taxonomy — covering naming conventions, property standards, hierarchy design…
Cohort Retention Analysis — Understand Your Retention Curve + Drivers
The structured cohort analysis — covering cohort definition, retention measurement, curve-shape diagnosis, retention-driver identification…
Customer Analytics Deep Dive — CAC / LTV / Segmentation Mastery
The structured customer analytics covering CAC calculation (marketing + sales fully-loaded), LTV methodology, CAC:LTV ratio benchmarks…
Dashboard Design Principles — Build Dashboards People Actually Use
The structured dashboard design covering audience-first layout, the 5-second test, chart type selection, color discipline, the 'single-action' principle…
Data Pipeline Architect — ETL/ELT Design For 2026
The structured data pipeline design — covering ETL vs. ELT tradeoffs, batch vs. streaming architecture…
Data Quality Audit — Find + Fix Data Issues Before They Break Decisions
The structured data quality audit covering the 6 quality dimensions (completeness / accuracy / consistency / timeliness / validity / uniqueness)…
Data Team Scaling Playbook — From Solo Analyst To Modern Data Organization
The structured data team scaling covering roles evolution (analyst → analytics engineer → data engineer → data scientist → head of data)…
Metric Framework Design — North Star + Input Metrics That Drive Action
The structured metric hierarchy — covering north star metric selection, input metrics, counter-metrics…
Predictive Analytics Primer — From Forecast To Production ML
The structured predictive analytics approach — covering when predictions beat heuristics, model selection (time series / classification / regression)…
Reporting Automation Protocol — Kill Manual Reports Forever
The structured reporting automation — covering recurring report identification, tool selection, automation patterns, stakeholder communication…
SQL Query Optimizer — Find + Fix Slow Queries
The structured SQL query optimization covering query plan analysis, index strategy, join optimization, the 7 common performance killers…
🥈 Tier 2 — Sweet Spot
Core Originals — mid-volume problems where sharpness beats generic AI output.
🥉 Tier 1 — Volume
High-search-volume Originals for common tasks — built to outrank generic 'ChatGPT prompt' pages.
Dashboard Design Architect
Start with the business question, not the data. Get a 4-chart dashboard that an exec will actually read — and a list of the vanity charts you should kill.
Data Analysis Story Builder
Turn raw findings into a 5-slide narrative that actually changes minds — no more 'here's a spreadsheet, you figure it out.'
Excel Formula Translator
Plain English → the RIGHT formula, with tradeoffs and which version survives when someone breaks the sheet.
KPI Framework Selector
Picks the right measurement system for your stage — and names the 5 metrics your team is wasting time on.
SQL Query Debugger
Paste the query that's lying to you. Get back the exact logic error, the fix, and the heuristic so you never ship this bug again.
Frequently asked questions
What is the "Data & Analytics" category on Promptolis?
Prompts for analysts, operators, and PMs — SQL query debugging, Excel formula translation, dashboard design, KPI framework selection, and the difference between a number and an insight. Every prompt in this category is a Promptolis Original — hand-crafted by the Promptolis Editorial team and reviewed before publishing.
How many Data & Analytics Originals are there?
There are 18 Promptolis Originals in the Data & Analytics category. New ones are added weekly.
Are Data & Analytics Originals free?
Yes. Every Promptolis Original is free, MIT-licensed, and copy-ready. No email required, no paywall.
Which AI model works best for Data & Analytics prompts?
Most Originals in this category are tuned for Claude Sonnet 4.5 / Opus 4 and GPT-5. Each Original page includes a model-specific recommendation.