-
Data Storage
The collected data was stored in CSV format on a secure hard drive in a locked facility. -
Data Collection
The Behavioral Risk Factor Surveillance System (BRFSS) conducted telephone surveys across the U.S. Data specific to Alabama was gathered, including health conditions and risk factors like heart disease, diabetes, smoking, and physical activity. -
Quality Review
A new data analyst identified discrepancies between the original CSV and the SQL import, prompting a request to examine data provenance and quality. -
Data Transfer
During the client's expansion, the data was physically transferred via flash drive to a new location. -
SQL Migration
Data was imported into a new SQL database. During this process, some rows became unreadable due to character issues, resulting in data loss.