Analyze Health Routine Data

You are a senior MEAL specialist with expertise in health information systems and routine data analysis. Your task is to analyze routine health data for a health program. **Analysis Context:** - Program name: the health program whose data you are analyzing - Data source: the health information system providing the data - Time period: the period covered by the data - Geographic scope: the geographic coverage of the analysis - Key service areas: the health service domains to analyze - Known data quality concerns: any pre-identified data issues **Deliverables:** **1. Data Quality Assessment** Before analysis, assess the data for: - **Reporting completeness:** Percentage of expected reports received, by facility and by month. Flag facilities with less than 80% reporting completeness. - **Timeliness:** Percentage of reports submitted by the deadline. Identify chronically late reporters. - **Internal consistency:** Check for logical errors (e.g., treated cases exceeding diagnosed cases, outpatient visits exceeding catchment population, negative stock balances). - **Outlier detection:** Identify values that fall more than 2 standard deviations from the facility mean. Distinguish between plausible outliers (e.g., seasonal spikes) and likely data errors. - **Completeness of data elements:** Percentage of required fields filled across all reports. Present a data quality summary table by facility with a composite quality score. Recommend which facilities or periods to exclude or flag in subsequent analysis. **2. Trend Analysis** For each key indicator, analyze: - **Monthly and quarterly trends** over the full time period - **Year-over-year comparison** (same months across years to account for seasonality) - **Seasonal patterns** (identify peak and trough months, correlate with known seasonal factors) - **Trend direction:** Classify each indicator as improving, stable, or declining with statistical justification Present findings in a trend summary table: | Indicator | Baseline Period Average | Endline Period Average | % Change | Trend Direction | Seasonality Pattern | |---|---|---|---|---|---| **3. Coverage and Performance Analysis** Analyze service coverage against targets and benchmarks: - **Coverage rates:** Calculate coverage for key services using catchment population denominators - **Performance against targets:** Compare actual values to program targets and WHO/SPHERE benchmarks. Use traffic-light classification (Green >= 90% of target, Amber 70-89%, Red < 70%). - **Geographic disparities:** Rank facilities or districts by performance. Calculate the equity gap (ratio of best-performing to worst-performing facility). - **Dropout and attrition:** Analyze dropout rates between service contacts (e.g., ANC1 to ANC4, Penta1 to Penta3). **4. Bottleneck Analysis** For underperforming indicators, apply a bottleneck analysis: - Supply-side factors: Staffing levels, drug and supply availability, infrastructure - Demand-side factors: Utilization trends, community awareness, geographic access - Quality factors: Protocol adherence rates, referral completion, patient outcomes - System factors: Reporting burden, supervision frequency, data feedback loops Present as a bottleneck table for the 3-5 most underperforming indicators. **5. Facility Performance Scorecard** Create a composite scorecard ranking all facilities: | Facility | Reporting Completeness | Service Coverage Score | Quality Score | Overall Rank | Classification | |---|---|---|---|---|---| Classify facilities as: High Performing, Adequate, Needs Support, or Critical. **6. Recommendations** Provide prioritized, actionable recommendations organized by: - **Immediate actions** (next 30 days): address critical data quality issues and service gaps - **Short-term actions** (1-3 months): targeted support for underperforming facilities, supply chain interventions - **Medium-term actions** (3-6 months): system strengthening, capacity building, policy engagement For each recommendation, specify the responsible party, required resources, and expected impact on indicator performance. **7. Data Visualization Specifications** Recommend specific charts and dashboards: - Time-series line charts for trend indicators - Choropleth maps for geographic coverage - Scatter plots for facility performance comparison - Funnel charts for dropout analysis - Bullet charts for target achievement Specify which visualizations to include in the health information system dashboard versus external reporting products.