GPT-4o
⚙️ Technical
Intermediate
Data Analysis Pipeline Agent
Build an AI agent that ingests [DATA_FORMAT] from [SOURCE], analyzes [METRIC_OR_KPI], and generates a plain-language summary report on schedule.
The Prompt
# Data Analysis Pipeline Agent You are a data engineering architect. Design an AI agent that automates analysis of [DATA_FORMAT] data from [SOURCE]. ## Ingestion Connect to [SOURCE] (database query, API, or file upload). Pull data on [SCHEDULE] covering [DATE_RANGE]. ## Preprocessing Clean the data by: - Removing rows where [FILTER_FIELD] is null or outside [VALID_RANGE] - Deduplicating on [UNIQUE_KEY] - Converting [DATE_FIELD] to UTC ## Analysis Compute these metrics: - [METRIC_1]: [CALCULATION_METHOD_1] - [METRIC_2]: [CALCULATION_METHOD_2] - [METRIC_3]: compare to [BASELINE] and flag if deviation exceeds [THRESHOLD]% ## Report Generation Format findings as a plain-language summary for [AUDIENCE]: - Lead with the most significant change - Include a table of [METRIC_COUNT] key metrics - End with one recommended action based on the data ## Delivery Send the report to [RECIPIENT_CHANNEL] each [FREQUENCY] and archive to [STORAGE_LOCATION].
📝 Fill in the blanks
Replace these placeholders with your own content:
[DATA_FORMAT]
[SOURCE]
[SCHEDULE]
[DATE_RANGE]
[FILTER_FIELD]
[VALID_RANGE]
[UNIQUE_KEY]
[DATE_FIELD]
[METRIC_1]
[CALCULATION_METHOD_1]
[METRIC_2]
[CALCULATION_METHOD_2]
[METRIC_3]
[BASELINE]
[THRESHOLD]
[AUDIENCE]
[METRIC_COUNT]
[RECIPIENT_CHANNEL]
[FREQUENCY]
[STORAGE_LOCATION]
How to use this prompt
1
Copy the prompt
Click "Copy Prompt" above to copy the full prompt text to your clipboard.
2
Replace the placeholders
Swap out anything in [BRACKETS] with your specific details.
3
Paste into GPT-4o
Open your preferred AI assistant and paste the prompt to get started.