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
Practice Tools Listing Page

Dimensional Model Completion Checklist

This is used to validate if the dimensional modelling phase is completed. Dimensional Modeling has to be reviewed extensively by business (just like a data model in transactional system).
 
This page of 'Practice Tools' is linked to:  Data Warehousing, Data Analysis/OLAP,

When is Dimensional Model Completion Checklist used?

This is the tracking and sign-off sheet for completion of Data Warehouse Dimensional Modeling Process phase.

Why is it used?

Just like any other completion checklist, this template is used to ensure that nothing important is missed out.

What it contains?

This template contains the tasks as well as some core principles which should be followed to make Foundation Dimensions and Facts.


Download Attachment

DE- Dimension Model Completion Checklist.xls  

Quick Feedback- Was this information helpful ?
Relevant Links to this page
TOPIC - Data Warehouse Dimensional Model Components Concept → Dimensional Model Schemas- Star, Snow-Flake and Constellation → Foundation & Conformed Dimensions and Facts in Data Warehouse Dimensional Model → Slowly Changing Dimensions SCD in Dimensional Modeling → Data Mart Business Theme Matrix in Data Warehouse Dimensional Model → Data Mart Dimension Fact table Matrix in Data Warehouse Dimensional Model → Data Mart Fact Table Grain Matrix in Data Warehouse Dimensional Model → Derived Facts table in Data Warehouse Dimensional Model → Derived Dimension Attributes Table → Dimensional Attributes+ Facts + Source System Matrix → Practice Tools → Data Mart + Fact Table Grain Matrix → 
 
Back
 
Relevant links to this page
DW Dimensional Model Components Concept
Schemas- Star, Snow-Flake and Constellation
Foundation & Conformed Dimensions and Facts
Slowly Changing Dimensions SCD
Data Mart Business Theme Matrix in DW
Data Mart Dimension Fact table Matrix in DW
Data Mart Fact Table Grain Matrix in DW
Derived Facts table in DW Dimensional Model
Derived Dimension Attributes Table
Dimensional Attributes+ Facts + Source System
Data Mart + Fact Table Grain Matrix
Additional Channels
Principles & Rules
Free Templates
Glossary
Key Performance Indicators

Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Sales Compensation Data Management
Sales Campaign Management
Sales Campaign SWOT analysis
Sales Leads Classification and prioritization
Sales Channel Retention, Support and Engagement
Read more...
  Customer Relationship Management
Customer Value and Profitability-Overview
What is Customer Segmentation?
Customer Value and Profitability Tips and Actions
Customer-Centric product-service management
Customer Knowledge and Organizational Knowledge
Read more...
  Human Resources & Leadership
Customer Focus
Competencies Definitions
Deliver Results
Be straight and blunt, till you team gets used to it
Lead Change
Read more...
 
 
Business Performance & Planning
Creating Strategy Blueprint
Scorecards need manual finish
strategy blueprint Rationalize Align and Publish
Performance Review should have no surprises
Strategy Map Objectives Measures and Initiatives
Read more...
  Business Intelligence & Data Quality
Beware of Data Federation
Do not separate parent and child data
ODS- Operational Data Store
MDM-CDI Hub
Metadata Repository Transformation Design
Read more...
  IT Vendors & Tools Management
Collaboration and Administration Support
Scalability Technical Evaluation
Vendor Commercial Evaluation- Licensing IPR
Metadata Repository sharing
Commercial & Contractual Matrix
Read more...