Fiche détaillée d'un cours


 


Voir la fiche établissement

BUSINESS REPORTING TOOLS

2016-2017

IESEG School of Management ( IÉSEG )

Code Cours :

1617-IÉSEG-MBD1S1-MIS-MBDCE03UE

MANAGEMENT OF INFORMATION SYSTEMS


Niveau Année de formation Période Langue d'enseignement 
MSc in Big Data Analytics for Business1S1English
Professeur(s) responsable(s)K.COUSSEMENT
Intervenant(s)D.CIELEN


Pré requis

None

Objectifs du cours

At the end of the course, the student should be able to:
Understand how databases and data stores work
Use SQL to retrieve and transform data
Understand data modelling
gain insights from data using SQL and relate them to business problems
Make visualizations and reports in Tableau

Contenu du cours

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


Modalités d'enseignement

Organisation du cours

TypeNombre d'heuresRemarques
Face to face
lecture16,00  
Coaching12,00  
PBL class4,00  
Independent study
Group Project30,00  
Estimated personal workload30,00  
Independent work
Research8,00  
Charge de travail globale de l'étudiant100,00  

Méthodes pédagogiques

  • Presentation
  • Project work
  • Interactive class
  • Coaching


Évaluation

students will have to perform a group task around a translation agency.
An individual programming exam will be performed to test theoretical knowledge

Type de ContrôleDuréeNombrePondération
Final Exam
Written exam1,00150,00
Others
Group Project1,00150,00
TOTAL     100,00

Bibliographie

  • Learning SQL, Alan Beaulieu, ISBN: 978-0596520830 -


Ressources internet



 
* Informations non contractuelles et pouvant être soumises à modification
 
 
Vidéo : Un campus à vivre
Notre chaîne Youtube