Opinto-opas

Osaamistavoitteet

The student is able to
- describe business intelligence (BI) concepts and current BI tools and software.
- familiarize yourself with the requirements and analysis methods of a data analyst.
- utilize data visulization and analysis tools

Toteutustapa ja opetusmenetelmät

In this course, the student will find an introduction to concepts of business intelligence (BI), analytics and reporting, as well as the latest working life tools and software. The course is implemented through lectures, visitors, virtual studies and assignments.

Ajoitus ja läsnäolo

Course will take place between weeks 3 and 15. The course is held 100% online. Attending Zoom lectures is not mandatory, but active participation is recommended. The topic is important in future working life.

Oppimateriaali ja suositeltava kirjallisuus

All course material is available in the Moodle learning environment.

Note! At Power BI lectures, we use Power BI Desktop software. Microsoft Power BI Desktop can be installed only on Windows environment. You must therefore have a Windows machine to complete the course. If you are a LAB student and have a Mac computer, you can use Power BI Desktop on a LAB Win10 2D virtual workstation (LAB account required). Please take this into account before starting the course.

Toteutuksen valinnaiset suoritustavat

The course is conducted only according to the presented model.

Työelämäyhteistyö

The course has visitors from the business world and we use the latest working life tools.

Uusintamahdollisuudet

Only course section exams can be renewed, i.e. assignments cannot be returned afterwards and they cannot be redone. Retakes of the course's section exams are organized in weeks 17/2024 and 19/2024.

Oppimisympäristö

The learning environment is Moodle. In addition, we use modern tools related to the topic of the course.

Opiskelijan ajankäyttö ja kuormitus

This is a five-credit course, equivalent to 135 hours of student work.

Sisältö

The content of the course is as follows:
- Business Intelligence, analytics and reporting, terminology and concepts, BI in practice
- Data Science and Big data
- Data management / data warehouses
- Business value through analytics
- Google ecosystem
- Microsoft Excel: Key functions, Pivot and PowerPivot
- Qlik Sense
- Microsoft Power BI
- Balanced Scorecard and dashboards

Arviointimenetelmät

The course is evaluated on a scale of 1 to 5. The student can get a total of 100 points from the course. The student can collect points through section exams and assignments. In order to receive an approved grade for the course, the student must receive 45% of the total points, ie a minimum of 45/100 points. The course grade is calculated according to the following scoring system:

- grade 5: 100,0-90,0 points
- grade 4: 89,0-78,0 points
- grade 3: 77,9-65,0 points
- grade 2: 64,9-55,0 points
- grade 1: 54,9-45,0 points
- failed: 44,9-0,0 points

Arviointiasteikko

1-5

Hylätty (0)

Rejected (fail) grade is given when the student has not achieved the learning objectives of the course. Student does not understand the essentials of business intelligence, analytics and reporting, is not able to show any learning outcomes in the exam and assignments.

Arviointikriteerit: taso 1: (arviointiasteikko 1-5)

Student understands the essentials of business intelligence, analytics and reporting, is able to show some learning outcomes in the section exams and assignments. Student is able to use some professional concepts consistently. Student needs support in completing the assignments.

Arviointikriteerit: taso 3 (arviointiasteikko 1-5)

Student has good knowledge about the basic concepts of business intelligence, analytics and reporting, is able to show good learning outcomes in the section exams and assignments. Student uses professional concepts fluently and extensively. Student still requires a little support in doing the assignments.

Arviointikriteerit: taso 5 (arviointiasteikko 1-5)

Student has excellent knowledge and understanding of the basic concepts of Business Intelligence and Controlling, is able to show excellent learning outcomes in the exam and assignments. Student can independently acquire new knowledge and use professional concepts expertly. Student performs the tasks independently.

Osaamistavoitteet

The student is able to
- describe business intelligence (BI) concepts and current BI tools and software.
- familiarize yourself with the requirements and analysis methods of a data analyst.
- utilize data visulization and analysis tools

Toteutustapa ja opetusmenetelmät

In this course, student will find an introduction to business intelligence (BI) concepts and current BI tools and software.The course is implemented through lectures, visitors, virtual studies and assignments.

Ajoitus ja läsnäolo

Course will take place between weeks 3 and 12. The course is held 100% online. Attending Zoom lectures is not mandatory, but active participation is recommended. The topic is important in future working life.

Oppimateriaali ja suositeltava kirjallisuus

All course material is available in the Moodle learning environment.

Toteutuksen valinnaiset suoritustavat

The course is conducted only according to the presented model.

Työelämäyhteistyö

The course has visitors from business and we use the latest tools available in working life.

Oppimisympäristö

The learning environment is Moodle. In addition, we use modern tools related to the topic of the course.

Opiskelijan ajankäyttö ja kuormitus

This is a five-credit course, equivalent to 135 hours of student work.

Sisältö

The course contents is as follows:
- Business Intelligence and Controlling, terminology and concepts, BI in practice
- Data Science and Big data
- Financial Analytics and reporting
- Microsoft Excel: Key functions, Pivot and PowerPivot
- Balanced Scorecard
- Microsoft Power BI
- Qlik Sense

Arviointimenetelmät

The course is evaluated on a scale of 1 to 5. You can get a total of 100 points from the course. In order to receive an approved grade for a course, you must a) receive 45% of the total points, ie a minimum of 45/100 points, and b) must pass the course exam satisfactorily. The grade for the course is calculated as follows: returned assignments 50% and exam 50%. The course exam and grade are calculated according to the following scoring:
- grade 5: 100,0-90,0 points
- grade 4: 89,0-78,0 points
- grade 3: 77,9-65,0 points
- grade 2: 64,9-55,0 points
- grade 1: 54,9-45,0 points
- failed: 44,9-0,0 points

Arviointiasteikko

1-5

Hylätty (0)

Rejected (fail) grade is given when the student has not achieved the learning objectives of the course. Student does not understand the essentials of Business Intelligence and Controlling, is not able to show any learning outcomes in the exam and assignments.

Arviointikriteerit: taso 1: (arviointiasteikko 1-5)

Student understands the essentials of Business Intelligence and Controlling, is able to show some learning outcomes in the exam and assignments. Student is able to use some professional concepts consistently. Student needs support in completing the assignments.

Arviointikriteerit: taso 3 (arviointiasteikko 1-5)

Student has good knowledge about the basic concepts of Business Intelligence and Controlling, is able to show good learning outcomes in the exam and assignments. Student uses professional concepts fluently and extensively. Student still requires a little support in doing the assignments.

Arviointikriteerit: taso 5 (arviointiasteikko 1-5)

Student has excellent knowledge and understanding of the basic concepts of Business Intelligence and Controlling, is able to show excellent learning outcomes in the exam and assignments. Student can independently acquire new knowledge and use professional concepts expertly. Student performs the tasks independently.