Data Visualization in Environmental Public Health

Data Visualization in Environmental Public Health: From Data to Insight

Let Visualization Reveal Data Quality Issues Visualization can also expose data quality problems that might be difficult to detect in the original database. Misspelled categories, inconsistent date formats, duplicate records, missing values, outdated fields, and unexpected outliers become apparent when the data are summarized or displayed visually. Rather than treating these findings as a failure, agencies should view it as a valuable part of the process. It creates an opportunity to improve the quality and usefulness of the underlying data before decisions are made from them. For example, a chart that groups violations by type reveals that the same violation has been entered under several slightly different names. A map shows records in the wrong city or outside the program’s service area because addresses were incomplete or entered inconsistently. A trend line reveals an unexpected increase or decrease due to changes in data-entry practices rather than a true change in environmental health conditions. These types of issues often originate during data collection and become much more apparent once the data are summarized or displayed visually. Because data collection and visualization are closely connected, improvements to data entry can improve the quality of future visualizations. When possible, data- entry systems should reduce unnecessary variation through tools such as required fields, standardized categories, drop-down menus, validation rules, and consistent date and numeric formats. Free-text fields remain useful for notes and context, but they are often difficult to summarize reliably and should not replace structured fields when consistent reporting is required. Address data require particular attention because small inconsistencies can affect geocoding and spatial analysis. Missing street numbers, incomplete ZIP Codes, misspelled street names, inconsistent abbreviations, or information entered in the wrong fields can prevent records from being mapped accurately. Separating address components into standardized fields and validating addresses during data entry can substantially improve the reliability of GIS maps and location- based analysis. Terms to Know: Geocoding is the process of converting location information, such as a street address, ZIP code, or place name, into geographic coordinates (latitude and longitude) that can be displayed on a map. Spatial analysis refers to the analysis of mapped data to answer questions about where, how, and why patterns occur across geographic space.

Treat Visualization as an Iterative Process Visualization is best understood as part of an iterative cycle rather than a final, isolated step. This process reflects the workflow introduced earlier in this guide. When new questions emerge or data problems surface, returning to an earlier stage is expected and often necessary, not a sign that something went wrong. Each cycle can reveal new questions, changing audience needs, or opportunities to improve data quality. Returning to earlier steps is therefore a normal part of effective visualization.