Aller à : contenu haut bas recherche
 
 
EN     FR
Vous êtes ici:   UNIL > HEC Inst. > HEC App. > SYLLABUS
 
 

Datawarehousing (UNINE)

  • Enseignant(s): I.Ciorascu
  • Titre en français: Le data warehousing (UNINE)
  • Cours donné en: anglais
  • Crédits ECTS: 6 crédits
  • Horaire: Semestre de printemps 2018-2019, 4.0h. de cours (moyenne hebdomadaire)
  •  séances
  • site web du cours site web du cours
  • Formation concernée: Maîtrise universitaire ès Sciences en systèmes d'information

 

Objectifs

a) Identify differences between application operational data modelling and warehouse data modelling, explore the purpose of subject modelling, and develop a subject area model.
b) Apply techniques to develop a robust and representative list of business questions and translate them into data models.
c) Identify clusters of data elements with a natural affinity to be grouped as data marts.
d) Make informed choices between relational and dimensional data structures
e) Analyse dimension properties including domain size, density/sparsity, and volatility; describe advanced modelling techniques for slowly-changing dimensions.

Contenus

1. Basic notions: business intelligence, data warehouse, corporate information factory
2. Fundamental relational concepts: data models, normalisation, guidelines
3. Analysis and design issues: life cycle, modelling, star and snowflake schema, cubes, fact tables, dimensional tables, aggregation, etc.
Exercices The students will develop their own data warehouse during laboratory exercices. After each step of the data warehouse life cycle a presentation is required and evaluated.

Références

Textbooks R Imhoff, Claudia et al., Mastering Data Warehouse Design: Relational and Dimensional Techniques, J. Wiley, 2003, ISBN: 0471324213 R Inmon, William H. Building the Data Warehouse 4th ed., John Wiley & Sons Inc., 2005, ISBN: 0764599445

Evaluation

1ère tentative

Examen:
Ecrit 2h00 heures
Documentation:
Autorisée
Calculatrice:
Non autorisée
Evaluation:

EXAMEN ORGANISE PAR NEUCHATEL 2-hour written exam during (at the end of) the semester (60%) and project(s) (40%)

Documentation accepted. No connected devices are permitted during the exams. In case of violation of this rule, the students are in a situation of fraud and the unauthorized items will be removed. The exam could be deemed as failed.

Rattrapage

Examen:
Ecrit 2h00 heures
Documentation:
Autorisée
Calculatrice:
Non autorisée
Evaluation:

Catch-up exam: 2-hour written exam (100%) in the official session

Documentation accepted. No connected devices are permitted during the exams. In case of violation of this rule, the students are in a situation of fraud and the unauthorized items will be removed. The exam could be deemed as failed.



[» page précédente]           [» liste des cours]
 
Recherche


Internef - CH-1015 Lausanne - Suisse  -   Tél. +41 21 692 33 00  -   Fax +41 21 692 33 05
Swiss University