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%