Data Warehouse Advantages

719 Words3 Pages
Benefits of data warehouse Data warehouse helps in solving and managing the data from various sources and transactional systems with more speedy and efficiently, and converts those data into practical information. Along with, data warehouse serves in processing of large and complex queries in a highly efficient manner. Here are some benefits of data warehouse after the successful implementation: I. Data warehouse helps in the Enhancement of Business Intelligence: Managers and executives will be able to make business decisions on the basis of the data gathered from various sources with more accuracy. Data warehouse stockpiles different facts and figures, and helps the decision makers to take better decision. Furthermore, data warehouse can…show more content…
Data Warehouse Provides Historical Intelligence: A various kind of historical data from many sources are gathered and stored in a data warehouse. And different time periods and trends are analyzed on the basis of these historical data which help in future prediction ("Benefits of Data Warehouses for Business.") . V. Data Warehouse Generates a High ROI( Return on Investment): In the business, implementation of a data warehouse and the business intelligence system help in combining information from various sources. Even data warehouse delivers a concise picture of a company’s marketing and financial aspects and ultimately boosts the finance of the company ("Benefits of Data Warehouses for Business.") . Pitfall of data warehouse There are some of the pitfalls of the data warehousing. Before storing the data in a data warehouse, it ought to be going through cleaning, loading and extracting processes which is time-consuming. Even it may have some compatibility issues. On the other hand, it takes a lot of time and effort in designing the data warehouse system. These are the following pitfalls that any company should work on avoiding…show more content…
There is a high chance of duplication and inconsistency. Inconsistency and the data of poor quality result to the loss of the very enthusiastic good data warehouse (“Disadvantages and Limitations of Data Warehouse”). -Lack of analytics understanding: The business users must be clear enough to analyze the required type of data, also should know about the analytical inputs that help in the improvement of the company's performance. Lacking awareness about the requirements and the importance of data warehouse lessen the capability of the business users(“Disadvantages and Limitations of Data Warehouse”). All in all, a data housing being subject-oriented, cohesive and time variant, it provides electrical centralization of all the data into one database. It provides integrated company wide information and helps in separating operational and informational systems in an organization. Though, it carries some disadvantages like lack of scalability and lack of data integrity, an organized use of data warehousing has a lot of benefits which helps the organization in proper management of the all kind of
Open Document