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

Datawarehousing (UNINE)

  • Teacher(s):  
  • Course given in: English
  • ECTS Credits:
  • Schedule: Spring Semester 2018-2019, 4.0h. course (weekly average)
  •  sessions
  • site web du cours course website
  • Related programme: Master of Science (MSc) in Information Systems

 

Objectives

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.

Contents

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.

References

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

First attempt

Exam:
Written 2h00 hours
Documentation:
Allowed
Calculator:
Not allowed
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.

Retake

Exam:
Written 2h00 hours
Documentation:
Allowed
Calculator:
Not allowed
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.



[» go back]           [» courses list]
 
Search


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