Data Warehousing Concepts with Examples

A data warehouse is the concept of data extracted from operational systems and made available as historical snapshots for ad-hoc queries and scheduled reporting. Data warehouse help in determining the effectiveness of business processes, create policy, forecast trends, analyze the market and much more . Below snapshot  gives simple view how data warehouse data is prepared and provide the reporting capabilities to Business analysts.


Data warehouse example

 See also : I found a good article on the difference Difference between Data warehouse data and Operational Data 

Key Features :

A common way of introducing data warehousing is to refer to the characteristics of a data warehouse as set forth by William Inmon:

• Subject Oriented:
• Integrated
• Nonvolatile
• Time Variant :

For more  detailed article on this data warehouse concept , do visit here.  I hope you like this small introductory article on data warehouse concept .