Skip to main content

Data preprocessing in the cloudLaajuus (3 cr)

Code: HT00BN66

Credits

3 op

Teaching language

  • Finnish

Responsible person

  • Juha-Tapio Teno

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.

Qualifications

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

Assessment criteria, approved/failed

- Assignments done
- Learning diary returned
- Exam completed successfully

Materials

Course material written by the teacher as well as selected online resources.

Enrollment

01.08.2024 - 22.08.2024

Timing

30.09.2024 - 29.11.2024

Number of ECTS credits allocated

3 op

Mode of delivery

Face-to-face

Unit

School of Business

Campus

Main Campus

Teaching languages
  • Finnish
Seats

20 - 30

Degree programmes
  • Bachelor's Degree Programme in Business Information Technology
Teachers
  • Juha-Tapio Teno
Groups
  • ZJA24SI
    Avoin amk, tiko
  • ZJK24SI
    Korkeakoulujen välinen yhteistyö, TIKO
  • HTK23S1
    Tietojenkäsittely (AMK)

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

Enrollment

01.08.2023 - 24.08.2023

Timing

02.10.2023 - 19.12.2023

Number of ECTS credits allocated

3 op

Mode of delivery

Face-to-face

Unit

School of Business

Campus

Main Campus

Teaching languages
  • Finnish
Seats

20 - 30

Degree programmes
  • Bachelor's Degree Programme in Business Information Technology
Teachers
  • Juha-Tapio Teno
Groups
  • HTK22S1
    Tietojenkäsittely (AMK)

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

Enrollment

01.08.2022 - 25.08.2022

Timing

03.10.2022 - 21.12.2022

Number of ECTS credits allocated

3 op

Mode of delivery

Face-to-face

Unit

School of Business

Teaching languages
  • Finnish
Seats

0 - 30

Degree programmes
  • Bachelor's Degree Programme in Business Information Technology
Teachers
  • Juha-Tapio Teno
Groups
  • HTK21S1
    Tietojenkäsittely (AMK)

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