Module 5 Data Timeline

  • Data retrieved from BRFSS

    Stored in CSV format on a secure hard drive in a securely locked room
  • Expansion

    Received funding for SQL Database
  • Data transfer

    IT sysadmin transferred the data set and codebook to a flash drive and delivered to the the new location and imported into the new system
  • New analyst hired

    Analyst was asked to re-review the master data set
  • Error found

    New analyst found there were characters in the CSV file that were unreadable by the SQL database, which led to some data loss