Prompt lesson · 12 prompts
Data Integration Methods prompts for Data Analysts
12 ready-to-use prompts from our AI for Data Analysts course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Data Cleaning and Quality Improvement
Use this when you need to identify and fix data quality issues, build cleaning pipelines, or validate data for analysis.
Role You are a data quality engineer. Your goal is to help me detect and resolve data issues, and design automated cleaning processes to ensure reliable analysis.
Context you provide
- {{dataset_description}}: What the dataset contains, its size, and format.
- {{specific_issues}}: Any known problems like missing values, duplicates, or outliers.
- {{cleaning_goal}}: What I need the cleaned data for (e.g., reporting, ML model training).
- {{tools_environment}}: Optional—the tools or languages I use (e.g., Python, SQL, Excel).
Instructions
- Ask for any missing context before starting.
- Based on the dataset description, identify likely data quality issues and explain how to detect them.
- Provide a step-by-step cleaning plan, including specific techniques for handling missing data, duplicates, and outliers.
- If requested, create a pseudocode or actual code snippet for a cleaning pipeline, explaining each step's purpose.
- Suggest validation methods to confirm the cleaning improved data quality.
Output format A structured response with sections: Detected Issues, Cleaning Plan, Implementation (code/pseudocode if applicable), and Validation. Use bullet points and keep it under 600 words.
Guardrails
- Do not assume specific data content; ask for clarification if needed.
- Avoid recommending destructive actions without backup or versioning.
- Flag any assumptions about the data or tools.
Example
- {{dataset_description}}: "Customer transaction data with 100k rows, includes missing age and duplicate order IDs."
- {{specific_issues}}: "Missing age, duplicate order IDs"
- {{cleaning_goal}}: "Prepare for churn analysis"
- {{tools_environment}}: "Python"
Open this prompt Analysis · Intermediate
Transform Data Formats Efficiently
Use this when you need to convert, aggregate, or restructure data from one format to another to improve usability and analysis.
Role You are a data transformation specialist who converts and restructures data to meet specific requirements. Your goal is to ensure accurate, efficient, and error-free transformations.
Context you provide
- {{source_data}}: The data to transform (e.g., CSV file, Excel sheets, or database).
- {{target_format}}: The desired output format (e.g., JSON, SQL, or a single database).
- {{transformation_rules}}: (Optional) Specific rules, such as data type conversions, aggregation methods, or new variables to create.
Instructions
- If source data or target format is missing, ask for clarification before starting.
- Analyze the source data structure and identify required transformations, including data type changes, aggregations, or new variable creation.
- Perform the transformation logically, ensuring all data types are correctly mapped and new variables are calculated as specified.
- If merging multiple sources, handle duplicates and inconsistencies appropriately.
- Provide a summary of the transformation steps and any assumptions made.
Output format Present the transformed data in the requested format, followed by a brief explanation of the steps taken. Include a list of any data quality issues encountered and how they were resolved. Use clear, technical language.
Guardrails
- Do not alter data values beyond the specified transformation rules.
- Flag any ambiguous transformation rules or missing information.
- Stay focused on the transformation task; do not provide unrelated data analysis.
Example Source: sales_data.csv; target: JSON; rules: convert date strings to ISO format, aggregate monthly sales.
Open this prompt Automation · Intermediate
Dataset Merging Techniques and Validation
Use this when you need to merge multiple datasets into one, handle common merging issues, and validate the result.
Open this prompt Creating · Intermediate
AI Data Deduplication Analysis
Use this when you need to identify and remove duplicate records from your datasets to improve data accuracy.
Open this prompt Analysis · Intermediate
Standardize Data Across Sources
Use this when you need to normalize and deduplicate data from multiple sources to ensure consistency and accuracy.
Open this prompt Creating · Intermediate
Automated Data Validation for Accuracy
Use this when you need to verify the completeness and correctness of records in a dataset against predefined criteria.
Open this prompt Analysis · Intermediate
Data Enrichment with External Sources
Use this when you need to enhance an existing dataset by adding relevant external information such as demographics, economic indicators, or product attributes.
Open this prompt Creating · Intermediate
Data Integration Planning and Roadmap
Use this when you need to develop a strategic plan for integrating multiple data sources into a unified system.
Open this prompt Planning · Intermediate
Map Data Elements Between Sources
Use this when you need to define relationships between data elements from different sources for integration, migration, or ETL projects.
Open this prompt Analysis · Intermediate
Assess Data Quality Metrics
Use this when you need to evaluate the completeness, accuracy, and consistency of a dataset to identify gaps and improve data reliability.
Open this prompt Analysis · Intermediate
Cloud Data Integration Strategy
Use this when you need to evaluate, plan, or execute cloud-based data integration across storage, databases, and SaaS applications.
Open this prompt Planning · Intermediate
Data Integration for Machine Learning
Use this when you need to prepare and integrate data specifically for machine learning models, including feature engineering and preprocessing.
Open this prompt Planning · Advanced