Module summary

The module provides an introduction to relational data modelling and multidimensional data modelling techniques for data analytics. It enables students to acquire skills in advanced SQL and OLAP operations (OLAP cube, rollup, drill-down, slice and dice and pivot). The module is designed to help students with practical skills in preparing data for analysis which usually takes 50%-70% of data analytical project time. Big Data analytics platforms will also be introduced.

Module aims

The aims of this module are to:

provide students with an understanding of key data modelling and OLAP concepts and techniques;

enable students to acquire knowledge of data warehouse and multidimensional data models;

develop students expertise in advanced SQL and OLAP operations;

develop students with practical skills in preparing data for analysis;

Learning and teaching

Topics will be introduced through the medium of formal lectures, supported by tutorial and workshop sessions, and blended learning as follows:

- Lecture (2 hour / week):
Introduction of the major topics identified in the syllabus, plus practical exercises, directed reading and other further studies

- Workshop (2 hour / week):
Practical skills will be further developed through lab-based workshops. Specific practical exercises are set to support students' development of skills in SQL, Data modelling and OLAP operations.
.
- Blended learning:
Using the University’s VLE and online tools to provide deliver content, assessment and feedback, to encourage active learning, and to enhance student engagement and learning experience.

Students will be expected and encouraged to produce reflective commentaries on the learning activities and tasks that they carry out to complete their work.

Learning outcomes

On successful completion of this module the student should be able to:
[LO1] Demonstrate a clear understanding of the various fundamental concepts of data modelling, data warehouse, and OLAP.
[LO2] Apply a sufficient level of knowledge and proficiency in relational and multidimensional data modelling techniques for data analytics.
[LO3] Demonstrate competence in advanced SQL and OLAP operations.
[LO4] Gain a considerable exposure to the practical skills in preparing data for analysis.
[LO5] Develop an enhanced awareness of some current developments in big data analytics platforms for data analytics.
[LO6] Analyse, appraise and apply legal, social, ethical, professional issues for developing systems.

Assessment strategy

The module will be assessed by a practical piece of coursework (60%) and a 2-hour unseen examination (40%).

The coursework is designed mainly to assess the practical aspects of the module:

It will provide students with the opportunity to undertake research on current issues and practical techniques in data modelling, SQL and OLAP for data analytical [LO1, LO2, LO3, LO4, LO5, LO6].
It will also enable students to apply their knowledge to a practical data analytical problem, demonstrating their skills for problem-solving and critical thinking/evaluation [LO2, LO3, LO4].

The unseen examination will provide an opportunity for students to demonstrate their understanding of data modelling, data warehouse, and OLAP concepts and techniques and their ability to apply these techniques appropriately to the solution of given problems/scenarios [LO1, LO2, LO3, LO5].
The examination will test the students' retention, understanding and insight of material drawn from the module.