Data Warehousing

Data Warehousing

 

In every organisation data warehousing supposed to use in decision making process. It integrated, subject oriented, time-variant and non-volatile collection of data.

The object of the Data Warehousing is to help the people to understand. The high level data of the implementation of the successful DWH project. The experience on this projects. To help the people in business intelligence professional. In both the vendors and the clients.

Components of the Data warehousing

Components of the Data warehousing can be classified into six major parts. They are

Tools

The business intelligence tools selections and the DWH  selection teams. These tools covered in

  • Reporting
  • OLAP
  • ETL (Extraction, Transformation, and Loading)
  • Metadata
  • Database, Hardware

Steps: In this selection the DWH project contains the typical milestones. To production roll-out and beyond from the gathering requirements, query optimisation. DWH observations are also available in the fields.

Business intelligence

In data warehousing is one of the important part of the business intelligence. In this step can explain the relationship. Between the DWH and the business intelligence. And also discuss about the business intelligence.

 Trends

In this section can explain the lists based on trends and the data warehousing field:

  • Industry consolidation
  • Lack of collaboration with data mining efforts
  • How to measure success
  • Quick implementation time
  • Recipes for data warehousing project failure

The DWH Quality Management

The DWH quality management delivers the quality solutions in end to end process. It enable to data profiling and data quality. In the implementing the data warehousing is the important process. In data collection establish the generates mapping. It is keep the check on the storage repository and the metadata. These based on the business rules and the ethics.

There are four primary phases on the data warehousing life cycle. They are

  • Assessment Quality
  •  Design Quality
  • Transformation Quality
  • Monitoring Quality

Trends

The DWH design can begin. After the terms and tools made in personnel selection. In data warehousing life cycle there are many typical steps involved. They are

  • Need Gathering
  • Physical Environment Setup
  • Data Modeling
  • ETL
  • OLAP Cube Design
  • Front End Development
  • Report Development
  • Performance Tuning
  • Query Optimization
  • Quality Assurance
  • Rolling out to Production
  • Production Maintenance
  • Incremental Enhancements

If we have to design DWH then the above steps are very important. The above steps are typical to DWH designing phase. And it has so many different sections.

Take Description:

During the particular DWH designing phase. This section explains what type of typical needs can accomplished.

Time Requirements:

Estimating some time the particular DWH tasks takes place.

Deliverable’ s:

At the end of the typical tasks in DWH one or more documents produced. The particular task results explained in the steps. They are very important to communicate with the consultants. These results are communicating with the clients and the consultants.

Possible Pitfalls:

This is depends on the out of the watch. Some of them clear, and some of them are not real in data warehousing. Or all them are Real.