基于数据仓库的销售数据可视化分析系统

Sales Data Visualization Analyzing System Based on DW

为了辅助销售管理者充分利用已有的历史销售数据,快速直观地捕获敏感数据,及时准确地把握市场行情,研究了以数据仓库为分析平台,根据销售数据具有的地理特征,结合Google提供的Google Maps API(Application Program Interface),将OLAP(Online Analytical Processing)的分析操作映射到地图具有的交互操作上的可视化分析系统。并基于实际案例着重设计并优化了数据仓库架构,为系统应用开发奠定了良好的基础。实践证明,系统有效提高了销售管理部门的统筹决策的效率及能力,为企业创造了更大的经济效益。

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.