Assignment Brief (RQF)
Assignment Brief (RQF)
Higher National Diploma in Computing
Nawoda Deshan Balasooriya
Student Name/ID Number:
M19941109004
Unit Number and Title: Assignment 01
Academic Year: 2019/2020
Unit Assessor: Mr Rajeewa Dharshana
Assignment Title: Business Interligence.
Issue Date: 1st December 2020
Submission Date: 27th December 2020
Internal Verifier Name: Ms Prabashi Manjani
Date: 29th November 2020
Submission Format:
Students have to submit the WHOLE Assignment work as an Academic report. Both soft copy and hard
copy is required in the day of submission.
You need to attach this “Assignment brief” as the first section of the assignment report.
Referencing is mandatory.
No word Limits.
Any type of academic misconduct will result a “Fail”.
Answering to ALL TASKS is mandatory. If a task or a subtask is missing in answers, result will be “FAIL”.
Unit Learning Outcomes:
LO1 Discuss business processes and the mechanisms used to support business
decision-making.
LO2 Compare the tools and technologies associated with business intelligence
functionality.
LO3 Demonstrate the use of business intelligence tools and technologies
LO4 Discuss the impact of business intelligence tools and technologies for
effective decision-making purposes and the legal/regulatory context in which
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE)
Version 1.0 – October 2018
DCL 1 – Public (Unclassified)
Nawoda Deshan Balasooriya 1
M19941109004
, Assignment Brief (RQF)
they are used.
Assignment: Answer all questions.
Q1.
a) Briefly explain the following terms.
Data Vs. Information
Structured, Unstructured and Semi-structured data
Business Intelligence Process
Advantages & Disadvantages of Data Warehousing & Data Mining
b) Describe five types of proximity attributes with relevant examples.
c) Calculate the mean, standard deviation and draw the boxplots of the following frequency
distribution.
Weekly wages in Rs. No. of persons Weekly wages in Rs. No. of persons
4.5-12.5 4 44.5-52.5 3
12.5-20.5 24 52.5-60.5 5
20.5-28.5 21 60.5-68.5 8
28.5-36.5 18 68.5-76.5 2
36.5-44.5 5
Q2.
a) Why is a business intelligence tool needed? Describe its main features.
b) Explain Data warehouse 2Tier, 3Tier and 4Tier Architecture models.
c) Consider the following data tables (Table A, B & C) draw a 3D Data Cube and mention all the sales
details in the Cube.
COLOMBO - SALES GAMPAHA - SALES GALLE - SALES
Time Car Bike Van bus Time Car Bike Van bus Time Car Bike Van bus
Q1 200 355 150 40 Q1 80 100 30 20 Q1 100 145 25 10
Q2 125 200 100 20 Q2 100 200 50 20 Q2 150 132 60 30
Q3 175 230 67 34 Q3 175 45 76 26 Q3 100 20 34 45
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE)
Version 1.0 – October 2018
DCL 1 – Public (Unclassified)
Nawoda Deshan Balasooriya 2
M19941109004
, Assignment Brief (RQF)
Q4 100 110 90 12 Q4 90 190 90 12 Q4 100 160 20 14
TABLE- A TABLE- B TABLE- C
Q3.
a) Describe the pros and cons of OLTP vs OLAP via separate tables.
b) Explain the following topics.
Data cleaning
Data integration
Data reduction
Data transformation and data discretization
c) The table below shows the Covid-19 incidents that took place in Sri Lanka. Calculate Correlation and
Covariance for observations and confirmations data columns.
Q4.
Crime is a major social factor which drives society into a dark side in several ways. Due to the above
reason, there are large numbers of prisoners in prisons for different crimes. s. In Sri Lanka, it has
been identified that the major challenge facing by all law-enforcement and intelligence-gathering
departments, organizations to analyse the growing volume of prison data more accurately and
efficiently. When the volume of prison data becomes enormously large, new innovative approaches
have to be used to take appropriate actions after turn this data into valuable information. Previous
researchers show that the process which is using to extract the existing data from each operational
system is manual. Further, all the data are recorded in a ledger book manually.
You are working as a Data Scientist in Government Analyst’s Department. You have been asked to
discover the need for new innovative data integration, data warehousing and data mining as ways
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE)
Version 1.0 – October 2018
DCL 1 – Public (Unclassified)
Nawoda Deshan Balasooriya 3
M19941109004
, Assignment Brief (RQF)
to improve the operations within the prison of Sri Lanka. Further, you have to describe what are
data management techniques and other relevant concepts and approaches to effectively analyze
the data and speed up the process of decision making.
(Download prison data set excel sheet through LMS)
Learning Outcomes and Assessment Criteria of the Module
Pass Merit Distinction
LO-1 - Demonstrate a range of interpersonal and transferable communication skills to a target
audience
P1 Demonstrate, using different M1 Design a professional D1. Evaluate the effectiveness
communication styles and formats, schedule to support the and application of interpersonal
that you can effectively design and planning of an event, to skills during the design and
deliver a training event for a given include contingencies and delivery of a training event.
target audience. justifications of time
allocated.
P2 Demonstrate that you have used
effective time management skills in
planning an event.
LO-2 - Apply critical reasoning and thinking to a range of problem-solving scenarios.
LO-3 - Discuss the importance and dynamics of working within a team and the impact of team
working in different environments.
P5 Discuss the importance of team M4 Analyze team dynamics, D3 Provide a critical evaluation
dynamics in the success and/or in terms of the roles group of your own role and
failure of group work. members play in a team and contribution to a group scenario.
the effectiveness in terms of
P6 Work within a team to achieve a achieving shared goals.
defined goal.
LO-4 - Examine the need for Continuing Professional Development (CPD) and its role within the
workplace and for higher level learning.
P7 Discuss the importance of CPD M5 Compare and contrast D4 Evaluate a range of evidence
and its contribution to own learning. different motivational criteria that is used as a
theories and the impact measure for effective CPD.
P8 Produce a development plan that they can have on
outlines responsibilities, performance performance within the
objectives and required skills, workplace
knowledge and learning for own
future goals.
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE)
Version 1.0 – October 2018
DCL 1 – Public (Unclassified)
Nawoda Deshan Balasooriya 4
M19941109004
Assignment Brief (RQF)
Higher National Diploma in Computing
Nawoda Deshan Balasooriya
Student Name/ID Number:
M19941109004
Unit Number and Title: Assignment 01
Academic Year: 2019/2020
Unit Assessor: Mr Rajeewa Dharshana
Assignment Title: Business Interligence.
Issue Date: 1st December 2020
Submission Date: 27th December 2020
Internal Verifier Name: Ms Prabashi Manjani
Date: 29th November 2020
Submission Format:
Students have to submit the WHOLE Assignment work as an Academic report. Both soft copy and hard
copy is required in the day of submission.
You need to attach this “Assignment brief” as the first section of the assignment report.
Referencing is mandatory.
No word Limits.
Any type of academic misconduct will result a “Fail”.
Answering to ALL TASKS is mandatory. If a task or a subtask is missing in answers, result will be “FAIL”.
Unit Learning Outcomes:
LO1 Discuss business processes and the mechanisms used to support business
decision-making.
LO2 Compare the tools and technologies associated with business intelligence
functionality.
LO3 Demonstrate the use of business intelligence tools and technologies
LO4 Discuss the impact of business intelligence tools and technologies for
effective decision-making purposes and the legal/regulatory context in which
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE)
Version 1.0 – October 2018
DCL 1 – Public (Unclassified)
Nawoda Deshan Balasooriya 1
M19941109004
, Assignment Brief (RQF)
they are used.
Assignment: Answer all questions.
Q1.
a) Briefly explain the following terms.
Data Vs. Information
Structured, Unstructured and Semi-structured data
Business Intelligence Process
Advantages & Disadvantages of Data Warehousing & Data Mining
b) Describe five types of proximity attributes with relevant examples.
c) Calculate the mean, standard deviation and draw the boxplots of the following frequency
distribution.
Weekly wages in Rs. No. of persons Weekly wages in Rs. No. of persons
4.5-12.5 4 44.5-52.5 3
12.5-20.5 24 52.5-60.5 5
20.5-28.5 21 60.5-68.5 8
28.5-36.5 18 68.5-76.5 2
36.5-44.5 5
Q2.
a) Why is a business intelligence tool needed? Describe its main features.
b) Explain Data warehouse 2Tier, 3Tier and 4Tier Architecture models.
c) Consider the following data tables (Table A, B & C) draw a 3D Data Cube and mention all the sales
details in the Cube.
COLOMBO - SALES GAMPAHA - SALES GALLE - SALES
Time Car Bike Van bus Time Car Bike Van bus Time Car Bike Van bus
Q1 200 355 150 40 Q1 80 100 30 20 Q1 100 145 25 10
Q2 125 200 100 20 Q2 100 200 50 20 Q2 150 132 60 30
Q3 175 230 67 34 Q3 175 45 76 26 Q3 100 20 34 45
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE)
Version 1.0 – October 2018
DCL 1 – Public (Unclassified)
Nawoda Deshan Balasooriya 2
M19941109004
, Assignment Brief (RQF)
Q4 100 110 90 12 Q4 90 190 90 12 Q4 100 160 20 14
TABLE- A TABLE- B TABLE- C
Q3.
a) Describe the pros and cons of OLTP vs OLAP via separate tables.
b) Explain the following topics.
Data cleaning
Data integration
Data reduction
Data transformation and data discretization
c) The table below shows the Covid-19 incidents that took place in Sri Lanka. Calculate Correlation and
Covariance for observations and confirmations data columns.
Q4.
Crime is a major social factor which drives society into a dark side in several ways. Due to the above
reason, there are large numbers of prisoners in prisons for different crimes. s. In Sri Lanka, it has
been identified that the major challenge facing by all law-enforcement and intelligence-gathering
departments, organizations to analyse the growing volume of prison data more accurately and
efficiently. When the volume of prison data becomes enormously large, new innovative approaches
have to be used to take appropriate actions after turn this data into valuable information. Previous
researchers show that the process which is using to extract the existing data from each operational
system is manual. Further, all the data are recorded in a ledger book manually.
You are working as a Data Scientist in Government Analyst’s Department. You have been asked to
discover the need for new innovative data integration, data warehousing and data mining as ways
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE)
Version 1.0 – October 2018
DCL 1 – Public (Unclassified)
Nawoda Deshan Balasooriya 3
M19941109004
, Assignment Brief (RQF)
to improve the operations within the prison of Sri Lanka. Further, you have to describe what are
data management techniques and other relevant concepts and approaches to effectively analyze
the data and speed up the process of decision making.
(Download prison data set excel sheet through LMS)
Learning Outcomes and Assessment Criteria of the Module
Pass Merit Distinction
LO-1 - Demonstrate a range of interpersonal and transferable communication skills to a target
audience
P1 Demonstrate, using different M1 Design a professional D1. Evaluate the effectiveness
communication styles and formats, schedule to support the and application of interpersonal
that you can effectively design and planning of an event, to skills during the design and
deliver a training event for a given include contingencies and delivery of a training event.
target audience. justifications of time
allocated.
P2 Demonstrate that you have used
effective time management skills in
planning an event.
LO-2 - Apply critical reasoning and thinking to a range of problem-solving scenarios.
LO-3 - Discuss the importance and dynamics of working within a team and the impact of team
working in different environments.
P5 Discuss the importance of team M4 Analyze team dynamics, D3 Provide a critical evaluation
dynamics in the success and/or in terms of the roles group of your own role and
failure of group work. members play in a team and contribution to a group scenario.
the effectiveness in terms of
P6 Work within a team to achieve a achieving shared goals.
defined goal.
LO-4 - Examine the need for Continuing Professional Development (CPD) and its role within the
workplace and for higher level learning.
P7 Discuss the importance of CPD M5 Compare and contrast D4 Evaluate a range of evidence
and its contribution to own learning. different motivational criteria that is used as a
theories and the impact measure for effective CPD.
P8 Produce a development plan that they can have on
outlines responsibilities, performance performance within the
objectives and required skills, workplace
knowledge and learning for own
future goals.
Prepared by: Higher Education Qualifications (HEQ) Approved by: HEQ, QDAM (HE)
Version 1.0 – October 2018
DCL 1 – Public (Unclassified)
Nawoda Deshan Balasooriya 4
M19941109004
