BUSINESS REPORTING TOOLS

Code Cours
2324-IÉSEG-MBD1S1-MIS-MBDCE03UE
Langue d'enseignement
English
Matières
MANAGEMENT OF INFORMATION SYSTEMS
Ce cours apparaît dans les formation(s) suivante(s)
Responsable(s)
M.MEIRE
Intervenant(s)
M.MEIRE
Niveau
-
Année de formation
Période

Présentation

Prérequis
None
Objectifs
At the end of the course, the student should be able to:
- understand how databases and data stores work, which allows to employ state-of-the-art management techniques based on data management
- demonstrate insight into the key concepts and techniques is SQL and data visualization
- serve as a reference point with regard to these topics and data analysis in general
- use SQL to retrieve data from database systems, to gain insights from these data and transform data to make effective organizational decisions
- create creative solutions using the datasets available to solve real managerial problems
- provide insightful stories or dashboards in Tableau that allow visualizing and taking advantage of the opportunities and challenges for companies

These competencies and/or skills contribute to the following learning objectives
- 3.B Propose creative solutions within an organization
- 5.C Employ state-of-the-art management techniques
- 5.D. Make effectual organizational decisions
- 7.A Demonstrate an expertise on key concepts, techniques and trends in their professional field
- 7.C Effectively apply in-depth specialized knowledge to take advantage of contemporary opportunities in their professional field
- 7.D Be a reference point for expertise-related questions and ambiguities
Présentation
Students will learn how relational databases are used in companies to store important data. They will use the structured query language (SQL) to retrieve data from a database, transform it and gain actionable insights into the business. Once the basic of data modelling has been studied, students will also be able to create databases and schemes themselves. Tableau will be used to make advanced visualizations of data, so that students can visualy inspect data but also meaningfully present their insights to non-technical stakeholders. As such, the students are provided with state-of-the-art techniques allowing them to be a speaking board when it comes to data analysis.

Modalités

Organisation
Type Amount of time Comment
Présentiel
Cours magistral 4,00
Cours interactif 20,00
Travail personnel
Group Project 26,00
Charge de travail personnel indicative 25,00
Overall student workload 75,00
Évaluation
The students will be evaluated based on several aspects:
- participation in the exercises to be made at home. Feedback on these exercises is given in general, but not explicitly to single students. It can be requested at any time by the students if needed
- a final exam to measure the capacity to apply the constucts learned in class. Feedback will be given on request.
- a group project that is also evaluated with peer evaluation
- an individual project
Control type Duration Amount Weighting
Autres
Projet Collectif 5,00 1 20,00
Projet Individuel 5,00 1 20,00
Examen (final)
Examen écrit 12,00 0 50,00
Contrôle continu
Participation 2,00 1 10,00
TOTAL 100,00

Ressources

Bibliographie
Principles of Database Management (Baesens et al., 2018) -
Ressources Internet