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 Warehouse Purpose and Objective- Why is Data Warehouse Needed?  

ENCYCLOPEDIA→   Enterprise Intelligence  →   -  Data-Warehouse/Mart  →   -  Data Warehouse Overview  → 

Data Warehouse definition- What is Data Warehouse?

Data Warehouse is repository of Data picked from Transaction systems, and filtered and transformed to make it available for data analysis reporting.

Data-Warehouse is a repository of Data, which can provide most OR all of the Data and information requirements of an enterprise. It means that it pulls data from all the production and other sources. Once the data is pulled onto an offline staging area, it is cleansed, transformed and loaded into a sanitized, uniform and well-organized manner so that you can run queries, reports and all kind of analysis on the data.

What is not Data Warehouse?

Data Warehouse typically does not provide the online information, as mostly the data Extraction and consolidation happens in the end of day batch-processing. For online, transaction based queries, the OLTP (Online Transaction Processing systems) is used.

Data Warehouse is not business intelligence OR OLAP. It is a repository of sanitized and consolidated data, which can be used for any purpose including Business Intelligence. The usage can be for transaction reports, data mining, Data Analysis, Statistical forecasting, valuation systems OR so on. Technically speaking, we can have a good data warehouse without good business intelligence (which is a combination of Data Analysis +Data Mining+ Performance Management Reporting..).

Data Warehouse vs. Operational Data Store (ODS)- They are different

Data Warehouse is an 'offline' integration of data, whereas Operational Data Store is an 'online' integration of data. ODS is used, when the data at a transaction (processing as well as querying) level is dispersed across various systems, and one needs to bring it together on online basis.

For example- Let us say that you want to have a single view of customer to be used by customer service, whereby they can also update the data in that single view online basis. However, the data on the customer (OPD Records, Hospitalization records, diagnostic records, pharmaceutical purchase records..) is lying in different databases. ODS could be a good choice.

The above-said concept of ODS is an ideal one. Another option for an Operational Data Store is to be used for online queries, but the information, which it provides is not real-time, but pertaining to last End of Day. For example you have a single customer view, but it does not include the transactions which the customer has done today. For this kind of need, some times even Data Warehouse repository can also used for this purpose.

Data Warehouse vs. Data Mart in Business Intelligence

Data Warehouse is at an enterprise level repository, which is having a combination of various data marts. Data Warehouse carries all the dimensions and measures required and it ensures the integrity of same dimensions and measures across different data marts. Data mart is a limited set of dimensions and measures used for specific business theme. They are populated out of the Data-Warehouse Data Sets.

Typically an organization's business intelligence agenda starts with few data marts, before maturing to a full-blown data warehouse. However, most of the design & development concept apply equally to a Data-mart.

Please refer De-Normalized Data Warehouse/Data Mart for detailed comparison between a Data Warehouse and Data Marts.

 

  Data Warehouse Purpose and Objective- Why is Data Warehouse Needed?  
 
 
All Topics in: "Data Warehouse Overview" Chapter
 Data Warehouse vs. Data Mart | Data Warehouse vs. ODS →  Data Warehouse purpose Objectives | Integration | consistency | quality →  Data Warehouse Components and Framework →  Data Warehouse Challenges and Issues | Data Warehouse vs. OLTP → 
 
 
More on Data Warehouse Overview
Purpose and Objective- Why Data Warehouse?
Data Warehouse Components and Framework
Data Warehouse Challenges and Issues
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 representation and experience
Enhancing Sales Channel productivity
Sales force Training and Development
Sales Compensation administration
Sales Objectives Clarity
Read more...
  Customer Relationship Management
Customer Knowledge and Organizational Knowledge
Customer Segmentation approach
Customer Value and Profitability-Overview
Customer Segmentation Actions
Supply Chain for Customer Service and Support
Read more...
  Human Resources & Leadership
Be straight and blunt, till you team gets used to it
Business and Financial Acumen
Setting Strategic Intent and Alignment
What is Leadership?
People become the way you treat them
Read more...
 
 
Business Performance & Planning
Internal Info Assessment Report
For important KPIs- Install first & Fix later
Review Session should stay focused
Individual goal Sheet
Strategic Vision and Mission
Read more...
  Business Intelligence & Data Quality
Data Map & Assessment Report
Manage Leads Database Centrally
Data Warehouse Project Readiness
Data Correction Change Request
Data Warehouse Benefits Usage
Read more...
  IT Vendors & Tools Management
Connectivity and Computing Support
Business Intelligence Vendor Evaluation
Metadata Tool Change Management
Data Profiling and Monitoring
Vendor Commercial Evaluation post Implementation
Read more...