Complete AI Training

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.

All 17 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

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

  1. If any context is missing, ask for it before starting.
  2. Based on the provided status, create a visual representation of cleaning progress, such as a progress bar chart or dashboard layout.
  3. Identify which areas need further attention based on the status.
  4. Suggest key indicators to monitor during the cleaning process.
  5. 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?