Management Reporting, BILaajuus (5 cr)

Learning objectives

The course introduces student to business data management using modern business intelligence reporting tools. Student builds understanding of databases and metadata in business analytics.The learning objective of the course is to build skills that enable producing business intelligence reports and key performance indicators.

After completing the course, student understands the building blocks of financial reporting and can use reporting applications. Student learn how to modify and build reporting solutions independently in order to support business managers.

Contents

- Excel in BI reporting
- Basics of the SQL language
- Databases in BI reporting
- Use of a modern BI-tools in financial reporting

Implementation methods, demonstration and Work&Study

1) Implementation methods of the course: contact, online and blended
2) If you already know the competence objectives of this course, you can show your competence. Ask the teacher of the course for more information. More information on the identification of skills: https://www.haaga-helia.fi/fi/osaamisen-tunstämaminen-ja-work-study.

Assessment criteria - grade 1

When the implementation type of the course is CONTACT, ONLINE or BLENDED it is required that the student is present during those teaching hours that are marked in the study schedule. If you are absent more than 25 %, your grade will be lowered by one. If you are absent more than 50 %, the course is failed.

At the level of competence, the student:
- Knows the connections between operational systems of financial reporting
- Able to maintain and modify operational reports
- Knows the concept of metadata and database structure

Assessment criteria - grade 3

At the level of competence, the student:
- Can build a reporting environment under supervision
- Knows readiness for developing business intelligence reporting
- Can create database connections to different financial applications for reporting purposes
- Can interpret key performance indicator presented in dashboards

Assessment criteria - grade 5

At the level of competence, the student:
- Can act internal consultant in business reporting projects
- Can build a reporting environment independently
- Knows the how to enhance BI-reporting skills independently
- Can build key performance indicator dashboards

Learning materials

Exam Ref DA-100 Analyzing Data with Microsoft Power BI, Daniil Maslyuk, Microsoft Press,2021
Other material distributed by the lecturer in the course.