ITM 618 Study Guide - Quiz Guide: Information Technology, Online Analytical Processing, Data Cube
Ted Rogers School of Information Technology Management
ITM 618: Business Intelligence and Analytics
Assignment #1
Due on Friday October 25, 2019
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 analytics task or not. And if yes, what type of task (e.g., classification,
regression, clustering, association mining, etc.) it is.
a. Reporting today’s branch sale to the branch manager.
b. Predicting the future stock price of Microsoft using historical data.
c. Predicting the outcome of tossing a fair pair of dice.
d. Partitioning customers into similar groups based on their demographic profile.
2- (1 point) [Data Warehousing] Jack, 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 Jack that he 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.
Document Summary
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 analytics task or not. Write an explanation for jack that he 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. What olap operations should be performed in order to answer the following questions: total revenue earned by selling pcs in ontario in 2015, total revenue earned by each product in each country in 2014. 4- (1. 5 points) [introduction to data mining] as a business analyst in td, you were asked to design a data-driven solution for the mortgage approval process.