| 基于ETL-KETTLE的贵州卷烟营销大数据分析及可视化 |
| |
| 引用本文： | 郭丹,樊红.基于ETL-KETTLE的贵州卷烟营销大数据分析及可视化[J].计算机系统应用,2017,26(1):74-80. |
| |
| 作者姓名： | 郭丹 樊红 |
| |
| 作者单位： | 武汉大学 测绘遥感信息工程国家重点实验室, 武汉 430079,武汉大学 测绘遥感信息工程国家重点实验室, 武汉 430079 |
| |
| 基金项目： | 国家自然科学基金(41471323)；中国烟草公司贵州省公司科学研究与技术开发项目(合同号201407) |
| |
| 摘 要： | 为了实现对贵州卷烟销售大数据的分析及可视化,基于开源数据分析工具KETTLE构建了ETL过程模型,对现有的卷烟销售基础大数据进行抽取、转换、加载,形成分析型数据,快速高效地实现了数据集成.经过ETL处理的集成数据,为卷烟销售大数据可视化系统及进一步的数据挖掘、决策支持提供了数据基础.同时,采用GIS平台构建和可视化技术,设计并实现了卷烟销售大数据可视化分析系统,为企业的数据分析和决策支持提供了数据展示及分析平台.
|
| 关 键 词： | ETL KETTLE 数据集成 GIS 可视化 |
| 收稿时间： | 2016/4/12 0:00:00 |
| 修稿时间： | 2016/6/21 0:00:00 |
Analysis and Visualization of Cigarette Sales Data Based on ETL-KETTLE |
| |
| GUO Dan and FAN Hong.Analysis and Visualization of Cigarette Sales Data Based on ETL-KETTLE[J].Computer Systems& Applications,2017,26(1):74-80. |
| |
| Authors: | GUO Dan and FAN Hong |
| |
| Affiliation: | State Key Laboratory of Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, Wuhan 430079, China and State Key Laboratory of Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, Wuhan 430079, China |
| |
| Abstract: | In this paper, based on the KETTLE which is an open source data analysis tool, an ETL process model is constructed to extract, transform and load the existing basic big data of the cigarette sales.Through the ETL model, the basic data is converted to analytical data, and the data integration can be implemented quickly and efficiently.In this paper, based on the integrated data, combining with the platform construction and visualization of GIS, the visualization and analysis system of the cigarette sales data is designed and implemented to provide data display and analysis platform for the enterprise data analysis and policy support. |
| |
| Keywords: | ETL KETTLE data integration GIS visualization |
|
| 点击此处可从《计算机系统应用》浏览原始摘要信息 |
|
点击此处可从《计算机系统应用》下载全文 |
|
