Siirry suoraan sisältöön

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 and optional courses taught in English: Bachelors

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-24E
    Complementary competence (Bachelor's) 2023-2024, Faculty of Business and Hospitality Management
  • LLTIEX24K2
    Saapuvat vaihto-opiskelijat 24K, pitkät vaihdot, tietojenkäsittely, Lahti
  • LLTIEX24K1
    Saapuvat 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.