100 Best ChatGPT Excel Data Analysis Prompts for Optometrists

Direct Answer

The best ChatGPT prompts for Excel data analysis for optometrists are designed to extract clear insights from patient and clinic data, automate routine checks, and build dashboard-ready outputs. Each prompt below is action-oriented, includes placeholders you can fill, and specifies the desired format to save time and improve decisions. Use them to standardize reporting and accelerate data-driven care.

Introduction

This page provides a practical, topic-focused prompt library for Excel data analysis tailored to optometry clinics. It helps clinicians, analysts, and admins turn raw patient and operations data into actionable insights.

The prompts are crafted to be copyable and immediately usable without needing to invent missing context, enabling fast, repeatable analysis in real-world clinic settings.

How to Use These ChatGPT Prompts

• Replace placeholders like dataset, start_date, and end_date with your actual files and dates.
• Add constraints such as date ranges, service types, or region to narrow the analysis.
• Specify output formats such as CSV tables, pivot-ready data, or brief summaries so ChatGPT returns immediately usable outputs.
• Request verification steps or a short interpretation to ensure the results align with your goals.

100 Best ChatGPT Excel Data Analysis Prompts for Optometrists

1. Data cleaning checklist: Act as a data cleansing consultant for an optometry clinic. You are given a dataset named [dataset] with columns [columns]. Your task is to identify duplicates, standardize date formats, correct misspelled patient names, and flag outliers in test results. Output a clean dataset in CSV format with an accompanying summary of changes and a list of any records that require manual review.
2. Average visit duration: You are an analytics assistant for a vision clinic. Given [dataset] with fields [visit_id, patient_id, visit_date, start_time, end_time, service_type], compute the average visit duration per patient and per service_type for the period [start_date] to [end_date]. Provide a CSV table with patient_id, service_type, avg_duration_minutes, and count_of_visits. Include a brief interpretation in one paragraph.
3. Monthly patient trend: Take [dataset] with fields [visit_date, patient_id, age, gender, diagnosis]. Produce a line chart data series showing monthly new patient counts and returning patient counts for the period [start_month] to [end_month]. Provide a CSV with month, new_patients, returning_patients and a brief takeaway.
4. Cohort analysis by age: Using [dataset] with fields [patient_id, signup_date, birth_year, diagnosis, treatment_outcome], create age cohorts (e.g., 0-17, 18-35, 36-60, 61+) and compute retention rate per cohort over the last 12 months. Return a table with cohort, size, retained, retention_rate and a short actionable insight.
5. Diagnostics yield by service: Given [dataset] with columns [service_type, diagnosis, outcome], calculate the yield (positive diagnosis rate) for each service_type over [start_date] to [end_date]. Output a summary table and a chart-ready dataset with service_type, total_cases, positive_cases, yield_percent.
6. Top procedures by volume: From [dataset] with [service_type, date_performed, clinician, patient_age], identify the top five procedures by volume in the period [start_date] to [end_date]. Provide a ranked table with procedure, volume, percentage_of_total, and a one-sentence recommendation.
7. Revenue by service type: Using [dataset] with fields [service_type, revenue, date_of_service], compute monthly revenue by service_type for [start_month] to [end_month]. Output a pivot-ready table: month, service_type, revenue, growth_rate_from_prev_month, and a one-line conclusion.
8. Payer mix analysis: Analyze payer mix from [dataset] with fields [payer, service_type, revenue], for the period [start_date] to [end_date]. Produce a report showing payer, share_of_revenue, and a 2-sentence implication for pricing or coding practices.
9. No-show impact analysis: In [dataset] with fields [appointment_id, patient_id, scheduled_time, attended], compute no-show rate by weekday and by provider for [start_date] to [end_date]. Output a table and a short action plan to reduce no-shows.
10. Follow-up effectiveness: From [dataset] with [patient_id, follow_up_date, outcome, next_step], determine the rate of successful follow-ups within 14 days of initial visit. Provide a table by outcome and a concise operational recommendation.
11. Average test result: For [dataset] containing [test_name, test_value, unit, patient_id, date], compute the average and median test_value per test_name for [start_date] to [end_date]. Return a CSV with test_name, average, median, count.
12. Vision outcome by age group: Using [dataset] with fields [age_group, diagnosis, treatment, outcome], compare visual acuity improvements across age groups. Produce a table and a stub for a chart: age_group, mean_change, outcome_rate, n.
13. Treatment plan adherence: From [dataset] with [patient_id, plan_accepted, plan_follow_up, date], measure adherence rate to recommended treatment plans across [start_date] to [end_date]. Output a table per clinician and a 2-line takeaway.
14. Appointment wait times: Given [dataset] with [appointment_id, scheduled_time, arrival_time, provider], compute average wait time per provider in [start_date] to [end_date]. Output a table and a brief interpretation.
15. Inventory turnover: For [dataset] with fields [item_id, item_name, stock_level, used_date, quantity_used], calculate monthly inventory turnover and days on hand. Provide a table with item_id, turnover_rate, days_on_hand and a practical reorder recommendation.
16. Productivity per clinician: From [dataset] listing [clinician_id, patient_id, service_type, duration_minutes, date], compute average duration per service_type per clinician for [start_date] to [end_date]. Output a table with clinician_id, service_type, avg_duration, and count.
17. Eye exam outcome split: Using [dataset] with [exam_id, result, refractive_error, age], classify outcomes into categories (pass, borderline, fail) and provide counts and percentages for [start_date] to [end_date]. Output a summary table and a one-sentence recommendation.
18. Referral source analysis: From [dataset] with [referral_source, patient_id, date], compute the share of new patients by source for [start_date] to [end_date]. Provide a table and a 2-sentence strategy suggestion.
19. Region performance: With [dataset] including [region, patient_visits, revenue], compare performance across regions over [start_date] to [end_date]. Output a ranked table by visits and revenue with a brief regional takeaway.
20. Seasonality check: Analyze [dataset] with [date, visits, revenue] to identify seasonality patterns for the last 24 months. Output a seasonal decomposition data set for plotting and a two-line interpretation.
21. Quality control checklist: Create a quality control checklist for Excel dashboards used in optometry practice. Include data validation steps, formula checks, and anomaly detection rules. Provide an actionable checklist in bullet form.
22. Clinic KPI dashboard: Design a KPI dashboard blueprint in Excel for an optometry clinic covering patient volume, revenue, wait times, and follow-up rates. List metrics, data sources, and example chart types in a compact spec.
23. Cohort profitability: From [dataset] with [cohort_id, revenue, cost, patient_count], compute profitability per cohort and provide a chart-ready table with cohort, profit, profit_margin, and patient_count.
24. New vs returning patients: Given [dataset] with [patient_id, first_visit, visits_count], classify patients into new and returning for [start_date] to [end_date]. Output a table with category, count, and share.
25. Service mix by month: From [dataset] with [date, service_type, revenue], create a month-by-service_type revenue table for [start_month] to [end_month]. Output a pivot-ready data structure and a 2-line insight.
26. Billing error detection: Scan [dataset] with [claim_id, amount_billed, amount_paid, date_of_service, payer] for discrepancies between billed and paid amounts. List mismatches and provide a remediation note for each.
27. Test score distribution: Using [dataset] with [test_name, score, date], compute distribution statistics (mean, median, standard deviation) for each test_name over [start_date] to [end_date]. Output a table and a histogram-ready dataset.
28. Patient segment by diagnosis: Cluster patients in [dataset] by diagnosis and age into segments. Provide a table with segment, average_age, dominant_diagnosis, and recommended outreach actions.
29. Outcome variance by clinician: From [dataset] with [clinician_id, outcome, date], compare outcome variance across clinicians for [start_date] to [end_date]. Return a table and a 2-sentence note on practice improvement.
30. Test result benchmarks: Compare [dataset] test results to internal benchmarks. For each test_name, provide percentile ranks and flag results outside the 5th or 95th percentile. Output a table and a short advisory.
31. Inventory aging report: Create an aging report from [dataset] with [item_id, stock_level, days_since_received]. Classify items into age bands and propose deprecation actions.
32. Patient heatmap readiness: Prepare a heatmap-ready dataset from [dataset] with [patient_id, region, age, diagnosis, value_metric]. Provide a matrix-ready data structure and a 1-sentence interpretation.
33. Referral conversion rate: From [dataset] with [referral_source, converted, date], calculate conversion rate by source for [start_date] to [end_date]. Output a table and 2 actionable strategies.
34. Outcome by treatment type: Analyze [dataset] with [treatment_type, outcome, date] to determine which treatments yield the best outcomes. Return a table with treatment_type, outcome_rate, and a brief recommendation.
35. Data quality score: Develop a data quality score for [dataset] with fields [missing_values, duplicates, outliers, consistency_issues]. Provide a scorecard and remediation steps.
36. Clinician workload: From [dataset] with [clinician_id, tasks_completed, duration], compute workload metrics per clinician for [start_date] to [end_date]. Output a table and a 1-line action item.
37. Cost per patient: Calculate cost per patient for [dataset] with [patient_id, cost, date]. Provide a year-over-year comparison and a short note on efficiency.
38. Acuity distribution: Analyze [dataset] with [acuity_level, service_type, date] to show distribution of patient acuity across services. Output a table and a one-line takeaway.
39. Data dictionary generator: Create a concise data dictionary for [dataset], listing field_name, data_type, allowed_values, and a one-line usage note for analysts.
40. Clinician performance insight: From [dataset] with [clinician_id, patient_satisfaction, outcomes], generate a performance insight per clinician and a recommended improvement plan.
41. Appointment adherence by day: Using [dataset] with [day_of_week, adherence_rate], compare adherence across days and return a ranked table with day_of_week, adherence_rate and recommended actions.
42. Follow-up funnel: From [dataset] with [stage, count], map the follow-up funnel for [start_date] to [end_date]. Output a table and 2-step optimization ideas.
43. Patient demographic mix: Analyze [dataset] to show demographic distribution by age, gender, and region for [start_date] to [end_date]. Provide a table and a 1-line takeaway.
44. Outlier detection: In [dataset] with [value_column], run a robust outlier detection and list records flagged as outliers with a brief justification.
45. Policy compliance check: From [dataset] verify coding and billing compliance against clinic policy. Return a compliance score and a list of non-compliant records.
46. Seasonal revenue lift: Identify months with revenue deviations exceeding 15 percent from the mean in [dataset] for [start_date] to [end_date]. Provide a table and a 2-line conclusion.
47. Patient retention cohorts: Create retention cohorts by signup_date and compute retention at 1, 3, and 6 months. Output a table and a brief interpretation.
48. Service profitability by provider: From [dataset] with [provider_id, service_type, revenue, cost], calculate profit margin per provider and service. Return a table and a one-sentence note.
49. Patient satisfaction trend: Analyze [dataset] with [survey_score, date, provider] to identify satisfaction trends over time. Provide a table and a short recommendation.
50. Reorder point calculator: Based on [dataset] with [item_id, stock_level, lead_time, daily_use], compute reorder point and suggested order quantity. Output a table and a one-line note.
51. Zero-visit outreach: From [dataset] with [patient_id, last_visit_date], generate a list of patients due for outreach within the next 30 days and provide a templated outreach message per patient segment.
52. Diagnostic yield by clinician: Given [dataset] with [clinician_id, diagnosis, yield], compare yield across clinicians for [start_date] to [end_date]. Output a table and a brief strategy.
53. Ethnicity and language mix: From [dataset] with [ethnicity, language, region], analyze distribution for [start_date] to [end_date]. Provide a table and two actionable recommendations to improve accessibility.
54. Video captioning prompt: Create alt-text captions for a dataset-driven dashboard. Describe each chart in 1-2 sentences suitable for accessibility and a one-line chart summary.
55. Data visualization plan: Outline a visualization plan in Excel for the clinic's top three metrics. Include chart types, data sources, update frequency, and a one-paragraph rationale.
56. Quality control thresholds: Define practical thresholds in Excel to flag data quality issues for [dataset], including ranges, formats, and alert rules. Return a rule list and example alert messages.
57. Appointment capacity scenario: Model three capacity scenarios in Excel for [start_date] to [end_date] based on whitelisted staffing. Output a scenario table and a 2-sentence recommendation.
58. Data import checklist: Provide an import plan for new patient data into [dataset], including mapping, validation, deduplication steps, and error handling.
59. Shot list by region: From [dataset] with [region, shots_given, date], compare regional uptake of a new vision test. Output a region table and a 1-line insight.
60. Service wait time forecast: Create a 4-week forecast of service wait times in Excel using [dataset] with [date, wait_time, service_type]. Output a forecast table and a short interpretation.
61. Error rate by data source: From [dataset] across sources [source1, source2], compute error rate per source and recommend data-source consolidation actions. Provide a table and a 1-line takeaway.
62. Patient risk scoring: Develop a simple risk score for patients using [dataset] with [age, diagnosis, visit_frequency, comorbidities]. Output a score column and top 10 high-risk patients.
63. Vision screening yield: Analyze [dataset] for vision screening results and compute yield by age group. Output a table and a brief plan to improve screening adherence.
64. Referrals vs outcomes: From [dataset] correlate referral source with treatment outcomes. Provide a table of outcomes by source and a 2-line implication for referral strategy.
65. Cost-saving opportunities: Identify cost-saving opportunities in [dataset] by comparing cost per procedure across providers. Output a ranked list of opportunities and a one-line recommendation.
66. Follow-up timing optimization: Suggest optimal follow-up timing for post-diagnosis patients using [dataset] with [diagnosis, follow_up_date, outcome]. Provide a plan and a one-line rationale.
67. Warranty and service prompts: If the clinic offers equipment warranties, analyze [dataset] for warranty claims by device type and date. Output a table and a short note on device reliability.
68. Data privacy checklist: Create a data privacy checklist for handling patient data in Excel dashboards, covering access controls, masking, and storage. Provide a concise checklist.
69. Scenario planning by season: Build two seasonal scenario plans in Excel for [start_date] to [end_date] based on historical data in [dataset]. Output scenario tables and a 1-line takeaway.
70. Compliance calendar: Generate a compliance calendar from [dataset] noting reporting deadlines and required records. Output a month-by-month plan and a short note.
71. Procedure recommended rate: From [dataset] compute the recommendation rate for different procedures based on utilization and outcomes. Provide a table and a 2-line insight.
72. Cost center analysis: Split [dataset] by cost_center and analyze revenue vs cost. Output a table with cost_center, revenue, cost, margin, and a one-line conclusion.
73. Data lineage map: Create a simple data lineage map for [dataset], listing sources, transformations, and downstream reports. Provide a text-based diagram and a short explanation.
74. Anomaly detection alert: Set up anomaly detection in Excel for [dataset] with a rule to flag values deviating beyond two standard deviations. Output flagged records and alert summary.
75. Patient outreach script: Generate templated outreach messages for patients due for follow-up based on [segment]. Provide scripts tailored to age group and diagnosis.
76. Clinic utilization heatmap: Prepare a dataset suitable for a utilization heatmap by region and month from [dataset]. Output a matrix-ready data structure and a one-line insight.
77. Referral conversion by provider: From [dataset] compute referral conversion rate per provider for [start_date] to [end_date]. Output a table and a 2-line action plan.
78. Appointment type distribution: Analyze [dataset] for appointment types (new, follow-up, urgent) and report distribution by month. Provide a table and a 1-line takeaway.
79. Wait time distribution: From [dataset] compute the distribution of wait times by service_type and provider. Output a histogram-ready dataset and a brief interpretation.
80. Data normalization rules: List explicit normalization rules to standardize unit measures and date formats in [dataset]. Provide a rule list and example before/after values.
81. Clinic revenue forecast: Forecast monthly revenue for the next 6 months using [dataset] with historical revenue. Output a table with month, forecast_revenue, and confidence_hint.
82. Top diagnoses by age: From [dataset] identify top five diagnoses for each age group and provide a table with age_group, diagnosis, count, and share.
83. Treatment outcome heatmap: Create a matrix showing treatment_type vs outcome rates using [dataset]. Output a ready-to-plot data structure and a one-line interpretation.
84. Data quality scorecard: Generate a scorecard for data quality across key fields in [dataset], listing metrics and current scores. Provide recommended fixes per issue.
85. Patient contact update: From [dataset] prepare a list of patients with outdated contact info and provide a templated update request message.
86. Provider utilization by hour: Analyze [dataset] to show provider utilization by hour of day for [start_date] to [end_date]. Output a table and 2-line suggestion.
87. Follow-up automation plan: Design an automation plan in Excel for sending follow-up reminders based on [dataset] with [days_since_last_visit, outcome]. Include trigger rules and message templates.
88. Comparison to benchmarks: Compare clinic metrics in [dataset] to internal benchmarks. Show gaps where metrics fall short and propose improvement ideas in a table.
89. Demographic growth projection: Forecast patient demographics for the next 12 months using [dataset] as base. Output projections by age and region and a brief note.
90. Data enrichment suggestions: Suggest data enrichments to add to [dataset] to improve insights. List enrichment items and expected impact in 2 sentences.
91. Quality issue root cause: For records flagged in [dataset], perform a root cause analysis and provide one recommended fix and a preventive control.
92. Clinic growth plan: Outline a 90-day Excel-driven growth plan for an optometry clinic based on [dataset] metrics. Include goals, milestones, and measurement methods.
93. Patient segmentation prompts: Create segmentation prompts in Excel for patients by behavior, diagnosis, and value. Provide label definitions and example row-level formulas.
94. Data merge template: Provide a template for merging [dataset] from multiple sources into a unified sheet in Excel, including column mappings and conflict resolution rules.
95. Error logging template: Provide an error-logging template for data imports in Excel dashboards, including fields, severity, and remediation steps.
96. Outreach ROI calculator: From [dataset] compute outreach campaign ROI by channel. Output a table with channel, cost, revenue, net_profit, and ROI.
97. Patient risk alerts: Set up risk alert rules in Excel for high-risk patients based on [dataset] with [risk_score, age, diagnosis]. Provide alert criteria and a sample alert message.
98. Data snapshot generator: Create a compact data snapshot for senior management from [dataset], including key metrics, trends, and top 3 insights in bullet form.
99. Audit trail generator: Generate an audit-friendly summary for changes made to [dataset], listing timestamp, user, and change description for each major update.
100. Excel prompts for optometry prompts: Act as an Excel data analyst for optometry. Produce concise, repeatable prompts for ongoing Excel analysis tasks in this topic, with fields to customize [dataset], [date], [region], and [metric].

Best Practices

• Use precise field names and consistent date formats to reduce errors.
• Keep prompts focused on a single objective to improve accuracy and reproducibility.
• Ask for both tabular data and a short interpretation to help with quick decision-making.
• Save and reuse successful prompts as templates for similar analyses.
• Review outputs for clinical plausibility and align with privacy guidelines when sharing results.

Common Mistakes to Avoid

• Asking for overly broad analyses that combine too many variables at once.
• Using vague terms like analyze all data without constraints, causing noisy results.
• Neglecting to specify output formats or validation steps, leading to unusable results.
• Forgetting to standardize date formats or units across datasets, causing mismatches.

FAQ

Who should use these prompts?

Optometrists, clinic data analysts, and practice managers who want actionable Excel-based analyses built on real patient and operations data.

Do these prompts require programming skills?

No. Each prompt is designed to be copied into ChatGPT with placeholders filled in; it targets Excel-based outputs and simple data tasks.

Can I adapt prompts to different EHR exports?

Yes. Replace dataset and field placeholders with your actual export naming and column headers to tailor the prompts.

How do I verify the results?

Cross-check key figures with a manual calculation or a secondary data source and request a brief interpretation to confirm insights.

Are the prompts compliant with patient privacy rules?

Yes, avoid sharing identifiable data in public outputs and follow local privacy regulations when handling patient information.

How often should I refresh these prompts?

Refresh prompts when your data schema changes, new metrics are needed, or reporting requirements evolve.