Edited with the trial version of

Foxit Advanced PDF Editor

To remove this notice, visit:
www.foxitsoftware.com/shopping

Assessment Brief

Assessment Details

Module Title: Data Analytics and Visualisation

Module Code:
Module Leader:
Stage (if relevant):
Assessment Title: Implementing several techniques for Data Analytics and
Visualisation
Assessment Number (if relevant): 1
Assessment Type: Lab-based
Restrictions on Time/Length: N/A
Individual/Group: Individual
Assessment Weighting: 100%
Issue Date:
Hand In Date:

Planned Feedback Date:

Mode of Submission: On-line ONLY Moodle

Assessment Task (100 Marks) - Weighting (100%)

The following is the assignment as set out for the module of Data Analytics and Visualisation
The purpose of this assignment is to perform BI and data analytics jobs using techniques
learned as part of this module.

PART I
Design and Implement a Data Warehouse/Data Mart (proof of concept) and develop BI
reports based on it

1. Data Warehouse is developed to obtain business intelligence from data. Develop a proof
of concept data warehouse/mart (using dimensional model) capturing data from an existing
data source(s). Document your reasons for selecting the subject area(s), identify key
stakeholders, formalise the business vision for developing the data warehouse from the given

1
 Edited with the trial version of
Foxit Advanced PDF Editor
To remove this notice, visit:
www.foxitsoftware.com/shopping

data source. Also explain the insights that a company may attain from the given data. It
should be reflected in the SSRS reports and Tableau visuals.

2. Develop a dimensional model/star schema for developing Data warehouse.

3. Implement the data warehouse in SQL Server by creating dimension and fact tables. Write
SQL code for ETL or use an ETL tool to populate the data warehouse from operational
database(s)/sources.

4. Develop 4 reports using SQL Server Reporting Services (SSRS) demonstrating BI.

5. Using your data warehouse, develop a dashboard in Tableau with four different multi-
dimensional visualisations presenting data analysis/analytics of your data using several
features such as colours, calculated fields, filters, trend lines, etc.

6. Conclusions / Bibliography.

7. Include all code in Appendices.

Write a report to include all the above sections.

PART II

You are required to carry out a series of analyses on a dataset and develop a predictive model
using the Python programming language used in this module. The dataset can be obtained
from data warehouse implemented as first part of your assessment or from some other
source. Dataset should have at least 1,000 records (rows).

You are required to:

• Prepare and analyse the data using a number of techniques in Python
• Explore the data by implementing several data visualisations
• Develop a model using suitable data mining algorithms
• Analyse the results and provide a comparative evaluation using different data mining
and visualisation methods.

2
 Edited with the trial version of
Foxit Advanced PDF Editor
To remove this notice, visit:
www.foxitsoftware.com/shopping

You are required to compile a report of your analysis. Your report (Word document) should
provide unique insights based on your data analysis. Examples of insights might include
relationships, trends/patterns, correlations, models based on the data, visuals, etc.

All the Python code elements must be included in an appendix. Dataset or link to dataset must
be uploaded.

Your project report must discuss the challenges that you encountered whilst handling your
chosen datasets and the techniques you implemented to overcome these challenges.

Presentation (Part I and Part II)

You are required to:
• Individually present your work in your last class.
• Duration of Presentation must be between 5 minutes (each part).
• Answer any questions that may arise and be prepared to answer the questions
related to your work.

Submission:
Create a folder with your name_moduleCode and include the following:
PART I
• Include report (MS Word)
• Include Visio file with star schema
• SSIS Project
• BI and Data analysis reports developed using SSRS
• Visualisations
PART II
• Include Report (MS Word) including Python code in Appendix.
• Dataset or link to dataset.

3
 Edited with the trial version of
Foxit Advanced PDF Editor
To remove this notice, visit:
www.foxitsoftware.com/shopping

Assessment criteria

Criteria/ < 40 40 - 49 50 - 59 60 – 69 70 +
Mark
Report Insufficient or Some but Sufficient Well- Excellent
incomplete insufficient explanation structured and solution to
report with and poorly with code well-written problem
poor or written report that solves report with proving
incomplete with poorly problem in good originality,
code and developed but lacks specifications/ creativity and
explanations. code and attention to code and evidence of
explanation good report explanation. research – very
not enough to writing skills. well written
meet the code.
requirements.
Presentation Very Weak Weak Average Good Excellent
presentation presentation presentation presentation presentation
with no showing little on showing showing good showing
knowledge/ knowledge of some knowledge excellent
Understanding different knowledge Data knowledge of
of the working aspects of the of relevant Warehouse. Data
of programs/visu issues. Warehouse.
code/visualisa alisations.
tions.

4
 Edited with the trial version of
Foxit Advanced PDF Editor
To remove this notice, visit:
www.foxitsoftware.com/shopping

To prevent plagiarism please follow this link to the Harvard/OSCALA (delete as appropriate) Style
Referencing Guide - all referencing is required in this format.

http://issuu.com/dbslibrary/docs/harvard-referencing-guide/1?mode=a_p

5
 Edited with the trial version of
Foxit Advanced PDF Editor
To remove this notice, visit:
www.foxitsoftware.com/shopping

13. In relation to electronic submissions:

A. All assignments should be submitted to your subject/course page on Moodle by the deadline date.
B. It is the student’s responsibility to ensure their file is uploaded correctly.
C. When an assignment is submitted, it is the student’s responsibility to ensure that the file is in the
correct format and opens correctly.
D. When you submit your assignment you will be asked to click on a button which will declare the
following:

By submitting this assignment I confirm that I am aware of DBS’s policy regarding cheating, plagiarism and all
other forms of academic impropriety. The coursework submitted is my own or my group’s work, and all other
sources consulted have been appropriately acknowledged. I am aware that in the case of doubt an investigation
will be held.

E. Include an electronic cover sheet with the following details to the front of the assignment:

Electronic Assignment Cover sheet

Please fill out and attach as the first page of Assignment.

Student (s) Number as per your student card:

____________________________ __________________________

____________________________ __________________________

_____________________________ __________________________

Course Title:

Lecturer Name:

Module/Subject Title:

Assignment Title:

No of Words: