Management Reporting, BI (5cr)

Intro

In the course, you will learn how to use BI-tools, create dashboards and reports. The course introduces data model and data editing concepts in BI- reporting. Hands-on class exercises are introduced to illustrate how reports can be constructed and distributed to end users.

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

Implementation methods:

CONTACT / CONTACT BLENDED
ONLINE / ONLINE BLENDED

Descriptions of implementation methods can be found in Haaga-Helia's website: https://www.haaga-helia.fi/en/implementation-types

You can complete the course unit by demonstrating or by Work&Study even if the course unit doesn't have DEMO or WORKSTUDY implementations.

More information about recognition of learning at Haaga-Helia's website: https://www.haaga-helia.fi/en/career-planning/recognition-learning

In the demonstration assignment, you must independently demonstrate your ability to build a BI reporting environment and apply basic-level SQL skills.

Learning materials

Exam Ref PL-300 Microsoft Power BI Data Analyst, Daniil Maslyuk, Pearson Education (US), 2022
Other material distributed by the lecturer in the course.

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