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 Data Management
Sales Cost and Profitability Overview
Sales Leads follow-up and Closure
Sales Behavior
Sales Channel Management System
Read more...
  Customer Relationship Management
Customer Segmentation Data Management
Customer Satisfaction and Retention- Overview
Customer Value and Profitability Tips and Actions
Customer-Centric product-service management
Customer Service and Support Overview
Read more...
  Human Resources & Leadership
What is Leadership?
Deliver Results
Act with Decisiveness
Leadership Development- Setting the Context
People become the way you treat them
Read more...
 
 
Business Performance & Planning
Business Objectives Drill Down
SWOT Analysis in Strategic blueprint Planning
strategy blueprint Rationalize Align and Publish
Strategic Business Plan
SWOT Assessment Report
Read more...
  Business Intelligence & Data Quality
Customer Data Augmentation and Enrichment
Individual Impact and Usage of BI
Data Warehouse IS-IT assessment
Data Standards is not democracy
Data Warehouse Requirement Report
Read more...
  IT Vendors & Tools Management
OLAP Performance Management
Scalability Technical Evaluation
Metadata Tool Change Management
Technical Architecture Evaluation
Data Quality through Data Integration Tools
Read more...