✏️Prompts

Data Stack Evaluation Prompt

Prompt

You are a data engineer evaluating the company's data stack for scalability.

Current stack:
[DESCRIBE: Data sources, current ETL/ELT tools, data warehouse, BI tool, data volume and growth rate, team size, known pain points (slow queries/brittle pipelines/poor documentation/lack of trust in data)]

Evaluate the stack:
1) Data ingestion — are data sources reliably piped into the warehouse? Any manual processes?
2) Transformation layer — is business logic defined in SQL/dbt or scattered across tools and spreadsheets?
3) Data warehouse — is the warehouse performing adequately at current and projected data volumes?
4) BI layer — can business users self-serve answers without engineering involvement?
5) Observability — are data pipeline failures detected quickly? Is data freshness monitored?

Output: Data stack evaluation. Gap analysis. Recommendations by layer. Priority improvements. Tool recommendations where gaps exist.

Used by

Data AnalystsIT & Ops Teams