|
Business Dilemma
You maintain many different customer lists from your Music customers to Art Gallery and Book Club customers. You want to begin mailing a monthly newsletter to your customers discussing everything from current coffee growing trends to community events. To date, your customer lists have been maintained primarily for e-mail addresses and you are unsure if customer addresses are even correct. You do not want to use e-mail to distribute your newsletter as you want to place a coupon marketing a free cup of the coffee in each newsletter. If you e-mail the newsletter you could not control the free cup coupon.
PROJECT FOCUS:
- Analyze the data below and determine if you will be able to use it to mail your newsletters.
- Be sure to highlight all of the issues with the data, potential causes of the issues, and solutions you can follow to correct the issues.
ID |
First Name |
Middle Initial |
Last Name |
Street |
City |
State |
Zip Code |
434 |
Pam |
J |
Hetz |
13 First Ave |
Denver |
CO |
8765423 |
434 |
Brain |
F |
Hoover |
Lake Ave. |
Columbus |
CO |
8702 |
435 |
Bob |
X |
Kenzie |
65 Apple Lane |
Golden |
CO |
65667 |
436 |
Alana |
B |
|
567 55 St. |
Denver |
Co |
90210 |
437 |
Alana |
B |
Smith |
567 55 St. |
Denver |
Co |
90210 |
438 |
Debbie |
F |
Fernandez |
567 55 St. |
Denver |
Co |
90210 |
439 |
Diego |
J |
Quintos |
2121 One St. |
Golden |
CO |
65667 |
|