Question 6 (10 marks) Question 6 Instructions Firstly, please read the case study below the question and then answer the following case study question. Case Study Question: Many organizations now utilize Data-Mining as a means to extract valuable information from their transactional data. From the following mini-case study reading passage, identify what you think, the information the company should look for, when constructing their data warehouse. Moreover, how it could possibility benefit the organization, from a profit point-of-view, and meeting the challenges from a new competitor. Discuss these key points. Use the Adapted Harvard Referencing style with peer-reviewed referencing support, to justify your solution. A Brief Case study Reading - Mining in Springfield The Springfield Mega-Supermarket, on an average day, serves over 5000 customers. The store sells practically everything. The typical customer spends on average $250 each. While some customers spend over $1000 per visit. Larger spending customers, typically buy high-end products within the stores electrical and computing department. It has now come to management attention that a new competitor is going to open across the road. Management is concerned about losing their more valuable customers to this new player. They want to know how they can keep these customers, and ensure that they get the best offers on the high end products they purchase. Management has decided to implement a data warehouse, to mine out precious information. Currently, their old data system consisted of a plethora of spreadsheets, with information about customers and their purchase history, in an ad-hoc manner. The company is not sure if purchases have a relevance to time a purchase takes place. For example, seasonal etc. The new head of the data-warehouse will be Mr. Homer. He has ensured management that using his high mathematical skills; he can find purchase patterns of their customers. Management is eager to see results, before the new competitor starts building.