Home » DataWarehousing

DataWarehousing

In Simple terms, Data Warehouse is a database used for both reporting and analysis for an Organization. It is De-normalized form of the data stored in a Central location mainly used for Business Intelligence. The data stored in the warehouse is uploaded from the operational databases which are OLTP (Online Transactional Processing) in nature. The data may pass through an operational data store for additional operations before Data is used in Reporting.
Ralph Kimball is one of most famous author on the subject of data warehousing and business intelligence. He is widely regarded as one of the original architects of data warehousing and is known articles on data warehousing which are better understandable, fast, effective way of developing the Data Warehouses.
Kimball methodology for dimensional modeling has become the de facto standard in the area of building decision support Systems.
Developing a Data Warehouse normally includes following
• Operational Databases which are OLTP in nature
• ETL (Extraction, Transformation, and Loading)
• OLAP Data Warehouse(Online Analytical Processing)
• Multi-Dimensional Data Modelling or Building Cubes
• Reporting
Business Intelligence: refers to identifying, extracting and analyzing business data. BI provides current, historical predictive views of business operations. The most of the business intelligence technologies are done by reporting, OLAP, analytics, data mining, process mining, business performance management, benchmarking, text mining and predictive analytics.
Business intelligence aims to support better business decision-making. Thus a BI system can be called a decision support system (DSS). Bi is also used competitive intelligence with DSS.

Leave a Reply

Your email address will not be published. Required fields are marked *