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 Objectives Clarity
Sales Behavior
Sales Leads Generation through advertising
Sales Leads Generation through Events
Sales Compensation System
Read more...
  Customer Relationship Management
Customer Knowledge and Organizational Knowledge
Customer Segmentation Data Management
Customer-Centric product-service management
Customer Satisfaction and Retention- Overview
Customer Value and Profitability Tips and Actions
Read more...
  Human Resources & Leadership
Customer Focus
Developing Leaders- Few Leadership Traits
Leadership Development- Setting the Context
Maximize the output first and then the potential
Fitting leadership dimension in employee performance
Read more...
 
 
Business Performance & Planning
Business Objectives Drill Down
Strategy Map Objectives Measures and Initiatives
Strategic Planning leadership commitment
SWOT Assessment Report
Strategic Planning Business Themes
Read more...
  Business Intelligence & Data Quality
Enterprise Intelligence' Evaluation- Data Pipelines
Don't fix before root cause Analysis
Derived Dimension Attributes Table
Data Quality Program DMA
Business process based data-marts
Read more...
  IT Vendors & Tools Management
OLAP Server Reliability
enterprise Reporting Server connectivity
OLAP Dimensional Model Tuning
Vendor Delivery Evaluation Training
Vendor Evaluation Matrix
Read more...