Data preprocessing in the cloud (3 cr)

Evaluation scale

Pass/Fail

Objective

Do you want to learn how to import data into the cloud from multiple background sources and refine it into a format where it can be utilised? In the course, you will learn how that data needs to be edited and preprocessed to suitable formats, so that it can be used in business in useful ways. As you complete this lesson, you will have learned the possibilities of data preprocessing (Extract, Transform, Load) and will familiarized yourself with the tools to edit data into various formats needed by different systems or services.

Content

- Data preprocessing with cloud services
- Extract data from various sources, transform, and load data to needed formats.

Materials

Material written by the teacher can be found at Moodle. Any AWS documentation and Academy Learning material or additional Data pre-processing books can be used as additional material.

Teaching methods

- Lectures (online)
- Contact lessons
- Exercises
- Tests
- Final exam

The primary mode of delivery is a combination of in-class activities on campus and on-line lectures. The lectures will be recorded to support opportunities for 24/7 learning. The in-class activities deepen the learning in the forms of tutorials, individual and group works, reflection and guidance. However, if the COVID-19 situation requires the learning will be supported by on-line tutorials.

Exam schedules

The final exam is held at the end of the course. Renewal opportunities will be announced at the end of the course.

Student workload

Approximately 81 hours.

Assessment criteria, approved/failed

- Assignments done
- Learning diary returned
- Exam completed successfully

Qualifications

Basic skills in information technology,
Basic programming skills
SQL basics
Scripting basics