Institute for Building Intelligent and Performing Enterprises
 Building Intelligent and Performing Enterprises
Business Intelligence Tool Evaluation Kit 
  
Login or Register  
 
   DW Business Requirement Phase DW Dimensional Modeling Process  

Free Subscribed Trial Not Sub. BUY→ BI Tools Evaluation || Data Quality Kit || Consulting

BiPM ENCYCLOPEDIA  →   Business 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.
 

Free Subscribed Trial Not Sub. BUY→ BI Tools Evaluation || Data Quality Kit || Consulting

   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 → 

Tags    -     See all
 
 
Back
CONTENT ZONE
Data-Warehouse/Mart