-
Data retrieved from BRFSS, stored in CSV format, secured
-
Initial analysis performed, review potential problems in Alabama
-
Heart Matters expansion into Alabama
-
Funding received for Alabama to use a SQL database
-
Data set and Codebook copied onto flash drive, delivered to Alabama, and immediately imported into the new system
-
New Data Analyst hired, asked to re-review the master data set, and determine the top 3 health concerns to focus on
-
Found during migration, the CSV file contained characters that were unreadable by the SQL database
-
Some rows of data did not import properly resulting in data loss. The import quantity did not match the original CSV file.