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
Lead marketing Database Quality
Sales Material logistics and Distribution
Sales Leads Generation through Events
Sales Leads Management Concept
Sales productivity
Read more...
  Customer Relationship Management
Customer Value and Profitability- BI
Customer Segmentation approach
Customer Segmentation Data Management
What is Customer Segmentation?
Customer Value and Profitability Tips and Actions
Read more...
  Human Resources & Leadership
Feedback does not mean only negative feedback
What is Leadership?
Business and Financial Acumen
Develop Self and Others
Leadership Development- Setting the Context
Read more...
 
 
Business Performance & Planning
Financial Business Plan
Strategic Vision and Mission
Internal Info Assessment Report
Strategy Map to Strategic theme
Strategic Planning Business Themes
Read more...
  Business Intelligence & Data Quality
Data Warehouse Design Phase
Dimensional vs relational storage
Analyze well, but be decisive
Data Warehouse Infrastructure
Lead Generation KPI for campaign
Read more...
  IT Vendors & Tools Management
OLAP Server Reliability
Vendor Evaluation Matrix
Vendor Delivery Evaluation Governance
Vendor future plans Strategic fit
Vendor Delivery Support Model
Read more...