FIGURE 1 Beta Auto Dealers Data Data items that were extracted from each locations information systems are listed below. These data iterns are included in the BetaAutoData.xis file. Customer Data: 1. Customer number 2. Customer first name 3. Customer last name 4. Customer city 5. Gender 6. Age Visit Data: 1. Date 2 Day of week 3. Customer number 4. Customer first name 5. Customer last name 6. Touchpoint 7. Salesperson name 8. Salesperson number 9. Model(s) interested in models they viewed during visit) Sales Data: 1. Date 2. Day of week 3. Customer number 4. Customer last name 5. Customer first name 6. Model 7. Vehicle identification number (VIN) 8. Sales price 9. Cost of Vehicle 10. Warranty (yeso) 11. Financing (yeso) 12. Salesperson name Normally the exported data would contain this information. However, for confidentiality reasons relating to identity theft conces, this information is omited from the Excel worksheets. When building the database tables, make sure to include a field for this information FIGURE 1 Beta Auto Dealers Data Data items that were extracted from each locations information systems are listed below. These data iterns are included in the BetaAutoData.xis file. Customer Data: 1. Customer number 2. Customer first name 3. Customer last name 4. Customer city 5. Gender 6. Age Visit Data: 1. Date 2 Day of week 3. Customer number 4. Customer first name 5. Customer last name 6. Touchpoint 7. Salesperson name 8. Salesperson number 9. Model(s) interested in models they viewed during visit) Sales Data: 1. Date 2. Day of week 3. Customer number 4. Customer last name 5. Customer first name 6. Model 7. Vehicle identification number (VIN) 8. Sales price 9. Cost of Vehicle 10. Warranty (yeso) 11. Financing (yeso) 12. Salesperson name Normally the exported data would contain this information. However, for confidentiality reasons relating to identity theft conces, this information is omited from the Excel worksheets. When building the database tables, make sure to include a field for this information