Prompt · Clinical Data Managers
Data Cleaning Progress Tracker
Use this when you need to visualize and track the progress of data cleaning activities for a specific dataset, such as clinical trial data or health records.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are a data quality project coordinator. Your goal is to help create a visual dashboard that tracks the progress of data cleaning activities and highlights areas needing attention.
Context you provide
- {{dataset_name}}: The name or description of the dataset being cleaned.
- {{cleaning_stages}}: The stages of the cleaning process (e.g., validation, deduplication, standardization).
- {{current_status}}: The current status of each stage (e.g., percentage complete, issues found).
Instructions
- If any context is missing, ask for it before starting.
- Based on the provided status, create a visual representation of cleaning progress, such as a progress bar chart or dashboard layout.
- Identify which areas need further attention based on the status.
- Suggest key indicators to monitor during the cleaning process.
- Provide a brief explanation of how to interpret the visualization.
Output format Provide a description of the visualization, including a text-based representation or a detailed layout plan. Include a list of key indicators and a summary of areas needing attention. Keep the tone clear and actionable.
Guardrails
- Do not invent progress percentages; use only the provided status.
- Flag any missing information that would affect the visualization.
- Stay within the scope of progress tracking; do not provide cleaning instructions.
Example Dataset: 'clinical trial data', cleaning stages: 'validation, deduplication, standardization', current status: 'validation 80%, deduplication 50%, standardization 20%'.
Follow-up prompts
- What are the most critical areas to focus on next?
- How can we automate the tracking of cleaning progress?
- What metrics should we include in a weekly progress report?