关键词: 数据仓库, 联机分析处理, 谷歌地图, Web2.0

Abstract:

 In order to assist sales managers to take full advantage of the existing historical sales data, capture sensitive data rapidly and intuitively, and grasp the market quotation accurately and timely, this paper introduces a visualized analyzing system, which is based on the data warehouse as the analyzing platform, utilizes the geographical feature of sales data, combines the API（Application Program Interface） provided by Google Maps, and maps the analyzing operations of OLAP（Online Analytical Processing） to the interactive operations of the map. According to practical application cases, the system focuses on optimizing the data warehouse architecture, which lays a good foundation for system development. It is proved that the system improves the decision-making ability and efficiency of the sales management effectively, and may create more economic benefits for enterprises.

Key words: data warehouse, online analytical processing（OLAP）, Google Maps, Web2.0