Dimensional modeling-Data Mart + Fact Table Grain Matrix

Sales Management

Customer Relationship

Human Resources

Business Performance

BI & Data Quality

IT Tools & Vendors

Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline

Practice Tools Listing Page
Data Mart + Fact Table Grain Matrix
This is matrix is used in dimensional modeling to map data marts against the fact table grain for the data mart. Each Data Mart has a fact table grain. A fact table grain essentially states, the Type of data and the Level of detail of data to be captured in the data mart.

This page of 'Practice Tools' is linked to: Data Warehousing, Data Analysis/OLAP,

When is Data Mart + Fact Table Grain Matrix used?

Please refer to Marts + Fact Table Grain matrix in Data Warehouse Dimensional Modeling Process for the context of this template.

This template is used during the dimension modeling phase.

Why is it used?

This matrix lays down the fundamental principle behind a data mart, that is- to establish the granularity of data in Data Mart.

Download Attachment

DE- Data Mart + Fact Table Grain.xls

Quick Feedback- Was this information helpful ?

Relevant Links to this page

TOPIC - Data Mart Fact Table Grain Matrix in Data Warehouse Dimensional Model → Practice Tools → Data Mart + Fact Table Grain Matrix →

Relevant links to this page

Data Mart Fact Table Grain Matrix in DW
Data Mart + Fact Table Grain Matrix

Additional Channels

Principles & Rules

Key Performance Indicators

Most Popular Zones with list of pages crossing 25000 hits →→→

Maximising Sales Performance

Sales Campaign Infrastructure

Sales Compensation components

Sales facility Infrastructure

Sales Compensation administration

Customer Relationship Management

Customer Value and Profitability- BI

Customer Value and Profitability Data Management

Customer Knowledge and Organizational Knowledge

Drivers for Customer Satisfaction & Retention

Customer Value and Profitability-Overview

Human Resources & Leadership

Roles and Level based Competency Segregation

Business and Financial Acumen

Fitting leadership dimension in employee performance

What is Leadership?

Develop Self and Others

Business Performance & Planning

Individual goal Sheet

Strategic Vision and Mission

Review Session should stay focused

Strategic Planning leadership commitment

Strategic Business Plan

Business Intelligence & Data Quality

Data Warehouse Modeling and Analyze Phase

What is KDD- Data Mining?

Metadata Architecture Scenarios

Data Quality Program Analyze Phase

Metadata Architecture Design

IT Vendors & Tools Management

OLAP Sever Database Tuning

Business Intelligence Vendor Evaluation

Delivery Evaluation Performance warranty

Cascade standards & guidelines

Vendor Evaluation Conversion effort


	About Us \| Contact Us \| Privacy Policy \| Terms and Conditions \| Copyright \| Disclaimer \| Site Map