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

Business Themes+ Data Mart matrix

A data mart can support multiple business themes. Ideally you will not have a business theme being addresses by a combination of data-mart. This is because it may not be possible to integrate these data marts and you may end-up with split picture around the theme. Once you have done the business theme and data mart mapping, you can decide on the scope of the data mart.
 
This page of 'Practice Tools' is linked to:  Data Warehousing, Data Analysis/OLAP,

When is Business Themes+ Data Mart matrix used?

Please refer to Data-Marts + Business themes matrix in Data Warehouse Dimensional Modeling Process for the context of the template

This template is the first one to be used in the dimensional modeling phase. First one has to lay down the big picture on what all data marts will be needed to fulfill the needs of the business themes as mentioned in Data Warehouse Business Requirement Report Business Requirement Report .

Why is it used?

As mentioned in the concepts of dimension modeling, the data mart is the building block of a data warehouse. A Data Warehouse is the combination multiple star-Schemas with each schema representing a data mart (mostly).

What it contains?

it contains a simple two dimensional mapping with list of data marts on one side and list of business themes on other axis.


Download Attachment

DF- Business Themes+ Data Mart matrix.xls  

Quick Feedback- Was this information helpful ?
Relevant Links to this page
Practice Tools → Dimensional Modeling- Dimensions & Attribute listing → Practice Tools → Facts and Derived Facts Table → Practice Tools → Business Themes+ Data Mart matrix → Practice Tools → Data Mart + Dimensions +facts → 
 
Back
 
Relevant links to this page
Dimensional Modeling- Dimensions & Attribute listing
Facts and Derived Facts Table
Business Themes+ Data Mart matrix
Data Mart + Dimensions +facts
Additional Channels
Principles & Rules
Free Templates
Glossary
Key Performance Indicators

Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Sales Channel Management Overview
Sales Channel Partner Acquisition
Sales product Mix Profitability
Sales Campaign Infrastructure
Sales representation and experience
Read more...
  Customer Relationship Management
Customer Value and Profitability Tips and Actions
What is Customer Segmentation?
Customer Segmentation Data Management
Drivers for Customer Satisfaction & Retention
Customer Segmentation approach
Read more...
  Human Resources & Leadership
Fostering Innovation
Business and Financial Acumen
People become the way you treat them
Customer Focus
Developing Leaders- Few Leadership Traits
Read more...
 
 
Business Performance & Planning
Strategy Map to Strategic theme
Internal Info Assessment Report
Dashboard Health Checklist
Strategic Planning leadership commitment
Strategy Map Objectives Measures and Initiatives
Read more...
  Business Intelligence & Data Quality
Rationalization of Information
Knowledge Discovery in Databases Methodology
Data Quality Program Initiation
Dimensional Model Schemas- Star, Snow-Flake
ODS- Operational Data Store
Read more...
  IT Vendors & Tools Management
Vendor Delivery Evaluation Training
Data Quality through Data Integration Tools
Single point vendor needs to be cost-effective
Vendor Delivery Evaluation Governance
Data Cleansing and Augmentation
Read more...