• Home
• System Analyze Method
  • An Imaginary System
  • System Analyze Q & A
  • Process Flow Diagram
  • Data Flow Diagram
• Network Architecture
  • Computer Network Model
  • Internet Technology
  • Client Server Architecture
• Data Architecture
  • Types of Database
  • Relational Database
  • Entity Relationship Model
  • Dimensional Data Model
• Data Modeling Tools
• Article Box
• About Me

• MS SQL Server 2008
• SSIS - MSDN Tutorials
• SSAS - MSDN Tutorials
• SSRS - MSDN Tutorials
• White Papers
• Q & A
• Webcasts

Dimensional Data Model

Data Warehouse Concept

• Data Warehouse
• Data Marts
• W.H.Inmon vs. Ralph Kimball
• OLTP vs. OLAP
• Data Mining
• Business Intelligence

Dimensional Data Model

Examine FACT

• FACT Table
• Types of Facts
• Types of Fact Tables
• Aggregate FACT
• Factless FACT

Determine Dimension

• Dimension Table
• Conformed Dimension
• Role-Playing Dimension
• Slowly Changing Dimension
• Junk & Degenerate Dimension

Data Hierarchy

Surrogate Key

Types of Schemas

• STAR Schema
• Snowflake Schema
• FACT Constellation Schema

Data Cleaning Process

Development Lifecycle of Data Warehouse

Sorry, we will update this webpage.

Download e-Book

Copyright © 2010 data-e-education.com. All rights reserved.

Terms of Use