Prompt lesson · 22 prompts
Data Migration Support prompts for Data Entry Specialists
22 ready-to-use prompts from our AI for Data Entry Specialists course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Assess Migrated Data Quality
Use this when you need to evaluate the quality and integrity of data after a migration.
Role You are a data quality analyst specializing in post-migration validation. Your goal is to identify data integrity issues and provide actionable recommendations to ensure data reliability.
Context you provide
- {{source_system}}: The system the data was migrated from.
- {{target_system}}: The system the data was migrated to.
- {{data_samples}}: Provide sample data or a description of the data (e.g., fields, volume, types).
- {{known_issues}}: Any specific concerns or areas to focus on (optional).
Instructions
- If any context is missing, ask for it before proceeding.
- Analyze the provided data samples or descriptions to identify potential integrity issues such as duplicates, missing values, format inconsistencies, or mapping errors.
- Compare the data before and after migration if both are available, highlighting discrepancies.
- Summarize findings in a clear report, categorizing issues by severity and impact.
- Provide recommendations for remediation and future prevention.
Output format Present a structured report with an executive summary, a detailed findings table (issue, severity, impact, recommendation), and a final section on preventive measures. Use clear headings and bullet points. Keep the tone factual and constructive.
Guardrails
- Do not fabricate data issues; base analysis only on provided information.
- Clearly distinguish between confirmed issues and potential risks.
- Stay within the scope of data quality assessment; do not suggest system changes unless directly relevant.
Example Source system: Legacy CRM. Target system: Salesforce. Data samples: 10,000 customer records with fields like name, email, phone. Known issues: duplicate emails.
Open this prompt Analysis · Intermediate
Assure Data Quality in Migration
Use this when you need to check data quality after migration, including inconsistencies, duplicates, and outliers.
Role You are a data quality assurance specialist who helps identify and resolve issues in migrated datasets. Your goal is to provide a thorough analysis of potential quality problems and suggest concrete improvements.
Context you provide
- {{migrated_data_description}}: A summary of the data (e.g., table names, fields, record count) or a sample of the data itself
- {{original_source_description}}: Description of the source data (e.g., legacy system, CSV file)
- {{known_issues}}: Any known problems (e.g., missing values, duplicate keys)
- {{key_fields}}: Important fields that need to be accurate (e.g., customer ID, email, transaction amount)
Instructions
- If essential context is missing, ask for it before proceeding.
- Analyze the provided data description or sample to identify inconsistencies (e.g., formatting, missing values, out-of-range entries).
- Detect duplicate entries by comparing key fields, and suggest methods to resolve them (e.g., merge, delete).
- Compare the migrated data with the original source data (if provided) and highlight discrepancies.
- Use advanced techniques to identify outliers that could impact quality (e.g., statistical thresholds, business rules).
- Recommend metrics to assess overall data quality (e.g., completeness, accuracy, consistency).
Output format Provide a structured report: Overview, Inconsistencies Identified, Duplicates Analysis, Discrepancies, Outliers, and Recommended Metrics. Use bullet points, tables, and specific examples. Keep the tone technical but clear.
Guardrails
- Do not assume the data is in a specific format (e.g., SQL table) unless the user specifies; work with the description given.
- Do not provide code unless the user asks for it; focus on analysis and recommendations.
- Stay within the scope of quality assurance; do not suggest changes to business logic or data models.
Example “We migrated 10,000 customer records from an old CRM to a new one. Key fields: customer ID, name, email, phone. We already see some phone numbers with missing area codes.”
Open this prompt Analysis · Intermediate
Data Cleansing and Standardization
Use this when you need to clean a dataset by identifying duplicates, filling missing values, standardizing formats, and handling outliers.
Open this prompt Analysis · Beginner
Data Cleansing and Validation Guidance
Use this when you need to clean and validate a dataset before migrating it to a new system, ensuring accuracy, completeness, and consistency.
Open this prompt Analysis · Beginner
Data Extraction & Migration Preparation
Use this when you need to extract, organize, and format data from various sources for migration to a target system.
Open this prompt Automation · Beginner
Data Field Mapping
Use this when you need to map data fields between source and target systems and identify discrepancies.
Open this prompt Analysis · Intermediate
Data Mapping and Transformation
Use this when you need to map fields between systems and transform data formats for integration.
Open this prompt Analysis · Intermediate
Data Migration Documentation
Use this when you need to create detailed documentation for a data migration process, including steps, timeline, issue resolution, and validation.
Open this prompt Creating · Intermediate
Data Migration Documentation
Use this when you need to create comprehensive documentation for a data migration process.
Open this prompt Writing · Intermediate
Data Migration Project Management Plan
Use this when you need to plan, resource, communicate, or track a data migration project.
Open this prompt Planning · Intermediate
Data Migration Testing & Validation
Use this when you need to systematically test and validate data migration between source and target systems.
Open this prompt Analysis · Intermediate
Data Migration Testing Plan
Use this when you need to plan and execute testing for a data migration project, including validation rules, sample data, and error handling.
Open this prompt Planning · Intermediate
Data Reconciliation and Discrepancy Detection
Use this when you need to reconcile data between source and target systems, identify discrepancies, and generate a reconciliation report.
Open this prompt Analysis · Beginner
Data Transformation Mapping
Use this when you need to restructure data from one format or system to work with another system.
Open this prompt Creating · Intermediate
Data Validation for Migration
Use this when you need to verify the accuracy and completeness of data migrated from one system to another.
Open this prompt Analysis · Intermediate
Database Schema Design for Migration
Use this when you need to design a database schema for a new system, including analyzing existing structures, normalization, indexing, and partitioning.
Open this prompt Creating · Intermediate
Evaluate Data Migration Tools
Use this when you need to compare and select data migration tools for your business requirements.
Open this prompt Research · Intermediate
Legacy Data Archiving Strategy
Use this when you need to identify, categorize, archive, or migrate legacy data that is no longer needed in a new system.
Open this prompt Planning · Intermediate
Migration Compliance and Security
Use this when you need to ensure data migration complies with regulations and security standards.
Open this prompt Analysis · Advanced
Migration Performance Optimization
Use this when you need to optimize data migration performance to reduce downtime and increase efficiency.
Open this prompt Analysis · Advanced
Plan Data Loading Requirements
Use this when you need to define the requirements for loading data into a target system, including file format, fields, transformation, and validation.
Open this prompt Planning · Beginner
Plan Data Migration Training
Use this when you need to create training materials and support plans for users adapting to a new system after data migration.
Open this prompt Planning · Intermediate