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
  Data Mart Dimension Fact table Matrix in Data Warehouse Dimensional Model  

ENCYCLOPEDIA→   Enterprise Intelligence  →   -  Data-Warehouse/Mart  →   -  DW Dimensional Modeling Process  → 

Data Mart Business Theme Matrix in Data Warehouse Dimensional Model

The start point of business themes and the end delivery of data marts have to be linked to confirm that we have not missed any business themes.

Before we proceed, lets understand on what do we mean by Data-Mart here. Data-Mart here is one single Data Warehouse schema [a combination of interlinked fact table(s) and dimension table(s)] in the overall Data Warehouse design. Each Data Warehouse can have many such schemas. Please refer dimensional model and Schemas of a dimensional model to get a better picture. These Data-Marts (OR schemas) could be then residing in any layer of Data Warehouse OR Data-Mart OR both, depending upon the Data Warehouse Architecture Scenarios you will use.

Pick-up all the business themes, requirements and specifications documents, and create a matrix placing the business themes on one axis and the data marts on the other. As you go through this page, you may open up Execution-MiHPractice Tool Business Themes+ Data Mart matrix on the side to understand how this looks like.

The matrix will contain:

  • All the Data Warehouse business themes (within and out of phase I and II).
  • All the Data Marts titles.
  • The Descriptive objectives of the Data Marts.
  • Phase of the Data Mart.

Making a list of Data Marts

There is no single fixed way of defining the set of Data Marts. One of the ways to list a Data Mart can be taken as a three cornered view.

View 1 – With the list of Measures, make sets of measures (facts). A Mart should be a centered around a set of Measures. For example:

  • No. of sales units
  • Value of sales units
  • Cost of sales Units

    This Data Mart can be called a Sales Analysis Data Mart.

View 2 – Even with the given set of Facts, a business theme can drive a separate set of Data Marts. For example, the same set of above matrix could drive two different data marts. Each of these Data Marts will have the above set of facts and also the facts specific to that Mart. For example-

  • The Sales Data Mart having additional facts – Commission Value, Average Shelf time
  • The Production Data Mart having additional Data facts – Order to Delivery time, Productivity.

View 3 – Understanding of the source Data.

In the initial stages, it is advised to create data marts having minimum number of data sources. You may like to design each data-mart around a limited set of systems.

TIP- Typically a Data Mart can have multiple business themes, but ideally you should not have a business theme split across multiple data marts. This is because typically you will have one data-mart equivalent to one cube (refer OLAP). Your BI tool may not allow you to run a query across two cubes at the same time. Even if it does, the configuration is little complex.

REFER Execution-MiHPractice Tool Business Themes+ Data Mart matrix

 

  Data Mart Dimension Fact table Matrix in Data Warehouse Dimensional Model  
 
 
Relevant Links to this page
Practice Tools → Data Warehouse Project Initiation- Business Themes Listing → Practice Tools → Dimensional Model Completion Checklist → Practice Tools → Business Themes+ Data Mart matrix → 

Was this page helpful?
 
 
More on DW Dimensional Model Process
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
BUY BI & Data Management Vendors & Tools Evaluation Kit
Read more...
BUY largest on-line Data-Quality Management Kit
Read more...
Additional Channels
Principles & Rules
Free Templates
Glossary
Key Performance Indicators



Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Sales Leads Management Concept
Sales Channel SWOT
Sales Compensation Structure Decision
Enhancing Sales Channel productivity
Sales Synergies
Read more...
  Customer Relationship Management
Customer Satisfaction and Retention- Overview
Customer Satisfaction & Retention- Data Management
Customer Value and Profitability Data Management
Customer Segmentation approach
Customer Service and Support Overview
Read more...
  Human Resources & Leadership
Leadership Development- Setting the Context
Feedback does not mean only negative feedback
Maximize the output first and then the potential
Act with Decisiveness
Developing Leaders- Few Leadership Traits
Read more...
 
 
Business Performance & Planning
Financial Business Plan
Dashboard Health Checklist
Strategic Business Plan
Never design performance systems for specific KPI
Review Session should stay focused
Read more...
  Business Intelligence & Data Quality
BI Competency Centre- Operate Phase
Data Warehouse Infrastructure Considerations
Invest in Naming strategy
Data Management Stake-holding Matrix
Aggregation Queries on SCD
Read more...
  IT Vendors & Tools Management
BI Tool Vendor Evaluation
Data Integration Metadata Management
Cascade standards & guidelines
OLAP Server write backs
Vendor Commercial Evaluation- pre Implementation
Read more...