In your opinion what are the advantages and disadvantages of

In your opinion, what are the advantages and disadvantages of using a data warehouse? What are the biggest challenges a company faces when trying to implement a data warehouse?

Solution

Answer:

Advantages of data warehouse:

-It improves the productivity by creating a integrated database of consistent,subject oriented and historical data.By integratig data from multiple systems and transforms the data into meaningful information which helps the managers to perform accurate and consistent analysis

-It helps to make cost effective decision making by reducing the overall cost of the product and reducing the number of channels

-It allows to share data and others can easily access the data

-Removes the information processing load and thus improves the efficiency of the process by saving much time

-It helps to standardize the data in one form and it is easy for analysing and reporting

Disadvantages:

-Warehouse is very costly to mainitain and it becomes a problem if it is not utilised properly

-The building of a warehouse may take some years so some organizations refuse to implement it

-Data warehouse requires large amount of data for processing and thus it is not suitable for small data

-The problems that occur in the source systems may be undetected for years and this may be a issue later

-It may miss some important processing of information

Biggest challenges in implementing a data warehouse:

-Implementing and preparing data for warehouse is complex and it requires specialized skills and technologies

-The maintainence cost is also high so large amount of investment should be made while trying to implement a data warehouse

-It is difficult to ensure the data quality.Data warehouse consumes information from different sources and there may be duplication of information so the data quality should be ensured

-Data warehouses should be designed to focus on performance.Designing is easier but the implementation of it to get the performance should be built at earleir stage itself

-Testing the data in warehouse is a real challenge and it requires much of time for testing