Application Of Data Warehouse In Business Intelligence Of Retail Industry

Business Intelligence (BI) is a comprehensive use of data warehouse (DW), onlineanalysis processing (OLAP) and data mining (DM) technology, which is a new technologyused to process and analyze data and enables us to turn data into information and knowledge.Currently, business intelligence has been familiar to more and more business managers,including decision makers of telecommunications, finance, retail, insurance and otherindustries. Business intelligence becomes the top priority of these information constructionsand the most important information system, following enterprise resource planning (ERP).Currently, the informationization of the retail trade is continuously deepening, enterprisegenerated a lot of data in the daily course of business, and these data contain a lot ofimportant business information. How to effectively use this valuable resource to helpcompanies increase profits and market share is the most urgent desire of every retailenterprise. In this paper, starting from the data warehouse technology, based on the analysisof business intelligence technology system, we proposed a solution of building a retailbusiness intelligence system based on the data warehouse technology. The use of datawarehouse in establishing business intelligence system, makes the management of retailcompanies more scientific and efficient, and provides an important basis for the enterprise tomake the right decisions in a timely manner, as well as to develop the right marketingstrategy.Firstly, the development status of data warehouse and business intelligence areintroduced, and the importance of data warehouse in business intelligence is analyzed;secondly, the basis of the data warehouse and the main techniques in retail businessintelligence and technology system are introduced, mainly about the basic concepts andapplications of ETL, data warehousing, online analysis processing and data miningtechniques; then we achieve the entire retail industry business intelligence systemcomprehensively according to the business intelligence system design, including systemrequirements analysis and the selection of system development platform, and establish adesign of the data warehouse table structure and ETL design by analyzing the characteristicsof the retail industry,and then through OLAP and business intelligence reporting tools wepropose a perfect front-end presentation of data, including the applications of data mining, by analyzing basic customer information, digging out the close relationship of thecustomer’s card type and the yearly income, marital status, number of children etc.; Finally,this paper is summarized, indicating the retail business intelligence system constructed inthis paper can improve the information systems of a enterprise and the capacity of decisionanalysis, and pointing out that as the evolving of business needs and information technology,data warehouse will be used more and more widely.