tailieunhanh - Data Mining Concepts and Techniques phần 3

Có thể các nhà phân tích kinh doanh đạt được từ việc có một kho dữ liệu "Đầu tiên, có một kho dữ liệu có thể cung cấp một lợi thế cạnh tranh bằng cách trình bày thông tin có liên quan để đo lường hiệu suất và điều chỉnh quan trọng để giành chiến thắng hơn đối thủ cạnh tranh. | 128 Chapter 3 Data Warehouse and OLAP Technology An Overview Steps for the Design and Construction of Data Warehouses This subsection presents a business analysis framework for data warehouse design. The basic steps involved in the design process are also described. The Design of a Data Warehouse A Business Analysis Framework What can business analysts gain from having a data warehouse First having a data warehouse may provide a competitive advantage by presenting relevant information from which to measure performance and make critical adjustments in order to help win over competitors. Second a data warehouse can enhance business productivity because it is able to quickly and efficiently gather information that accurately describes the organization. Third a data warehouse facilitates customer relationship management because it provides a consistent view of customers and items across all lines of business all departments and all markets. Finally a data warehouse may bring about cost reduction by tracking trends patterns and exceptions over long periods in a consistent and reliable manner. To design an effective data warehouse we need to understand and analyze business needs and construct a business analysis framework. The construction of a large and complex information system can be viewed as the construction of a large and complex building for which the owner architect and builder have different views. These views are combined to form a complex framework that represents the top-down business-driven or owner s perspective as well as the bottom-up builder-driven or implementor s view of the information system. Four different views regarding the design of a data warehouse must be considered the top-down view the data source view the data warehouse view and the business query view. The top-down view allows the selection of the relevant information necessary for the data warehouse. This information matches the current and future business needs. The data source .