Data Pipeline Designer

Design an automated data pipeline between systems

🧪 Tested by a human Advanced 👤 Data Engineer 👤 Analyst 👤 It Admin
Design a data pipeline from [SOURCE] to [DESTINATION] for [PURPOSE]. Include: (1) Data extraction method, (2) Transformation rules, (3) Loading strategy (full vs incremental), (4) Schedule, (5) Error handling and alerting, (6) Data quality checks, (7) Monitoring dashboard. Consider volume, freshness, and reliability.

Works on

⭐ ChatGPT (Best) 🟠 Claude

Copy & Open in

🟢 ChatGPT 🟠 Claude

Prompt is copied to your clipboard when you click

Tips for Best Results

  • Start with incremental loads for efficiency
  • Build data quality checks before loading
  • Monitor for silent failures

📎 More Prompts

Approval Workflow Designer

●●
Design an approval workflow for [PROCESS]. Include: (1) Form fields, (2) Routing rules (by amount, type, department), (3) Escalation if unapproved within [TIME], (4) Notifications (submitted, approved, rejected, escalated), (5) Audit trail. Power Automate actions specified.
⭐ M365

Automated Report Generator

●●
Design an automated workflow that generates a [FREQUENCY — daily / weekly / monthly] [REPORT TYPE] report. Include: (1) Data sources to pull from, (2) Calculations and transformations needed, (3) Report format and layout, (4) Distribution list and delivery method, (5) Schedule and timing, (6) Error notification if report fails, (7) Archive and retention policy.
⭐ M365 🟢 GPT

Automation ROI Calculator

●●
Calculate the ROI for automating [PROCESS]. Include: (1) Current manual effort (hours per week, people involved, error rate), (2) Automation development cost (hours to build), (3) Ongoing maintenance estimate, (4) Time savings per week after automation, (5) Break-even point, (6) Annual ROI percentage, (7) Non-financial benefits (accuracy, speed, satisfaction). Present as a one-page business case.
⚡ M365 ⭐ GPT 🟠 Claude
💬