Faculté des Sciences Économiques et de Gestion de Nabeul
 
Utilisateur
Mot de passe

Mastère Professionel Ingénierie des Systèmes d'Information et des Connaissances

Data Warehouses & OLAP

Pré-requis scientifiques

This teaching unit is addressed to students already having practical qualifications on modeling transactional databases and designing operational information systems. Skills and experience on implementing and manipulating databases on DBMS are highly requested. Knowledge on designing and building dashboards is recommended as well.

Objectifs

The data warehousing technology has grown much in scale and reputation in the past few years by the increasing numbers of products, vendors, organizations, and researchers devoted to the subject. In the meantime, the technology is becoming a centerpiece component in the Business Intelligence framework. This teaching unit aims at providing principles and concepts related to the implementation of data warehouses and fundamental techniques for developing On-line Analysis Processing (OLAP) tools as well as issues related to practical use of ad hoc software.

The program of this teaching looks at providing students with skills on building and maintaining data warehouse solutions in the enterprise. It covers training on the philosophy and the fundamental concepts of data warehouses and the position of the technology in the decision-making process. It also addresses the issue of designing a data warehouse schema according to the subject orientation principle. It treats the On-Line Analytical Processing (OLAP) as a BI reporting tool.

Case studies on data warehouse and OLAP applications are included in the teaching package. In addition, in order to build examples of data warehouses and implement OLAP reporting, practical exercises are proposed through specific training on most common software of the BI market: Cognos (IBM), Business Objects (SAP) and Hyperion (Oracle).

Plan de cours

1. The Big Picture
2. Data Warehouse Philosophy
3. Data Warehouse Concepts
4. Warehousing Applications
5. Warehouse Schema Design
6. Business Intelligence Reporting
7. On-Line Analytical Processing
8. OLAP Applications
9. Data Warehouse Implementation
10. Warehousing Software

Supports de cours

(Invisible au public)

Bibliographie

  • The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling - 2nd Edition, Ralph Kimball, Margy Ross, Wiley and Sons, Inc., 2002.
  • Building the Data Warehouse - 1st Edition, Bill Inmon, Wiley and Sons, Inc., 1992.
  • DW 2.0 - Architecture for the Next Generation of Data Warehousing, Bill Inmon, Derek Strauss, Genia Neushloss, Elsevier Press, 2008.
  • Data Warehousing, OLAP and Data Mining, S. Nagabhushana, New Age International Publishers, 2006.
  • Building and Maintaining a Data Warehouse, Fon Silvers, CRC Press, 2008.
  • Data Warehouses and OLAP: Concepts, Architectures and Solutions, Robert Wrembel & Christian Koncilia, IRM Press, 2007.
  • Oracle Warehouse Builder 11gR2: Getting Started 2011, Bob Griesemer, Packt Publishing, 2011.

Responsable

Melle Boutheina Fessi
Maître assistant
Département Méthodes Quantitatives et Informatique

Organisation pédagogique

21 heures de cours
21 heures de travaux pratiques
Coefficient3
Crédits5

Modalités d'évaluation

Liens Internet utiles

Auteur de la page : Melle Boutheina Fessi - Dernière mise à jour : 7 mai 2012 à 00h00

Activités culturelles