Skip to content

4.1: Prepare consolidated data for analysis

Prior to analyzing consolidated 7-1-7 data, the following actions should be completed:

  1. Confirm that all data have been entered: Review the list of public health events that occurred during the period of interest and confirm that all event data have been entered in the appropriate databases.
  2. Clean the data: Review the data entered in the databases and check for any missing fields. In addition, check the calculated values for each of the three timeliness metrics and confirm that any outliers (e.g., negative numbers, large numbers) are correct. For jurisdictions using the Data Consolidation Spreadsheet, this can be done by reviewing outputs on the “Assess 7-1-7 Results” sheet where the timeliness metrics are automatically calculated, and blanks and negative values highlighted.

Global health security is only as strong as the weakest link.

Sign up for our newsletter and stay updated on the latest from the 7-1-7 Alliance community of practice.

I want
  • important updates.
  • technical assistance.
  • case studies.
  • funding.
  • expert guidance.
  • practical tools.
  • training materials.
  • actionable data.
  • a safer world.