Required in stage
Optional in stage
First term
Second term
Both terms
This year
Next year
Alternating years
External
Prerequisites
Language of instruction
Duration
Identical coursesBusiness Intelligence 2 (B-TM-YP0436)
Tubbax Hans (coordinator) | Tubbax Hans Aims
A. description
1. The student is able to interpret a managerial question of the "business" and build a meaningful analysis and reporting to overcome them.
2. Understands the characteristics of multidimensional data structures.
3. Understand how multidimensional screening of figures can help in the management process.
4. Is able to create an OLAP data model that meets functional requirements, with due attention to: dimensions, hierarchies and multiple data sources.
5. Can think proactive with regards to the needs of the business.
6. Can handle an OLAP tool from a practical managerial perspective (exploration and ad hoc analysis).
7. Can produce standard OLAP reports.
B. Learning outcomes
IM_AC_01 - Taking qualitative actions to solve problems in a flexible, creative and accurate way. integration Level
IM_AC_02 - Building a qualitative reasoning. integration Level
IM_AC_03 - Acquiring and processing information. integration Level
IM_BS_IMS_04 - Supporting the company. integration Level
IM_BS_IMS_05 - Implementing Business Applications. advanced level
IM_BS_IMS_06 - Realization of an information infrastructure. integration Level
Previous knowledge
Educational goals of Business Intelligence 1 are desirable.
Is included in these courses of study
Activities
4 ects. Business Intelligence 2 (B-TM-YP5460)
Content
Introduction to OLAP (Online Analytical Processing) Using a tool OLAP (Online Analytical Processing). This tool allows analysis of corporate data through multidimensional cubes.
The student must then:
- Understand the context of transactional systems, data warehouse and OLAP tools.
- understand how multidimensional screening of figures can help in the management process.
- Understand the characteristics of multidimensional data structures. On the one hand he should be able to handle an OLAP tool in the role of Business Manager to analyse a business problem. On the other hand, in the role of an IT person, he should be able to design and implement a multidimensional model based on the business needs.
This means:
- being able to handle an OLAP tool from a managerial perspective (explorative searching for information).
- being able to interpret a managerial business question and build a meaningful analysis and reporting for this.
- Build tailored OLAP reports.
- being able to create an OLAP cube and fill it up so that the cube meets functional requirements.
Course material
Assignments and study materials are on Toledo
Format: more information
During the practicum, students must mainly acquire the ability to work with an OLAP tool.
With the OLAP tool the student should apply the theoretical OLAP principles in practical exercises.
*
Seminar where students have to implement the theoretical principles into practices.