FIT3003 S2 2022 MajorAssignment Marking Guide TASK MARKING CRITERIA MARK C1 Data Warehouse Design and Transformation ER Diagram Provide ER diagram with correct relationships, clear identification of PK and FK for each table. 45 Data Cleaning Identify five correct data errors and perform appropriate data cleaning. Star Schema Version-1 with explanation on difference Star schema design is correct with all dimensions, fact measures, and its relationship. Star schema version 1 has a high level of aggregation while version 2 has no level of aggregation. Provide sufficient explanation on the difference between Star schema version 1 and 2. Provide sufficient understanding on the difference between different levels of aggregation.Star Schema Version-2 with explanation on difference Determinant dimension and Temporal dimension explanation A clear explanation on whether an Determinant dimensionn is used. A clear explanation on whether an SCD dimension is used. If yes, what type of SCD it is and reasons for the choice. C2 Star/Snowflake Implementation Star Schema Version-1 implementation Correctness of the star schema implementation. Implementation is interconnected with the star schema design. Codes run without errors. SQL statement presented in the PDF file. Zero mark for the implementation if SQL files are not runnable or Missing SQL files or Submitting wrong SQL files. 25Star Schema Version-2 implementation C3 Reports using OLAP Queries OLAP Reports (Reports 1 to 4) Correctness in using OLAP functions. Results of SQL statements match with snapshot of the OLAP reports 1-4 (included correct attributes, orders, grouping). Codes run without errors. The query questions are written in English, provide clear explanation on how it will be helpful for the managers. 16 Report with Roll up and Partial Roll up (Reports 5 to 6) Report with Moving and cumulative aggregates (Reports 7 to 8) C4 BI Reports&dashboard A dashboard with four reports Correctness, interactivity, and informativity of the dashboard. 8 C5 Final Recommendations/Suggestions Final suggestion Provide a suggestion with a valid supporting data. The suggestion must contain a valid supporting data from the MonCity database and Star schema. 6 Additional Criteria Report Document Readability Report is neat and clear with sufficient headings and consistent format. Up to 10 marks deductionCode Readability Codes are given with proper comments and indentation. Timely submission of correct and relevent files 10% penalty each day for late submission. All required files are provided according to the submission checklist. Contribution equality Unequal contribution between members may result in penalty. Weekly Contributions will be checked by the allocated tutor regularly during the labs. Major asssignment checkpoints Checkpoints 1, 2 The checkpoint will be conducted during the Week 7 and Week 9. Please check MA specification for more details. 2%
欢迎咨询51作业君