📊 Data & Analytics Prompts
23 prompts · SQL, Python, visualization, reports
Build a Comprehensive Data Cleaning Pipeline for Raw Datasets
Design a robust, end-to-end data cleaning pipeline with validation rules, logging, automation, and quality checks for any dataset.
Design a Missing Value Imputation Strategy for Your Dataset
Get a tailored missing value imputation strategy with diagnosis, method selection, Python code, and validation for your dataset.
Create an Outlier Detection and Handling Framework for Your Data
Build a complete outlier detection and handling framework using statistical, visual, and ML methods with Python code.
Compare Feature Scaling Methods and Choose the Best for Your Model
Compare feature scaling methods like Min-Max, Standard, and Robust scaling with code and model-specific recommendations.
Design an Optimal One-Hot Encoding Strategy for Categorical Features
Design a smart one-hot and categorical encoding strategy with cardinality handling, Python code, and pipeline integration.
Design a Scalable ETL Pipeline Architecture
Design a robust, scalable ETL pipeline architecture with extraction, transformation, loading strategies, and error handling.
Build an RFM Customer Segmentation Model
Create a complete RFM customer segmentation model with scoring logic, segment definitions, marketing actions, and code.
Build an RFM Customer Segmentation Model for Targeted Marketing
Create a complete RFM customer segmentation model with scoring logic, code implementation, and marketing strategies.
Build a Time Series Forecasting Model with Trend and Seasonality Analysis
Build a time series forecasting model with EDA, model comparison, validation strategy, and production-ready code.
Build an Anomaly Detection System for Real-Time Data Monitoring
Design a complete anomaly detection system with algorithm selection, threshold tuning, and false positive reduction.
Design a Robust ETL Pipeline Architecture for Your Data Warehouse
Design a scalable ETL pipeline architecture with extraction strategies, transformations, error handling, and orchestration plans.
Analyze A/B Test Results with Statistical Rigor and Business Recommendations
Get a rigorous statistical analysis of your A/B test results with significance testing, power analysis, and business recommendations.
Build an RFM Customer Segmentation Model with Actionable Marketing Strategies
Create an RFM customer segmentation model with scoring logic, segment profiles, and targeted marketing strategies for each group.
Analyze A/B Test Results and Generate Statistical Recommendations
Get a complete A/B test analysis with statistical significance, power analysis, sanity checks, and ship/no-ship recommendations.
Build a Comprehensive Funnel Analysis with Drop-Off Insights
Perform a detailed funnel analysis identifying drop-off points, root causes, benchmarks, and a prioritized optimization roadmap.
Design a Scalable ETL Pipeline Architecture for Your Data Platform
Design a production-ready ETL pipeline architecture with tool recommendations, error handling, and scalability strategies.
Analyze A/B Test Results and Determine Statistical Significance
Get a complete A/B test analysis with statistical significance, confidence intervals, power analysis, and ship decisions.
Build a Comprehensive Cohort Analysis to Track User Retention and Behavior
Create a full cohort analysis with SQL queries, retention matrices, segmentation strategies, and actionable insight frameworks.
Design a Robust ETL Pipeline Architecture for Your Data Platform
Design a complete ETL pipeline architecture with extraction, transformation, loading strategies, error handling, and governance.
Create a Comprehensive Data Quality Checklist for Your Dataset
Generate a tailored data quality checklist with SQL validation queries, severity levels, and a scoring framework for any dataset.
Analyze and Interpret A/B Test Results with Statistical Rigor
Get a complete A/B test analysis with statistical significance, power analysis, validity checks, and a clear ship decision.
Write Complex SQL Queries
Generate optimized SQL queries for complex analysis with CTEs, JOINs, and performance tips.
Python Data Analysis Script
Generate a complete Python data analysis pipeline with cleaning, visualization, and insights.