see attached file
Ted Rogers School of Information Technology Management ITM 618: Business Intelligence and Analytics Assignment #1 Due on Sunday October 18, 2020 Submit your assignment as a PDF file to D2L 1- (2 points) [Introduction to Data Analytics] Specify whether each of the following activities is a data mining task or not. And if yes, what type of task (e.g., classification, regression, clustering, association mining, etc.) it is. a. [0.5 point] Reporting total revenue of a product sales over a year in different branches to the CEO. b. [0.5 point] Estimate the price of a house using historical data. c. [0.5 point] Predicting the outcome of tossing a fair pair of coins. d. [0.5 point] Categorizing songs into similar groups based on title, album, artist, genres; play counts, favorites, comments; description, biography, tags. 2- (2 point) [Data Warehousing] Jill, a manager in an I.T. department, is trying to explain to Joe, the head of marketing, why the company needs to have two major information systems, an ERP OLTP system and a data warehouse OLAP system. Write an explanation for Jill that she can give to Joe that discusses why these two systems are necessary and then explain to Joe how his department should use each of the systems. 3- (2 points) [OLAP Operations] Assume that we have a data cube consists of three dimensions: Product, Time and Location. The values (i.e., facts) show the revenue in thousand dollars. Assume that we have the following hierarchy: What OLAP operations should be performed in order to answer the following questions: a) [1 point] Total revenue earned by Printer in Ontario in 2010. b) [1 point] Total revenue earned by each product in each province. 4- (2 points) [Introduction to Data Mining] As a business analyst in RBC, you were asked to design a data-driven solution for the mortgage approval process. There are customers who apply for mortgage and after approval, some customers cannot pay their mortgage back. The goal is to design a system to evaluate the history of an applicant and give useful information to the advisor regarding the application before the approval. Given CRISP- DM process, explain each step (e.g., questions and their answers in each step) of the process to design the solution for the mortgage approval process. Note: The best answer to this question is the one that customizes all the steps for the given case (RBC mortgage prediction) and describes the steps in the context of the problem. Having general questions as the definition of the steps is not very appealing! 5- (2 points) [Predictive Analytics] You are given the decision tree for the concept of “getting a loan” that indicates whether a customer is likely get the loan or not. Determine if the following instances can get a loan and explain the steps (If the tree cannot provide the value for the instance, explain why): a) [0.5 point] Bob is a young student, his income is 25K and has a criminal record. b) [0.5 point] Mary’s income is 45K and she does not have any criminal record. c) [0.5 point] Ellen is working as a business analyst since 2017, makes $65K a year, and makes all credit card payments. d) [0.5 point] Jack has a criminal record and makes all credit card payments.