Mega Prompt Library
# Mega Prompt Library
Strict-mode prompt system for analytics, BI, ML, automation, and career workflows in 2026.
## Table of Contents
- [How to Use This Prompt Library](#how-to-use-this-prompt-library)
- [Capability References (Checked February 20, 2026)](#capability-references-checked-february-20-2026)
- [Data Analytics & BI](#data-analytics--bi)
- [DA-01 Fraud EDA Blueprint](#da-01-fraud-eda-blueprint)
- [DA-02 Star-Schema KPI SQL Pack](#da-02-star-schema-kpi-sql-pack)
- [DA-03 Metrics Layer Spec Builder](#da-03-metrics-layer-spec-builder)
- [DA-04 Data Quality Guardrail Suite](#da-04-data-quality-guardrail-suite)
- [DA-05 Cohort Retention Analyzer](#da-05-cohort-retention-analyzer)
- [DA-06 Executive KPI Narrative Writer](#da-06-executive-kpi-narrative-writer)
- [DA-07 Customer Segmentation Builder](#da-07-customer-segmentation-builder)
- [DA-08 Forecast vs Actual Root-Cause Framework](#da-08-forecast-vs-actual-root-cause-framework)
- [DA-09 BI Semantic Model Refactor Prompt](#da-09-bi-semantic-model-refactor-prompt)
- [DA-10 KPI Definition Alignment Facilitator](#da-10-kpi-definition-alignment-facilitator)
- [Machine Learning](#machine-learning)
- [ML-01 Baseline Fraud Model Accelerator](#ml-01-baseline-fraud-model-accelerator)
- [ML-02 Leakage and Bias Inspection Engine](#ml-02-leakage-and-bias-inspection-engine)
- [ML-03 Feature Engineering Strategy Lab](#ml-03-feature-engineering-strategy-lab)
- [ML-04 Compute-Aware Hyperparameter Plan](#ml-04-compute-aware-hyperparameter-plan)
- [ML-05 Imbalanced Classification Operating Plan](#ml-05-imbalanced-classification-operating-plan)
- [ML-06 Explainability Delivery Pack](#ml-06-explainability-delivery-pack)
- [ML-07 Time-Based Validation Architect](#ml-07-time-based-validation-architect)
- [ML-08 Drift Monitoring Blueprint](#ml-08-drift-monitoring-blueprint)
- [ML-09 Threshold Optimization by Business Cost](#ml-09-threshold-optimization-by-business-cost)
- [ML-10 Model Card and Experiment Log Generator](#ml-10-model-card-and-experiment-log-generator)
- [Automation & Agents](#automation--agents)
- [AU-01 n8n Workflow Architect (From Plain English)](#au-01-n8n-workflow-architect-from-plain-english)
- [AU-02 Personal Analytics Command Center](#au-02-personal-analytics-command-center)
- [AU-03 LangGraph Multi-Agent Blueprint](#au-03-langgraph-multi-agent-blueprint)
- [AU-04 ETL-to-Dashboard Orchestration Plan](#au-04-etl-to-dashboard-orchestration-plan)
- [AU-05 Anomaly Alert + Human Approval Flow](#au-05-anomaly-alert--human-approval-flow)
- [AU-06 Data Dictionary Auto-Documentation Flow](#au-06-data-dictionary-auto-documentation-flow)
- [AU-07 Dashboard Incident Triage Agent](#au-07-dashboard-incident-triage-agent)
- [AU-08 Meeting Notes -> Analytics Backlog Generator](#au-08-meeting-notes---analytics-backlog-generator)
- [AU-09 Safe External Data Ingestion Workflow](#au-09-safe-external-data-ingestion-workflow)
- [AU-10 Weekly AI Learning & Portfolio Automation](#au-10-weekly-ai-learning--portfolio-automation)
- [Career & Portfolio](#career--portfolio)
- [CP-01 Portfolio Project Idea Engine](#cp-01-portfolio-project-idea-engine)
- [CP-02 README Rewriter for Recruiters](#cp-02-readme-rewriter-for-recruiters)
- [CP-03 Resume Bullet Quantifier](#cp-03-resume-bullet-quantifier)
- [CP-04 Interview Drill Builder](#cp-04-interview-drill-builder)
- [CP-05 LinkedIn Project Story Generator](#cp-05-linkedin-project-story-generator)
- [CP-06 Targeted Cover Letter Composer](#cp-06-targeted-cover-letter-composer)
- [CP-07 STAR Story Extractor](#cp-07-star-story-extractor)
- [CP-08 30-60-90 Day Plan Generator](#cp-08-30-60-90-day-plan-generator)
- [CP-09 Portfolio Technical Review Simulator](#cp-09-portfolio-technical-review-simulator)
- [CP-10 Skill-Gap Roadmap from Job Postings](#cp-10-skill-gap-roadmap-from-job-postings)
## How to Use This Prompt Library
This version is optimized for practical analytics work in February 2026 and intentionally separates Claude, ChatGPT, and Gemini behavior. Each entry is a **mega-prompt**: copy it, replace placeholders, and run it as a complete workflow rather than a single command.
### Model-specific operating style
| Model | Best use in this library | How to run it well |
|---|---|---|
| Claude (Claude web / Claude Code) | Deep planning, structured reasoning, workflow design | Use XML blocks with clear `<context>`, `<schema>`, `<task>`, `<rules>`, then ask for phased output |
| ChatGPT (o1/o3 + Advanced Data Analysis) | Edge-case reasoning plus code execution in ADA | First use o1/o3 to reason through edge cases, then use ADA to execute validated code |
| Gemini (Gemini Advanced + Gems) | Long-context synthesis with docs and Google ecosystem context | Attach docs/Sheets/PDFs and require explicit source-grounded assumptions |
### Universal paste templatewhen to use it
Community prompt sourced from the open-source GitHub repo daniel-st3/ai-analytics-prompt-playbook (MIT). A "Mega Prompt Library" style prompt — adapt the placeholders and specifics to your task. Imported as-is and not independently retested here, so check the output before relying on it.
tags
careercommunitygeneral
source
daniel-st3/ai-analytics-prompt-playbook · MIT