-
BRFSS Established
The CDC's BRFSS (Behavioral Risk Factor Surveillance System) is created. BRFSS collects data regarding health risk behaviors, chronic health condition, and use of prevenitve services. The data gathered covers patients in all 50 states, D.C. and several U.S. territories. 400,000 adult patients are surveyed each year. -
Period: to
BRFSS Data Collection
The BRFSS continues to conduct interviews with patients nationwide. -
Heart Matters Data Retrieval & Storage
Data is retrieved from the BRFSS database and stored in CSV format. The file is stored on a secure hard drive in a locked room. -
Funding for New Location
Heart Matters receives funding for its expansion into Alabama. These funds allow the organization to use an SQL database to store, manage, and analyze data. -
Initial Analysis
From the data retrieved, it is determined that there is a lack of medical care in Alabama and the reasons behind this. It should be noted that the data retrieved and stored contains medical information for only Alabama and a sample of columns/categories surveyed. -
CDC Heart Disease Report
The CDC Reports that 28 million adults in the United States have heart disease. -
Data Transfer & Import
Heart Matter's IT System Administrator is instructed to physically transfer the data to the new location. The data is then transferred to a flash drive and delivered to the new location. It is imported to the new system. -
New Analyst Hired
The Alabama location hires a new data analyst and gives them the task of reviewing the master data set. This is so the organization can gain insight on what heart disease issues need to be focused on for the area. -
Data Loss Discovered
The Alabama analyst concludes that during data migration, the imported CSV file had characters that could not be read by the SQL database. The original file quantity did not match the import quantity. This resulted in some rows importing incorrectly, leading to some data loss.