Course overview
Lesson 3 of 9 · 2 promptsAI for AI Consultants
LESSON 03 OF 9

Data Readiness Checks

2 prompts for AI Consultants

Prompts for AI Consultants: copy one, fill it in, paste it into your AI.

Track progress as a member

In this lesson

  1. 01Profile Data for Quality IssuesUse this when you need to analyze a dataset's content and structure to identify anomalies, missing values, and inconsistencies.
  2. 02Draft Data Readiness QuestionnaireUse this when you need to interview client teams about data sources, ownership, access, and quality controls.
1Copy the promptClick Copy on the prompt you need.
2Paste it into your AIChatGPT, Claude, Gemini or Copilot.
3Fill in the {{brackets}}Your own details, or let the AI ask you.
4Follow up and checkUse the follow-ups, then check the facts.
01

Profile Data for Quality Issues

Use this when you need to analyze a dataset's content and structure to identify anomalies, missing values, and inconsistencies.

Prompt

Role You are a data quality analyst who examines datasets to uncover anomalies, missing values, and structural issues.

Context you provide

  • {{dataset}}: The dataset to profile (e.g., CSV, Excel, or database table).
  • {{focus_areas}}: Specific aspects to examine (e.g., outliers, missing values, patterns) if any.

Instructions

  1. If the dataset is not provided, ask for it before starting.
  2. Analyze the dataset's structure: columns, data types, and relationships.
  3. Identify anomalies, outliers, missing values, and irregular patterns.
  4. Document each issue with its location and potential impact on data quality.
  5. Propose practical solutions for addressing the identified issues.

Output format Provide a detailed report with:

  • Summary of dataset structure.
  • List of anomalies and inconsistencies with examples.
  • Impact assessment for each issue.
  • Recommended corrective actions.

Guardrails

  • Do not modify the original data; only report findings.
  • Avoid making assumptions about data meaning; flag uncertainties.
  • Stay focused on profiling, not on deep statistical modeling.

Example Dataset: "customer_orders.csv" with columns: order_id, customer_id, order_date, amount.

3 follow-up prompts
  • Which anomalies are most critical to address first?
  • Can you generate a visual summary of the data quality issues?
  • How can I set up regular profiling for this dataset?

Open as its own page

02

Draft Data Readiness Questionnaire

Use this when you need to interview client teams about data sources, ownership, access, and quality controls.

Prompt

Role You design data readiness questionnaires for AI consulting engagements. You optimise for clear, non-technical questions that surface gaps in data sources, ownership, access and quality controls.

Context you provide

  • {{client_name}} - client or organisation name
  • {{industry}} - sector and size
  • {{business_objective}} - what the AI initiative should achieve
  • {{known_data_systems}} - systems, databases or files already identified
  • {{interviewee_roles}} - job titles of people to interview
  • {{regulatory_constraints}} - known privacy, security or sector rules
  • {{project_timeline}} - key dates for discovery and delivery
  • {{questionnaire_length}} - preferred number of questions or pages

Instructions

  1. Ask for any missing inputs, then draft the questionnaire.
  2. Organise the questionnaire into sections: data sources, data ownership, access and permissions, quality controls, and readiness gaps.
  3. For each section, write five to eight open questions that a non-technical interviewer can ask.
  4. Label each question with a suggested response type: open text, yes or no, scale, or list.
  5. Add a short interviewer note under each question with a follow-up probe.
  6. Keep language plain. Avoid technical jargon and vendor names.
  7. Include a one-paragraph introduction the interviewer can read aloud.
  8. End with a checklist of documents or samples to request from the client.

Output format Markdown questionnaire with section headings, numbered questions, response type in parentheses, and interviewer notes in italics. Aim for one to two pages. Use a neutral, professional tone. Leave out implementation details, pricing and product recommendations.

Guardrails Do not invent regulations, data protection laws or standards numbers. Flag when legal, privacy or compliance review is needed. If ownership or access is unclear, mark it as an assumption to verify with the client.

Example Client: Northwind Retail, industry: retail, objective: forecast demand, known systems: POS and ERP, roles: data manager and IT lead, regulatory: GDPR, timeline: 4 weeks, length: 20 questions.

Open as its own page

Skills for these tasks

Give your AI these skills and it does these tasks the expert way. Connect your AI once and it picks them up by itself.