BI, Analytics and Reporting (5 op)
Toteutuksen tunnus: AL00CJ20-3001
Toteutuksen perustiedot
Ilmoittautumisaika
20.11.2023 - 12.01.2024
Ajoitus
15.01.2024 - 12.04.2024
Opintopistemäärä
5 op
Virtuaaliosuus
5 op
Toteutustapa
Etäopetus
Yksikkö
Liiketoiminta (LAB)
Toimipiste
Verkkokampus
Opetuskielet
- Englanti
Paikat
0 - 100
Koulutus
- Complementary competence, Bachelor's
Opettaja
- Jaani Väisänen
- Marianne Viinikainen
Opetusryhmät
- Online lectures (Koko: 0. Avoin AMK: 0.)
- Independent studies (Koko: 0. Avoin AMK: 0.)
- Online exam (Koko: 0. Avoin AMK: 0.)
Ryhmät
-
LLABTO23-24EComplementary competence (Bachelor's) 2023-2024, Faculty of Business and Hospitality Management
-
LLTIEX24K2Saapuvat vaihto-opiskelijat 24K, pitkät vaihdot, tietojenkäsittely, Lahti
-
LLTIEX24K1Saapuvat vaihto-opiskelijat 24K, pitkät vaihdot, liiketalous, Lahti
Pienryhmät
- Online lectures
- Independent studies
- Online exam
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.