-
The data stored are integers that refer to a codebook that explains the meaning of each integer used in the dataset. The potential for their not being sufficient data is not high in this instance since it is a government agency that interviews 400,000 patients a year.
-
This is the timeline of the health data for the state of Alabama
-
Data was retrieved from BRFSS. It was then stored in CSV format on a secure hard drive The BRFSS is the CDC's data that lists out Behavioral Risk Factors, Chronic Health Conditions, and the use of Preventive Services. They collect their data via interviews. https://www.cdc.gov/brfss/index.html After its creation it was taken to a secure location.
-
After initial analysis was done it was determined that the root cause of the majority of health issues in the state were from lack of medical care.
-
New expansion allowed for the creation of SQL database and a change in the physical location that was conducted with a flash drive
-
New analyst discovered that in the transfer of the data multiple rows of data were deleted due to the CSV file have characters incompatible with the new SQL database.
-
A new data analyst is hired, the focus is broadened to focus on the top three health issues in the state of Alabama and all data is reviewed