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

 

© 2007-2013. All Rights Reserved