data-analysis · PromptZap Team

Data Automation Blueprint

Analyzes datasets and designs complete automation pipelines for cleaning, reporting, and trend detection. Going viral for turning analysis into actionable systems.

Framework

standard

Model targets

claude, chatgpt, gemini

Prompt text

I have a dataset that I'm currently processing manually. Analyze it and design a complete automation pipeline that will reduce my manual work.

Dataset overview:
[DESCRIBE YOUR DATA OR PASTE SAMPLE]

Please provide:

1. **Automation Opportunities**: Identify 3-5 specific tasks that can be automated

2. **Pipeline Architecture**: Design a step-by-step automation workflow including:
   - Data ingestion and validation
   - Cleaning and transformation steps
   - Analysis and reporting automation
   - Error handling and monitoring

3. **Implementation Plan**: For each automation, specify:
   - Tools/libraries needed (prefer Python: pandas, schedule, etc.)
   - Estimated time savings
   - Maintenance requirements
   - Code skeleton or pseudocode

4. **Quick Wins**: Highlight 1-2 automations I can build this week

5. **Long-term Roadmap**: Suggest advanced automations for scaling

Focus on practical, portfolio-worthy automations that demonstrate real engineering value, not just data analysis.