1 CIS8008 Semester 2, 2017 Assignment 2 Marking Criteria Sheet Student name: Student no Component Mark Comment Task 1.1 Define and critically discuss the concepts of (1) a data warehouse, (2) a data lake and (3) a data mart drawing relevant and reputable literature (about 500 words) 15 Excellent Definition and Critical Discussion of data warehouse, data lake and data mart theories/frameworks inform data driven decision process 12 Very good Definition and Critical Discussion of data warehouse, data lake and data mart 10 Good Definition and Critical Discussion of data warehouse, data lake and data mart 8 Average Definition and Critical Discussion of data warehouse, data lake and data mart 5 Poor Definition and Critical Discussion of data warehouse, data lake and data mart 2 Very poor Definition and Critical Discussion of data warehouse, data lake and data mart 0 Not Attempted No attempt made or irrelevant. Task 1.2 Explain how a data warehouse, a data lake and a data mart would be used in an organization and provide some real world examples of how each would be used in an organization in your answer (500 words) 15 Excellent Explanation of how data warehouse, data lake and data mart are used with examples 12 Very good Explanation of how data warehouse, data lake and data mart are used with examples 10 Good Explanation of how data warehouse, data lake and data mart are used with examples 8 Average Explanation of how data warehouse, data lake and data mart are used with examples 5 Poor Explanation of how data warehouse, data lake and data mart are used with examples 2 Very poor Explanation of how data warehouse, data lake and data mart are used with examples 0 Not Attempted No attempt made or irrelevant. Task 2.1 Using RapidMiner Studio conduct an Exploratory Data Analysis of white-wines.csv data set, summarise key findings in a table and discuss key findings of an EDA in relation to the white-wines.csv data set (about 500 words) 20 Excellent EDA of wines.csv data set with appropriate outputs and discussion of key findings 18 Very good EDA of wines.csv data set with appropriate outputs and discussion of key findings 15 Good EDA of wines.csv data set with appropriate outputs and discussion of key findings 10 Average EDA of wines.csv data set with appropriate outputs and discussion of key findings 7 Poor EDA of wines.csv data set with appropriate outputs and discussion of key findings 3 Very poor EDA of wines.csv data set with appropriate outputs and discussion of key findings 0 Not No attempt made or irrelevant.2 Task 2.2 Build a Linear Regression model for predicting wine quality ranking using RapidMiner; provide Final Linear Regression Model process and output of Final Linear Regression Model in a Table and describe Final Linear Regression Model Process and discuss results of Final Linear Regression Model ( about 300 words) 20 Excellent Explanation and discussion of Linear Regression Model process and results 18 Very good Explanation and discussion of Linear Regression Model process and results 15 Good Explanation and discussion of Linear Regression Model process and results 10 Average Explanation and discussion of Linear Regression Model process and results 7 Poor Explanation and discussion of Linear Regression Model process and results 3 Very poor Explanation and discussion of Linear Regression Model process and results 0 Not attempted No attempt made or irrelevant. Task 3 Create a Tableau Text Table or Graph view that displays Snow falls at Whistler BC Canada and other relevant data over time (years) using whistler-snowfall.csv. Comment on the process of preparing this data set for presentation and key trends and patterns that are apparent in Text Table/Graph you created for presentation of the whistler-snowfall.csv data set (about 200 words). 20 Excellent Table/Graph in terms of visual data representation and description of process and key trends & patterns 18 Very good Table/Graph in terms of visual data representation and description of process and key trends & patterns 15 Good Table/Graph in terms of visual data representation and description of process and key trends & patterns 10 Average Table/Graph in terms of visual data representation and description of process and key trends & patterns 7 Poor Table/Graph in terms of visual data representation and description of process and key trends & patterns 3 Very poor Table/Graph in terms of visual data representation and description of process and key trends & patterns 0 Not attempted No attempt made or irrelevant. Report presentation writing style and referencing Presentation use of formatting, spacing, headings, paragraphs, tables and diagrams, cover page, table of contents etc Writing style Use of English (Correct use of language and grammar? Isthere evidence of spelling-checking and proofreading?, Critical analysis and discussion evident in writing?) Referencing (Appropriate level of referencing in text, reference list provided, used Harvard ReferencingStyle) 10 Excellent presentation, writing style and appropriate referencing in text where required 9 Very good presentation , writing style and appropriate referencing in text where required 7 Good presentation , writing style and appropriate referencing in text where required 5 Average presentation, writing style and appropriate referencing in text where required 3 Poor presentation, writing style and appropriate referencing in text where required 1 Very poor presentation, writing style and appropriate referencing in text where required 0 Little or no attempt to present Assignment 2 in report format, to address required writing style and to reference correctlyusing Harvard referencing style Total marks out of a possible 100 marks 0 Deduction for late submission of assignment (Yes/No) Evidence of plagiarism or collusion (Yes/No) Marker comments: Marker’s initials: Date: