Charts in the Time of Cholera (B): Saving Lives with Data Visualizations in the 21st Century Custom Case Solution & Analysis

Evidence Brief: Modern Epidemiological Data Visualization

1. Financial Metrics

• Funding Gap: The United Nations requested 1.1 billion dollars for the Haiti cholera response; however, less than 50 percent of this amount was committed within the first twelve months of the outbreak.
• Operational Cost: Treatment center establishment costs averaged 15,000 to 25,000 dollars per unit, depending on geographic accessibility.
• Economic Impact: Estimates suggest the outbreak resulted in a 3 percent contraction in local agricultural productivity in the Artibonite region due to labor illness and death.

2. Operational Facts

• Case Volume: Over 600,000 recorded cases and 7,000 deaths within the first 24 months of the 2010 Haiti outbreak.
• Transmission Speed: The disease traveled from the central highlands to the coast in less than 72 hours via the Artibonite River.
• Data Lag: In rural districts, the time between a patient presenting symptoms and the data appearing on a central dashboard averaged 14 days.
• Technology Access: Mobile phone penetration in the affected region was 35 percent, while internet access was below 5 percent.

3. Stakeholder Positions

• Ministry of Public Health (MSPP): Demands centralized control over all data to ensure official sovereignty but lacks the servers to host high-resolution GIS maps.
• International NGOs: Operate over 50 disparate reporting systems; prioritize internal reporting to donors over shared public health databases.
• United Nations (MINUSTAH): Faces significant public relations pressure regarding the origin of the outbreak, influencing how data regarding the source is visualized and shared.
• Local Community Leaders: Distrustful of foreign data collectors; require immediate visible benefits from data sharing to maintain cooperation.

4. Information Gaps

• Asymptomatic Spread: The case does not provide data on the ratio of asymptomatic carriers to symptomatic patients, complicating transmission modeling.
• Water Source Mapping: Detailed, GPS-tagged maps of all functional versus contaminated water points were absent during the initial six months.
• Vendor Reliability: No data on the uptime of local telecommunications providers during peak infection waves.

Strategic Analysis

1. Core Strategic Question

• How can the health ministry integrate fragmented NGO data into a real-time visualization tool that directs medical supplies to emerging hotspots before mortality rates spike?

2. Structural Analysis

Value Chain of Information: The primary bottleneck is not data analysis but data collection and cleaning. The current process loses 80 percent of its utility because the information is stale by the time it reaches decision-makers. The transition from raw data to actionable insight is broken at the reporting stage.

Jobs-to-be-Done: Field doctors do not need a comprehensive map of the country. They need a tool that tells them exactly how many liters of oral rehydration salts to load onto a truck for tomorrow morning. The data visualization must serve the logistics function, not just the reporting function.

3. Strategic Options

4. Preliminary Recommendation

Implement the Decentralized SMS Reporting system immediately. Speed is the primary variable in reducing the case fatality rate. While a centralized GIS map is aesthetically superior, it cannot function without the raw data that the SMS system provides. This approach prioritizes operational utility over visual complexity.

Implementation Roadmap

1. Critical Path

• Week 1-2: Standardize the data schema. Every NGO must report the same five metrics: new cases, deaths, liters of saline on hand, available beds, and GPS coordinates.
• Week 3-4: Deploy the SMS gateway. Distribute solar-powered mobile chargers to 100 key clinics in the Artibonite region.
• Week 5-8: Automate the dashboard. Raw SMS data must feed directly into a public-facing map that updates every six hours.
• Week 9-12: Link visualization to the supply chain. Trigger automatic warehouse releases when the dashboard shows a 20 percent week-over-week increase in a specific district.

2. Key Constraints

• Power Scarcity: Mobile devices are useless if they cannot be charged. Implementation depends on solar distribution.
• Data Silos: NGOs view data as proprietary. Success requires the Ministry to make data sharing a condition of their operating permits.

3. Risk-Adjusted Implementation Strategy

The strategy assumes 40 percent of reporting nodes will fail due to local unrest or technical issues. The plan includes a mobile rapid-response team equipped with satellite phones to visit dark zones and manually verify data when reporting stops for more than 48 hours. This contingency prevents the visualization from becoming a map of silence.

Executive Review and BLUF

1. BLUF

The current data strategy fails because it prioritizes retrospective reporting over prospective action. To reduce the cholera mortality rate, the Ministry must abandon complex GIS projects in favor of a resilient SMS-based reporting network. We must stop treating data visualization as a post-mortem exercise and start using it as a logistical steering wheel. Speed of data transmission is more critical than the resolution of the map. If we cannot see the outbreak in real-time, we cannot stop it.

2. Dangerous Assumption

The analysis assumes that international NGOs will cooperate with a centralized government reporting mandate. Historically, these organizations prioritize their own donor reporting cycles over local health ministry requirements. Without a formal enforcement mechanism, the data dashboard will remain incomplete and misleading.

3. Unaddressed Risks

• Data Integrity Risk: Local officials may under-report deaths to avoid political fallout or over-report cases to secure more aid funding. Probability: High. Consequence: Misallocation of life-saving supplies.
• Security Risk: Publicizing contaminated water locations without providing immediate alternatives could lead to civil unrest or attacks on health workers. Probability: Moderate. Consequence: Total operational shutdown in affected zones.

4. Unconsidered Alternative

The team failed to consider a private-sector partnership with local telecommunications firms. These companies already possess anonymized movement data and cell-tower pings that could serve as a proxy for population displacement during the epidemic. This would provide a faster, more accurate view of potential disease spread than waiting for clinical reports, without requiring new hardware deployment.

5. MECE Verdict

APPROVED FOR LEADERSHIP REVIEW