BFRSS

By F.Smith

  • Data Retrieved

    Data retrieved from the BFRSS database and stored in CSV format in a securely locked room on a securely locked hard drive.

  • Initial Analysis

    In 2017, an initial analysis was conducted to determine if a lack of medical care is a problem in Alabama.

  • Data Collected

    BRFSS health-related telephone survey data is collected including health-related risk behaviors, chronic health conditions, and use of preventative services.

  • Data Migration

    The IT system administrator copied the dataset and codebook to a flash drive that was physically imported to the new location where it was immediately imported into an SQL database.

  • New Location

    Company expands to a new location that uses an SQL database to store and analyze data.

  • Additional Analysis

    A new data analyst is hired to re-review the dataset to determine the top three health concerns.

  • Data Loss Identified

    The analyst discovers the CSV file contained characters that were unreadable by the SQL database resulting in data loss. Missing information threatens the reliability of accuracy of the data.