Opetussuunnitelmat

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 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 schedules

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

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

Evaluation scale

Pass/Fail

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

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 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 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.

Evaluation scale

Pass/Fail

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