Data Management and Business Intelligence (B-KUL-HMH25F)

Aims
This course evaluates the following learning outcomes:
The student
1.1 (BIM) analyzes ICT-related operational problems and questions taking into account the specific business context.
1.3 (BIM) formulates an architectural solution for operational ICT problems and questions based on knowledge of and insight into technical support of ICT, and takes into account the specific business context in this formulation.
2.2 (BIM) formulates a well-founded solution for strategic ICT problems and questions based on scientific knowledge and understanding of ICT, and takes hereby into account the specific business context, the stakeholders involved and the wider environment in which the organization is active.
3.1 (BIM) plans, organizes, evaluates and optimizes decision making analysis processes (added value by analyzing operational data), ICT project management (organization of an IT project), governance and management of IT services (organization of the IT department) and manages the planning , organization and evaluation of the business processes regarding decision analysis, software project management, governance and management of IT services take into account the specific business context and the integration of the different processes.
4.1 (BIM) critically reflects on how social, organizational and technical trends affect the labor market and ICT in the organization, taking into account (the consequences for) the stakeholders involved.
10.1 (BIM) keeps his / her knowledge of ICT themes and the market up-to-date, both on the basis of practical, policy-oriented, technical and scientific information.
10.2 (BIM) integrates policy-oriented, technical, scientific and practice-oriented information on specific ICT-market-related themes, and takes a substantiated view on the relevance of the specific theme for the organization.
10.3 (BIM) critically reflects on how important evolutions and innovations in ICT can be translated into the IT policy in the organization, taking into account the specific business context.
- The student is familiar with basic concepts of data management (e.g. ERD, relational model, SQL, data warehousing)
- The student can read and design a conceptual and relational data model
- The student can write queries in SQL
- The student is familiar with basic concepts in the field of business intelligence (OLAP, cubes, data mining)
- The student can apply basic data mining techniques
- The student is familiar with relational database systems (e.g. MySQL)
Previous knowledge
There is no specific knowledge required for this course.
Is included in these courses of study
- Master in de handelswetenschappen (dag + avond, programma voor studenten gestart vóór 2024-2025) (Brussel) (Specialisatie business information management) 60 ects.
- Master of Business Administration (Brussels) (Track Business Information Management) 60 ects.
- Courses for Exchange Students Faculty of Economics and Business (Brussels)
Activities
3 ects. Data Management (B-KUL-HMH25f)
Content
In this OLA, the student learns how to develop data bases and data warehouses, using methods such as ERD, the relational model, normalisation, ...
Course material
Chapters from manuals, exercises, slides, the use of applications (software).
https://webapps.odisee.be/Ancor/SSM/Pages/BekijkSSM.aspx?OID=23864
Format: more information
The course will follow the flipped classroom principle meaning that theoretical sessions will be furnished as pre-recorded online material. Students can follow these at will and on their own tempo. On-site (face to face) sessions will essentially be devoted to practical exercises, interactions with the teacher and feedback.
3 ects. Business Intelligence (B-KUL-HMH25g)
Content
In this OLA, students are taught specific business intelligence concepts and techniques such as SQL and data mining. A thorough knowledge of the first OLA is required.
Course material
Chapters from manuals, exercises, slides, the use of applications (software).
Format: more information
This OLA consists of class-based instruction, with a practical focus (exercises, the use of software).
Evaluation
Evaluation: Data Management and Business Intelligence (B-KUL-H75022)
Explanation
Determination of the final grades
The grades are determined by the lecturer as communicated via Toledo and stated in the examination schedule. The result is calculated and communicated as a whole number on a scale of 20.
The results will be calculated using the grades of:
- an individual written exam.
- one or two group projecta.
Second examination opportunity
The features of the evaluation and determination of grades are identical to those of the first examination opportunity, as described above.
Information about retaking exams
This course unit allows partial mark transfers in case of partial pass mark:
- HMH25f - Data Management (during academic year)
- HMH25g - Business Intelligence (during academic year)