Building Making It Happen
Establishing Making-it-Happen as ‘Formal & Measurable’ Business Discipline
  Sign-in         Register
    
   DW Business Requirement Phase DW Dimensional Modeling Process  

Execution-MiH ENCYCLOPEDIA  →   Enterprise Intelligence →  SECTION - Data-Warehouse/Mart → 

CHAPTER -  DW Dimensional Modeling Concepts

Dimensional modeling is essentially a logical modeling of business requirements. It is different from data modeling. Lets look at what's dimensional modeling, why is it different?, why is it needed to be different?, what are special situations and how do we deal with them?.


Topics
Data Warehouse Dimensional Model Components Concept   
Dimensional model is equivalent of logical data design of Data Warehouse, and much more. It is more simplistic in design and suits the purpose of a data warehouse.
 
Dimensional Model Schemas- Star, Snow-Flake and Constellation   
Dimensional model can be organized in star-schema or snow-flaked schema.
 
Dimensional Modeling vs. Relational Modeling   
Dimensional modeling is different from the OLTP normalized modeling to enable analysis and querying through massive and unpredicted queries. Something which is a relational model is ill-equipped to handle.
 
Foundation & Conformed Dimensions and Facts in Data Warehouse Dimensional Model   
Data Warehouse is a repository which feeds data marts, and other down stream systems. It has to be designed to have global or re-usable set of dimensions and measures.
 
Slowly Changing Dimensions SCD in Dimensional Modeling   
Dimensional model has to address some complex situations liked slowly changing dimensions.
 

   DW Business Requirement Phase DW Dimensional Modeling Process  

All Chapters in "Data-Warehouse/Mart." Section
 Data Warehouse Overview →  DW Project Scoping and Planning →  DW Business Requirement Phase →  DW Dimensional Modeling Concepts →  DW Dimensional Modeling Process →  DW Design & Architecture →  DW Testing and Implementation →  DW Maintenance Enhancement →  Data Warehouse Project Plan- Work Break-Down Structure → 

 
 
Back
CONTENT ZONE
Data-Warehouse/Mart

Featured Pages
Data Quality Program Approach
Data Quality Gap Impact Assessment
Data Warehouse Change and Enhancement
Business Intelligence Vendor Evaluation

Make 'Executable' Strategy
Maximize Results
Maximize People
Manage Execution

Featured Pages
BI need not wait for legacy conversion
Customer Segmentation Analytics and BI
Store granular data in data warehouse
Enterprise Intelligence' Evaluation- Data Pipelines