Fast Moving Consumer Goods Industry Business Intelligence Applications Based On Sap Bw Research

With the development of information technology and informationdriven economy,the world's economies are becoming increasingly globalized.Networking technologies and information flow play important roles in this revolution.Businesses work with large amounts of data on a daily basis,among which only a small portion is utilized in relevant business analysis.Most businesses remain at the stage of "too much data,too little useful information".Given the increasingly competitive economic environment,the key to stay ahead in the competition is outstanding products and services, enabled by quick responses to various requirements and appropriate strategies.Business Intelligence(BI) provides technologies and products that rapidly extract valuable information from data warehouses,which is crucial for business analysis and making strategic decisions.By applying statistics,artificial intelligence and data mining techniques to the data warehouse,BI encompasses a whole suite of business solutions.Among these solutions,the Online Analysis Process(OLAP) is a main area of BI.It includes decision support,complicated analytical operations,and provides direct query responses.When combined with corporate decision management,a BI system plays a very important role in a decision making process. The dissertation focuses on the research frontier of BI,and the solutions applied to the FMCG industry.Most important,the implementation case of SAP BW,which is the world' s leading BI product,to multi-dimensional analysis of management data,and combining the OLAP display tools and the SAP SEM enterprise strategy management solution for extending the decision management information to high level managers in an FMCG company was involved. The main content includes the application solution designing and data loading technology of a FMCG business intelligence solution,in which the application of SAP BW in FMCG management analysis was detailed.The design includes the BI system requirement analysis, data model establishment and application(topic,particle,dimension, fact).The data loading technology includes data validation, clearness,transformation and loading.The FMCG SAP BW data display includes multi-dimensional analysis(slice,rotation,drill-up or drill-down) and multi-dimensional analysis and strategy decision specific to FMCG requirement,such as Profitability Analysis,Sales Analysis,Logistic Analysis,and Procurement Management Analysis. Finally,the thesis was concluded by an outlook of the BI application in FMCG industry.