🎯 Business & Strategy

Data Architect & Business Strategist (CSV Audit & Pipeline)

📁 Business & Strategy 👤 Contributed by @somebeing2 🗓️ Updated 2026-04-19

The prompt

I want you to act as a Senior Data Science Architect and Lead Business Analyst. I am uploading a CSV file that contains raw data. Your goal is to perform a deep technical audit and provide a production-ready cleaning pipeline that aligns with business objectives. Please follow this 4-step execution flow: Technical Audit & Business Context: Analyze the schema. Identify inconsistencies, missing values, and Data Smells. Briefly explain how these data issues might impact business decision-making (e.g., Inconsistent dates may lead to incorrect monthly trend analysis). Statistical Strategy: Propose a rigorous strategy for Imputation (Median vs. Mean), Encoding (One-Hot vs. Label), and Scaling (Standard vs. Robust) based on the audit. The Implementation Block: Write a modular, PEP8-compliant Python script using pandas and scikit-learn. Include a Pipeline object so the code is ready for a Streamlit dashboard or an automated batch job. Post-Processing Validation: Provide assertion checks to verify data integrity (e.g., checking for nulls or memory optimization via down casting). Constraints: Prioritize memory efficiency (use appropriate dtypes like int8 or float32). Ensure zero data leakage if a target variable is present. Provide the output in structured Markdown with professional code comments. I have uploaded the file. Please begin the audit.

0 copies

🚀 Open in ChatGPT ✨ Open in Claude 💎 Open in Gemini

How to use this prompt

Copy the prompt above or click an "Open in" button to launch it directly in your preferred AI. You can then customize the wording to match your exact use case — for example replacing placeholders like [your topic] with real context.

Which AI model works best

ChatGPT with the Pro plan (including Deep Research mode) is often the go-to for strategy work — it can pull fresh data and synthesize across sources. Claude is the better sounding-board for judgment-heavy decisions. Gemini integrates with Google Workspace data.

How to customize this prompt

Add specifics: company size, industry, revenue stage, geographic market, competition. The more the prompt knows about your context, the more useful the output. For sensitive inputs, use a local or enterprise LLM instead of consumer tools.

Common use cases

Generating a go-to-market plan for a new product
Analyzing competitor positioning based on public info
Building pros-and-cons frameworks for tough decisions
Drafting investor updates and board memos
Stress-testing business model assumptions

Variations

Adapt the tone (more casual, more technical), change the output format (bullet points vs. paragraphs), or add constraints (word limits, target audience).