Introduction à la modélisation dimensionnelle Kimball

📋 Plan du Cours

1. Kimball Dimensional Modeling Techniques Overview
2. Retail Sales Case Study in Dimensional Modeling
3. Procurement and Value Chain in Data Warehousing
4. Accounting Dimensional Modeling for General Ledger
5. Customer Relationship Management in DW/BI Systems
6. Financial Services: Supertypes and Subtypes in Banking Models
7. Transportation Case Study: Fact Tables and Granularity
8. Healthcare Industry Complex Dimensional Models
9. Electronic Commerce: Clickstream Web Data Dimensionality
10. Dimensional Modeling Process and Tasks
11. ETL Subsystems and Techniques
12. Common Myths about Dimensional Models

📖 1. Kimball Dimensional Modeling Techniques Overview

🔑 Notions clés & Définitions

• Dimension Table : Table de dimension qui fournit le contexte descriptif, contient de nombreux attributs et possède une clé primaire unique pour assurer l’intégrité référentielle.

📝 Points essentiels

• Fact tables express many-to-many relationships and have composite primary keys composed of foreign keys to dimension tables.
• Dimension tables provide descriptive context with many attributes and have a single primary key for referential integrity.

💡 À retenir