Curricula

Objectives

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.

Time and location

Weeks 40-48, 7 lectures (ex w42&w45). Main campus.

Learning materials and recommended literature

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 as a backup) , main campus
- Individual and group assignments
- Final exam

The primary mode of delivery is a combination of in-class activities on campus. The in-class activities deepen the learning in the forms of tutorials, individual and group works, reflection and guidance.

Practical training and working life connections

Visiting lecturer from an it-organization is planned to visit the last lecture.

Exam dates and retake possibilities

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

Alternative completion methods

You can apply for a recognition of prior knowledge through the eRPL process. Contact the teacher by e-mail.

Student workload

Approximately 81 hours.

Further information for students

Assesment criteria Pass/Fail:
- Individual and group assignments returned and accepted
- Exam passed

Evaluation scale

Pass/Fail

Evaluation criteria, pass/failed

- Assignments done
- Learning diary returned
- Exam completed successfully

Prerequisites

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

Objectives

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.

Learning materials and recommended literature

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 as a backup)
- Contact lessons
- Exercises
- Tests
- Final exam

The primary mode of delivery is a combination of in-class activities on campus. The in-class activities deepen the learning in the forms of tutorials, individual and group works, reflection and guidance.

Exam dates and retake possibilities

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

Student workload

Approximately 81 hours.

Further information for students

Assesment criteria Pass/Fail:
- Individual and group assignments returned and accepted
- Exam passed

Evaluation scale

Pass/Fail

Evaluation criteria, pass/failed

- Assignments done
- Learning diary returned
- Exam completed successfully

Prerequisites

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

Objectives

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.

Learning materials and recommended literature

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 as a backup)
- Contact lessons
- Exercises
- Tests
- Final exam

The primary mode of delivery is a combination of in-class activities on campus. 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 dates and retake possibilities

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.

Evaluation scale

Pass/Fail

Evaluation criteria, pass/failed

- Assignments done
- Learning diary returned
- Exam completed successfully

Prerequisites

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