Sales Management Customer Relationship Human Resources Business Performance BI & Data Quality IT Tools & Vendors

Sign-in   Register
Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline
   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
 
More on Data-Warehouse/Mart
Data Warehouse Overview
DW Project Scoping & Planning
DW Business Requirement Phase
DW Dimensional Model Process
DW Design & Architecture
DW Testing & Implementation
DW Maintenance Enhancement
Data Warehouse Project Plan- WBS
Additional Channels
Principles & Rules
Free Templates
Glossary
Key Performance Indicators



Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Sales product Mix Profitability
Sales force density
Sales Process Management
Sales Channel Mix Profitability
Enhancing Sales Channel productivity
Read more...
  Customer Relationship Management
Customer Segmentation Actions
Customer Value and Profitability-Overview
Customer Segmentation Parameters
Customer Segmentation approach
Exit barriers for Customer Retention
Read more...
  Human Resources & Leadership
Business and Financial Acumen
Roles and Level based Competency Segregation
Develop Self and Others
Strategic Business Plan
Maximize the output first and then the potential
Read more...
 
 
Business Performance & Planning
For important KPIs- Install first & Fix later
Internal Info Assessment Report
Strategic Planning Business Themes
Strategic Business Plan
SWOT Analysis in Strategic blueprint Planning
Read more...
  Business Intelligence & Data Quality
Business Metadata for IT
OLAP what if Analysis
Data Warehouse Business Requirements
Dimensional Model- Dimension listing
Data Quality Policy
Read more...
  IT Vendors & Tools Management
Data explosion OLAP Server
Metadata Tool Architecture Features
Connectivity and Computing Support
Vendor Quality Evaluation
Metadata Repository sharing
Read more...