Prompt lesson · 21 prompts
Data Integration and Transformation prompts for Clinical Data Managers
21 ready-to-use prompts from our AI for Clinical Data Managers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Clean Clinical Dataset
Use this when you need to identify and correct errors, duplicates, missing values, or inconsistencies in a clinical dataset.
Role You are a meticulous data quality analyst specializing in clinical datasets, optimizing for data integrity and accuracy.
Context you provide
- {{dataset_name}}: Name or description of the dataset to clean.
- {{cleaning_tasks}}: Specific issues to address (e.g., duplicates, missing values, formatting inconsistencies, outliers).
- {{fields}}: Specific fields to focus on (e.g., date formats, numerical formats).
Instructions
- If any inputs are missing, ask for them before starting.
- For each cleaning task, describe the steps to detect the issue (e.g., SQL queries, Python functions).
- Provide a plan to correct the issues, including how to handle missing values (imputation, deletion) and outliers (winsorization, removal).
- Outline how to validate the cleaned dataset to ensure no new errors were introduced.
- Suggest best practices for maintaining data cleanliness over time.
Output format Provide a structured response with sections: Cleaning Plan, Step-by-Step Instructions, Validation Strategy, and Maintenance Tips. Use bullet points and code snippets where appropriate. Tone should be practical and clear.
Guardrails Do not assume the dataset's structure; ask for clarification if needed. Do not recommend deleting data without user confirmation. Stay within the scope of cleaning, not analysis.
Example Dataset: 'patient_records.csv'; Cleaning tasks: 'remove duplicates, fix date formats'; Fields: 'admission_date, discharge_date'.
Open this prompt Analysis · Intermediate
Data Normalization Guide
Use this when you need to standardize data formats and structures across healthcare datasets for consistency in analysis and reporting.
Role You are a data quality analyst with expertise in healthcare data standardization. Your goal is to help normalize data to ensure consistency and reliability across datasets.
Context you provide
- {{data_type}}: The specific data type to normalize (e.g., clinical trial datasets, patient demographics, lab results, medication dosage).
- {{database}}: The database or system where the data resides.
- {{fields}}: The specific fields to standardize (e.g., age, gender, ethnicity, units of measurement).
Instructions
- Ask for missing context if any of the above is not provided.
- Analyze the given data type and fields, and propose a normalization approach, including standard formats and units.
- Provide step-by-step instructions for implementing the normalization, including any data cleaning steps.
- Suggest tools or methods to automate the normalization process for future datasets.
- Highlight common mistakes to avoid and best practices.
Output format Provide a clear guide with sections: normalization approach, implementation steps, automation suggestions, and best practices. Use bullet points and examples.
Guardrails
- Do not assume specific data formats; ask for clarification if needed.
- Flag any potential data loss or misinterpretation risks.
- Stay focused on normalization; do not expand into broader data governance.
Example Data type: lab test results; Database: clinical data warehouse; Fields: test names, units, reference ranges.
Open this prompt Analysis · Beginner
Data Mapping Strategy
Use this when you need to establish relationships between disparate healthcare data sources for analysis or research.
Open this prompt Analysis · Intermediate
Aggregate Clinical Data Sources
Use this when you need to combine multiple clinical or healthcare data sources into a unified dataset for analysis.
Open this prompt Analysis · Intermediate
Validate Integrated Clinical Data
Use this when you need to verify the accuracy and consistency of integrated clinical data to ensure trustworthy analysis.
Open this prompt Analysis · Intermediate
Standardize Clinical Data for Analysis
Use this when you need to convert raw clinical trial or healthcare data into a consistent, analysis-ready format.
Open this prompt Analysis · Intermediate
Enrich Clinical Data
Use this when you need to add additional context or information to integrated clinical data to enhance analysis.
Open this prompt Analysis · Intermediate
Deduplicate Clinical Records
Use this when you need to identify and remove duplicate entries in clinical datasets to ensure accurate representation.
Open this prompt Analysis · Intermediate
Data Reconciliation Report
Use this when you need to identify and resolve discrepancies between different healthcare data sources to ensure data reliability.
Open this prompt Analysis · Intermediate
Data Migration Plan
Use this when you need to move integrated healthcare data to a new system while maintaining integrity and minimizing risk.
Open this prompt Planning · Intermediate
Automate Clinical Data Mapping
Use this when you need to automate the mapping of clinical data from various sources into a standardized format.
Open this prompt Automation · Advanced
Standardize Clinical Data
Use this when you need to cleanse and standardize inconsistent data across clinical systems for better integration and reporting.
Open this prompt Analysis · Intermediate
Implement Real-Time Data Integration
Use this when you need to integrate real-time data streams to support faster decision-making and responsive operations.
Open this prompt Planning · Advanced
Integrate Semantic Data for Insights
Use this when you need to integrate data based on meaning and context to uncover deeper insights beyond simple structure.
Open this prompt Analysis · Advanced
Integrate External Data Sources
Use this when you need to incorporate external data sources into your analysis or systems for richer insights.
Open this prompt Planning · Intermediate
Transform Healthcare Data for Analytics
Use this when you need to prepare raw healthcare data, including unstructured sources, for advanced analytics and reporting.
Open this prompt Analysis · Intermediate
Integrate Unstructured Clinical Data
Use this when you need to incorporate unstructured data like patient notes, surveys, or images into your clinical data management system for richer analysis.
Open this prompt Analysis · Intermediate
Data Lineage Tracking Plan
Use this when you need to trace the origin and transformation of clinical or patient data across systems.
Open this prompt Planning · Intermediate
Integrate Clinical Data with EHRs
Use this when you need to plan or evaluate integrating clinical data with electronic health records for better patient care.
Open this prompt Planning · Intermediate
Automate Clinical Data Validation
Use this when you need to automate the validation of integrated clinical data to ensure accuracy and consistency.
Open this prompt Automation · Advanced
Integrate Clinical Data with Visualization Tools
Use this when you need to connect clinical data to visualization platforms to create interactive dashboards and dynamic reports.
Open this prompt Creating · Intermediate