BI, Analytics and ReportingLaajuus (5 cr)
Code: AL00CJ20
Credits
5 op
Teaching language
- English
Objective
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
Enrollment
20.11.2023 - 12.01.2024
Timing
15.01.2024 - 12.04.2024
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Distance learning
Unit
Faculty of Business and Hospitality Management (LAB)
Campus
E-campus
Teaching languages
- English
Seats
0 - 100
Degree programmes
- Complementary competence and optional courses taught in English: Bachelors
Teachers
- Jaani Väisänen
- Marianne Viinikainen
Scheduling groups
- Online lectures (Size: 0. Open UAS: 0.)
- Independent studies (Size: 0. Open UAS: 0.)
- Online exam (Size: 0. Open UAS: 0.)
Groups
-
LLABTO23-24EComplementary competence (Bachelor's) 2023-2024, Faculty of Business and Hospitality Management
-
LLTIEX24K2
-
LLTIEX24K1
Small groups
- Online lectures
- Independent studies
- Online exam
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.
Enrollment
21.11.2022 - 15.01.2023
Timing
18.01.2023 - 24.03.2023
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Distance learning
Unit
Faculty of Business and Hospitality Management (LAB)
Campus
E-campus
Teaching languages
- English
Seats
20 - 50
Degree programmes
- Complementary competence and optional courses, Bachelors
Teachers
- Marianne Viinikainen
Scheduling groups
- Verkkoluento (Size: 0. Open UAS: 0.)
- Itsenäinen (Size: 0. Open UAS: 0.)
- Tentti (Size: 0. Open UAS: 0.)
Groups
-
LLTIEX23K1
-
LLABTO23H
-
LLPREX23KIB
Small groups
- Online lectures
- Independent study
- Exam
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.