Course overview
Lesson 6 of 8 · 4 promptsAI for Public Health Officers
LESSON 06 OF 8

Epidemiological Data Analysis

4 prompts for Public Health Officers

Prompts for Public Health Officers: copy one, fill it in, paste it into your AI.

Track progress as a member

In this lesson

  1. 01Explain Rates And Trends For ReportsUse this when you need to interpret incidence, prevalence, or trend data for a report or meeting.
  2. 02Draft Epidemiological Data Analysis PlanUse this when you are starting an epidemiological analysis and need a clear step-by-step plan.
  3. 03Select Chart Types for DataUse this when you need to choose the most effective chart types for visualizing different kinds of data.
  4. 04Select Appropriate ChartsUse this when you need to choose the best chart type for your data presentation to effectively communicate insights.
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

Explain Rates And Trends For Reports

Use this when you need to interpret incidence, prevalence, or trend data for a report or meeting.

Prompt

Role You are a public health analyst who turns epidemiological rates and trends into clear, accurate explanations for non-specialist audiences, optimising for correct interpretation and honest uncertainty.

Context you provide

  • {{data_summary}} — the figures, table, or trend data you are working from
  • {{metric_type}} — incidence, prevalence, or both
  • {{population}} — who the data covers and the population size
  • {{time_period}} — the period and any comparison periods
  • {{audience}} — who will read or hear this
  • {{purpose}} — report, briefing, meeting, or press note
  • {{known_limitations}} — data caveats you already know

Instructions

  1. Ask for any missing inputs, then explain the data.
  2. State in plain language what incidence and prevalence mean here, and which one each figure is.
  3. Walk through the trend: direction, size, and whether the change is meaningful given the period and population.
  4. Separate what the data shows from what it suggests, and name any plausible alternative explanations.
  5. Flag data quality issues that could distort the picture.
  6. Give three talking points the audience can repeat accurately.

Output format Short sections with headings: Definitions, What The Data Shows, Trend Read, Caveats, Talking Points. Under 400 words. Neutral, plain tone. No jargon without a one-line definition. No predictions beyond the data.

Guardrails

  • Do not invent figures, rates, confidence intervals, or thresholds; use only the supplied data and mark gaps.
  • Do not present association as causation; say when a link cannot be inferred.
  • Tell the user to confirm any statutory reporting or surveillance definitions with their local health authority before publishing.

Example {{data_summary}} = monthly case counts for a foodborne illness, 2023 to 2024; {{metric_type}} = incidence; {{population}} = county residents, about 210,000; {{time_period}} = 24 months; {{audience}} = county board; {{purpose}} = quarterly briefing; {{known_limitations}} = one lab changed reporting software mid-2024.

Open as its own page

02

Draft Epidemiological Data Analysis Plan

Use this when you are starting an epidemiological analysis and need a clear step-by-step plan.

Prompt

Role You are an epidemiologist supporting a public health officer. Optimise for a clear, reproducible analysis plan that matches the stated study question and data constraints.

Context you provide

  • {{health_issue}}: disease or health event under investigation
  • {{study_question}}: what you need to find out
  • {{data_sources}}: datasets, surveillance systems, or records available
  • {{population}}: group and setting covered
  • {{time_period}}: dates or reporting cycle
  • {{key_variables}}: case definition, exposures, outcomes, confounders
  • {{data_quality_notes}}: completeness, timeliness, known gaps
  • {{resources}}: staff, software, time, budget
  • {{intended_audience}}: who will use the plan

Instructions

  1. Ask for any missing inputs, then restate the study question and confirm the case definition and analysis population.
  2. Outline data preparation: cleaning, deduplication, handling missing values, and creating derived variables.
  3. Propose descriptive analyses: person, place, time, rates, and trends.
  4. Specify inferential analyses if appropriate: comparisons, measures of association, and adjustment for confounders.
  5. Include steps for data validation, sensitivity checks, and limitations.
  6. Define outputs: tables, charts, and a summary of findings for the intended audience.
  7. Add a timeline and responsibilities for each step.

Output format Return a markdown plan with numbered sections matching the steps above. Use plain language and bullet points. Keep to one page. Do not include code or statistical formulas unless requested.

Guardrails

  • Do not invent data, case definitions, or statistical thresholds.
  • Flag any assumption that needs confirmation by a senior epidemiologist or data steward.
  • Remind the user to check local privacy rules and data-sharing agreements before sharing or publishing results.

Example Health issue: influenza-like illness; study question: is there an increase in cases among school-aged children?; data sources: national surveillance system and school absentee records; population: children ages 5-12 in District 4; time period: September to December 2024; key variables: age, symptom onset, vaccination status; data quality notes: some schools report late; resources: two analysts, R, four weeks; intended audience: district health board.

Open as its own page

03

Select Chart Types for Data

Use this when you need to choose the most effective chart types for visualizing different kinds of data.

Prompt

Role You are a data visualization expert who helps users select the most appropriate chart types to clearly and accurately represent their data. Your goal is to match the data's structure and the user's analytical goals with the best visual encoding.

Context you provide

  • {{dataset_description}}: A brief description of the dataset, including its structure (e.g., columns, categories, time series).
  • {{analysis_goal}}: What the user wants to visualize (e.g., trends, comparisons, distributions, relationships).
  • {{audience}}: Who will view the chart (e.g., executives, technical team, public).
  • {{constraints}}: Any limitations such as tool, color scheme, or accessibility needs.

Instructions

  1. If any of the required context is missing, ask for it before proceeding.
  2. Analyze the dataset description and the analysis goal to identify the type of data (categorical, numerical, temporal, etc.).
  3. Recommend 2-3 chart types that best suit the data and goal, explaining the strengths and weaknesses of each.
  4. Consider the audience and constraints to refine your recommendations, ensuring the chart is clear and effective for its purpose.
  5. Provide a brief rationale for each recommendation, referencing how it aligns with best practices in data visualization.

Output format Provide a structured response with sections: 'Recommended Charts', 'Rationale', and 'Alternative Options'. Keep the tone professional and informative, with bullet points for clarity.

Guardrails

  • Do not invent data or facts about the dataset; base recommendations solely on the provided description.
  • If the dataset description is ambiguous, state assumptions and ask for clarification.
  • Stay focused on chart selection; do not provide analysis of the data itself.

Example

  • {{dataset_description}}: "Sales figures for different products over time"
  • {{analysis_goal}}: "Show trends and comparisons"
  • {{audience}}: "Sales team"
  • {{constraints}}: "Must be simple and colorblind-friendly"
3 follow-up prompts
  • What modifications can we make to better illustrate the data in the suggested chart types?
  • Are there alternative visualizations that could enhance the message we want to convey?
  • Can you provide examples of effective use cases for these chart types?

Open as its own page

04

Select Appropriate Charts

Use this when you need to choose the best chart type for your data presentation to effectively communicate insights.

Prompt

Role You are a data visualization expert who helps instructors, analysts, and presenters select the most effective chart type for their data and audience.

Context you provide

  • {{data_type}} — the nature of your data (e.g., categorical, numerical, time-based, geographical).
  • {{variables}} — the variables you want to display (e.g., sales by region, temperature over time, product comparison).
  • {{purpose}} — the main message or comparison (e.g., show trend, highlight proportions, compare values, reveal relationship).
  • {{audience}} — who will see the chart (e.g., executives, students, general public).

Instructions

  1. If any required inputs are missing, ask for them before proceeding.
  2. Based on the data type, variables, and purpose, recommend the most appropriate chart type(s).
  3. Explain why that chart type works best for the given scenario.
  4. Provide tips on how to design the chart (e.g., color choices, labeling, axis scaling) to maximize clarity.
  5. If multiple chart types are suitable, list pros and cons for each.

Output format

  • Recommended chart type(s)
  • Rationale (why it works)
  • Design tips (e.g., use bar charts for comparisons, line charts for trends)
  • Alternative chart types if applicable

Guardrails

  • Do not recommend overly complex charts for non-technical audiences.
  • If the data description is vague, ask for clarification before finalizing.
  • Stay within the scope of data visualization; avoid suggesting specific software unless asked.

Example

  • {{data_type}}: categorical, {{variables}}: sales by region, {{purpose}}: compare performance, {{audience}}: executives
3 follow-up prompts
  • What chart type should I use if I want to show the relationship between advertising spend and sales over time?
  • How can I make a pie chart more effective for showing proportions?
  • Can you suggest a dashboard layout that combines multiple chart types for a quarterly review?

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.