Read Case#7-"Data Cleansing can you Do it?" then answer the following questions: Page #123

This chapter is about making sure you have the right version of the truth. It discusses BI and how we have to deal with multiple variables od data and in some cases even hundreds of variables including such items as interest rates, weather conditions, and even gas prices.

1. What is business intelligence and how can it help a company achieve success?
2. What is the difference between business intelligence and data?
3. How does ETL help transfer data in and out of the data warehouse?
4. Why would a business be data rich and information poor?

ADD ANY ADDITIONAL SOURCES USE. DO NOT RECYCLE ANSWERS.

233631 Jody Veeder 440 Science Dr Madison WI 53711-1064 X227 3/27/2002 233654 Matthews 1235 W St NE Washington DC 20018-1107 (202)608-2000 3/25/2002 233632 Michael Kehrer 3015 SSE Loop 323 Tyler TX (903)579-3229 4/28/ 233633 Erin Yoon 3500 Carillon Pt Kirkland WA 98033-7354 (425)897-7221 3/25/2002 233634 Madeline Shefferly 4100 E Dry Creek Rd Littleton CO 80122-3729 (303)486-3949 3/33/2002 233635 Steven Conduit 1332 Enterprise Dr West Chester PA 19380-5970 (610)692-5900 4/27/2002 233636 Joseph Kovach 1332 Enterprise Dr West Chester PA 19380-5970 (610) 692-5900 4/28/2002 233637 Richard Jordan 1700 N Philadelphia PA 19131-4728 (215) 581-6770 3/19/2002 233638 Scott Mikolajczyk 1655 Crofton Blud Crofton MD 21114-1387 (410)729-8155 4/28/2002 233639 Susan Shragg 1875 Century Park E Los Angeles CA 90067-2501 (310)785-0511 4/29/2002 233640 Rob Ponto 29777 Telegraph Rd Southfield MI 48034-1303 (810)204-4724 5/5/2002 1211 Avenue Of The 233642 Lauren Butler Americas New York NY 10036-8701 (212)852-7494 4/22/2002 3 Christopher Lee 12421 W Olympic Blud Los Angeles CA 90064-1022 (310)689-2577 3/25/2002 233644 Michelle Decker 6922 Hollywood Blvd Hollywood CA 90028-6117 (323)817-4655 5/8/2002 1211 Avenue Of The 233647 Natalia Galeano Americas New York NY 10036-8701 (646) 728-6911 4/23/2002 233648 Bobbie Orchard 4201 Congress St Charlotte NC 28209-4617 (704)557-2444 5/11/2002 233650 Ben Konfino 1111 Stewart Ave Bethpage NY 11714-3533 (516)803-1406 3/19/2002 233651 Lenee Santana 1050 Techwood Dr Atlanta GA 30318- (404)885-2000 3/22/2002 NW KKRR 233652 Lauren Monks 7700 Wisconsin Ave Bethesda MD 20814-3578 (301) 771-4772 3/19/2005 10950 Washington 233653 Mark Woolley Blvd Culver City CA 90232-4026 (310)202-2900 4/20/2002 Back to page 6 398 399 Last page in this chapterChapter 7 Case: Data Cleansing: Can You Do It? You are working for BI, a start-up business intelligence consulting company. You have a new client that is interested in hiring BI to clean up its information. To determine how good your work is, the client would like your analysis of the spreadsheet below. If you can prove you are a great data cleanser, you will be awarded the data scientist contract. Page 124 Last Order CUST ID First Name Last Name Address City State ZIP Phone Date 233620 Christopher Lee 12421 W Olympic Blvd Los Angeles CA 75080-1100 (972)680-7848 4/18/2002 233621 Bruce Brandwen 268 W 44th St New York PA 10036-3906 (212)471-6077 5/3/2002 233622 Gir Johnson 4100 E Dry Creek Rd Littleton CO 80122-3729 (303)712-5461 5/6/2002 233623 Dave Owens 466 Commerce Rd Staunton VA 24401-4432 (540)851-0362 3/19/2002 233624 John Coulbourn 124 Action St Maynard MA 1754 (978)987-0100 4/24/2002 233629 Dan Gagliardo 2875 Union Rd Cheektowaga NY 14227-1461 (716)558-8191 5/4/2002 23362 Damanceee Allen 1633 Broadway New York NY 10019-6708 (212) 708-1576 233630 Michael Peretz 235 E 45th St New York NY 10017-3305 (212)210-1340 4/30/2002 (608)238-9690 397 2 pages left in this chapter