Apply Your Knowledge

The Broadway Cafe has five traditional lines of business: (1) coffee sales; (2) music sales; (3) food sales; (4) retail sales; and (5) promotional sales such as coffee-of-the-month. Your current IT infrastructure is pieced together with various systems and applications. Currently, you have a difficult time with CRM because your systems are not integrated. You cannot determine vital information such as which customers are ordering coffee and not food or music and not coffee. For example, the three details that the customer Diego Quintos (1) ordered four cappuccinos, (2) three CDs, and (3) two coffee-of-the-month gift coupons, are discrete facts housed in separate systems. You hope that by using CRM technology to integrate your data, the next time Diego purchases a cup of coffee a sales associate could ask him how he is enjoying his CDs, or if his friends liked the coffee-of-the-month gifts.

PROJECT FOCUS:

You are excited about the possibility of taking advantage of customer segmentation and CRM strategies to help increase business. You want to use CRM technologies to improve service and personalization at each customer touch point. Using a data warehousing tool, important customer information can be accessed from all of your systems either daily, weekly, monthly, or once or twice per year. Analyze the sample data in CRM_AYK.xls for the following:

• Currently, the quality of the data within the above disparate systems is low. Develop a report discussing the importance of high quality information and how low quality information can affect the cafes business.
• Review the data and give examples displaying the kind of information The Broadway Cafe could use to gain a better understanding of its customers. Include the types of data quality issues the company can anticipate and the strategies it can use to help avoid such issues.
• Determine who are the cafes best customers, and provide examples of the types of marketing campaigns the cafe should offer these valuable customers.

Broadway Cafe
Question	Name	Total
What is the best selling product?
What is the worst selling product ?
What is the best sales month?
What is the worst sales month?
What is the best selling product during the best month?
What is the worst selling product during the best month?
What is the best selling product during the worst month?
What is the worst selling product during the worst month?
**Ignore any values that are 0, unknown, all, or blank