Study Guide

Learning outcomes

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

Implementation and methods of teaching

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.

Timing and attendance

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.

Learning material and recommended literature

All course material is available in the Moodle learning environment.

Alternative completion methods

The course is conducted only according to the presented model.

Working life cooperation

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

Exam retakes

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

Learning environment

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

Student time use and work load

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

Contents

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

Assessment criteria

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

Assessment scale

1-5

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

Assessment criteria: level 1 (assessment scale 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.

Assessment criteria: level 3 (assessment scale 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.

Assessment criteria: level 5 (assessment scale 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.

Learning outcomes

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

Implementation and methods of teaching

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.

Timing and attendance

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.

Learning material and recommended literature

All course material is available in the Moodle learning environment.

Alternative completion methods

The course is conducted only according to the presented model.

Working life cooperation

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

Learning environment

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

Student time use and work load

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

Contents

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

Assessment criteria

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

Assessment scale

1-5

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

Assessment criteria: level 1 (assessment scale 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.

Assessment criteria: level 3 (assessment scale 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.

Assessment criteria: level 5 (assessment scale 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.