MIS41060 Data Management

Academic Year 2018/2019

Option.
This is a sister module to Programming for Analytics, but goes into much more detail on data management, with less emphasis on algorithms and coding.

Topics:
● Structured versus unstructured data, from databases to lakes
● Structured data: DBs, SQL, Extract transform and load
● Unstructured: Text data and natural language processing, image, audio, video
● Big data
● Data cleansing, quality, curation
● Real-time analytics
● Security, privacy, and ethics in data

Show/hide contentOpenClose All

Curricular information is subject to change

Learning Outcomes:

After this module, students should be able to:
● Distinguish between structured and unstructured data, and explain common terminology from databases to data lakes
● Describe the ETL process
● Read, write and manage databases using SQL
● Distinguish different types of unstructured data, and their uses and typical methods of storing, accessing and processing them
● Define big data and the problems and some of the solutions associated with it
● Define real-time analytics and the problems and some of the solutions associated with it
● Describe the goals of data cleansing and curation and execute them in code
● Explain the issues of security, privacy and ethics in data, and bring these to bear on projects where appropriate

Student Effort Hours: 
Student Effort Type Hours
Lectures

24

Computer Aided Lab

24

Autonomous Student Learning

48

Total

96

 
Requirements, Exclusions and Recommendations

Not applicable to this module.



 
Description % of Final Grade Timing
Examination: Exam

50

2 hour End of Trimester Exam
Project: Technical Project

25

Throughout the Trimester
Continuous Assessment: Participation/Presentation

25

Throughout the Trimester

Compensation

This module is not passable by compensation

Resit Opportunities

No Resit

Remediation

If a resist is required students will be asked to undertake a project, to be decided at the time, which will encomapss the course curriculum.

Name Role
MSc Stefan Forstenlechner Tutor