Skip to main content

Power BILaajuus (5 cr)

Code: TX00FI25

Credits

5 op

Responsible person

  • Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Enrollment

01.01.2020

Timing

19.08.2024 - 13.10.2024

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 30

Teachers
  • Chau Truong Minh
Teacher in charge

Ville Jääskeläinen

Groups
  • LT6424K
    Professional Development Program in Information Technology

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Evaluation scale

0-5

Enrollment

01.01.2020

Timing

19.08.2024 - 20.10.2024

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 42

Degree programmes
  • Further Education Programme in Technology, Communication and Transport
Teachers
  • Tivi Virtuaali
Groups
  • LT6724K
    Industrial Management Diploma

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Evaluation scale

0-5

Timing

16.04.2024 - 31.12.2025

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teachers
  • Virve Prami
Teacher in charge

Janne Salonen

Groups
  • ATX25TV_MAKSULLINEN_JÄRJESTELMÄ
    Open UAS 2025
  • ATX24TV_MAKSULLINEN_JÄRJESTELMÄ
    ATX24TV Open UAS

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.01.2024 - 31.12.2025

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.01.2024 - 31.07.2025

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Groups
  • ATX24TV_MAKSULLINEN_JÄRJESTELMÄ
    ATX24TV Open UAS

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.01.2024 - 31.12.2024

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 3000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Groups
  • ATX23_24_Tiedolla_johtamisen_as
    Tiedolla johtamisen asiantuntija johdon päätöksen teon tukitehtäviin

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.01.2024 - 31.12.2025

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.01.2024 - 31.12.2025

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.01.2024 - 31.12.2025

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Groups
  • ATX24TV
    NonStop virtual studies year 2024

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.08.2023 - 29.12.2024

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.08.2023 - 30.07.2025

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.08.2023 - 30.07.2025

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.08.2023 - 30.07.2025

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.08.2023 - 30.07.2025

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.03.2023 - 31.07.2024

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.03.2023 - 31.07.2024

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.03.2023 - 31.07.2024

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.03.2023 - 31.07.2024

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.03.2023 - 31.07.2024

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.03.2023 - 31.07.2024

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Groups
  • ATX23TV_KEVÄT
    ATX23TV_KEVÄT

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.03.2023 - 31.07.2024

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Groups
  • ATX23TV_KEVÄT
    ATX23TV_KEVÄT

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Enrollment

01.01.2020

Timing

01.01.2024 - 19.03.2024

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 30

Teachers
  • Chau Truong Minh
Teacher in charge

Ville Jääskeläinen

Groups
  • LT6423S
    Professional Development Program in Information Technology

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Evaluation scale

0-5

Timing

01.08.2023 - 31.12.2023

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Groups
  • ATX23TV_SYKSY
    Open UAS TestOut and Moodle courses

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

15.06.2023 - 10.07.2023

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Groups
  • ATX23TV_KESÄLOMA
    Kesälomatuuraajan toteutukset

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.03.2023 - 31.12.2023

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

Timing

01.03.2023 - 31.12.2022

Number of ECTS credits allocated

5 op

Virtual portion

5 op

Mode of delivery

Distance learning

Unit

School of ICT

Campus

Karaportti 2

Teaching languages
  • English
Seats

0 - 5000

Degree programmes
  • Information and Communication Technology
Teacher in charge

Janne Salonen

Objective

After completing the course, student has ability in theory and in practise to use Power BI to analyze, present and automate tasks during in his/her workflow.

Content

- Connect to data sources using import, DirectQuery, and live connection options
- Use Power Query Editor for data transformation and data cleansing processes
- Write M and R scripts and dataflows to do the same in the cloud
- Design effective reports with built-in and custom visuals to optimize user experience
- Implement row-level and column-level security in your dashboards
- Deploy your Power BI Desktop files into Power BI Report Server

Location and time

Course can be done in own pace. Course environment is Metropolia's Moodle system.

Materials

Online.

Teaching methods

Course is 100% online (self-study) course which can be done in own pace.

Employer connections

N/A

Exam schedules

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!

International connections

N/A

Completion alternatives

N/A

Student workload

Up to student her-/himself.

Content scheduling

Up to student her-/himself.

Evaluation scale

Hyväksytty/Hylätty

Assessment methods and criteria

The final test contains ?60 multi-choice questions and the duration is 150 minutes and it will be done remotely.

The minimum passing score for the test is 600/1000. If not achieved, the student needs retake the test. The retake limit is 3!