By searching the Internet, select the tools that you will use in the BI Center (e.g., databases, Excel, data mining tools, analytical tools). Select the “free” tools available on the Internet.

PART A: Requirements Definition and Logical Design

⦁ Based on the materials in the textbook, especially the Case Studies in each Chapter, identify at least 10 business problems the BI Center will be able to solve. Be specific (e.g., reduce the customer churn)
⦁ Develop a logical design (conceptual view) of what will be the key components of the BI Center (e.g., the data, the models, analytical tools, data mining tools, etc)
⦁ More grades will be given to deliverables that specifically utilize the textbook materials (especially the case study). For example, if you select text mining, then you should say that “we will use text mining as used by the US Govt for counter terrorism (Opening Vignette, Chapter 7 “Mining Text for Security and Counter Terrorism”).

Important Note: In this assignment, you should rely heavily on the case studies (especially the Opening Vignettes), in Chapters 3 to 8. Here are the names of these case studies : Chapter 3 “Decision Support System Cure for Health Care”, Chapter 4 “Model based Auctions Serve More Lunches in Chile”, Chapter 5 “Data Mining Goes to Hollywood!”, Chapter 6 “Predicting Gambling Referenda with Neural Networks”, Chapter 7 “Mining Text for Security and Counter Terrorism”, and Chapter 8“DirecTV Thrives with Active Data Warehousing”

PARTB: Develop a Physical Design of the BI Center

⦁ By searching the Internet, select the tools that you will use in the BI Center (e.g., databases, Excel, data mining tools, analytical tools). Select the “free” tools available on the Internet.
⦁ Show the “Architecture” of the BI Center as a bock diagram that shows what are the key components of the center, what do they do (e.g., what type of questions will they answer) and how do they interact with each other to answer the questions.
⦁ Conduct quick cost benefit analysis of the selected tools and identify which “must be selected” for the BI Center. Please use the simple Cost-Benefit analysis approach shown in Exhibit1.
⦁ Develop a simple prototypeof the BI Center with the selected tools. The prototype may support only one or 2 tools for proof of concept. Instead of a prototype, you may choose to develop a gamified design of the center in Powerpoint or hHTML5.