数据透视表在卷烟质量分析及可视化中的应用  

Application of PivotTable in Statistical Analysis and Visual Display of Cigarette Quality Data

作　　者：范胜兴 李旭 邓蓉[1,2] 张佳望 FAN Sheng-xing;LI Xu;DENG Rong;ZHANG Jia-wang(Chenzhou Cigarette Factory,China Tobacco Hunan Industrial Co.,Ltd.,Chenzhou 423000;Guangdong University of Technology,Guangzhou 510643)

机构地区：[1]湖南中烟工业有限责任公司郴州卷烟厂,郴州423000 [2]广东工业大学,广州510643

出　　处：《中国质量》2023年第5期124-128,共5页China Quality

摘　　要：为了实现对卷烟质量更多维、更立体的分析,充分挖掘和展示数据信息,采用数据透视表加Power BI插件,建立了多指标、多维度的卷烟质量数据统计分析及可视化展示平台。结果表明:运用数据透视表工具,可通过简单自助设计和便捷操作,实现对数据的多维度分析和展示,提升分析效率;Power Pivot工具通过DAX函数灵活建立度量值,能满足不同分析业务需求,扩展了数据透视表的应用范围。In order to carry out multi-dimensional and three-dimensional analysis of cigarette quality,fully mine and display data information,a multi index and multi-dimensional statistical analysis and visual display platform of cigarette quality data is established by using PivotTable and power Bi plug-in.The results show that:with the PivotTable tool,the multi-dimensional analysis and display of data can be realized through simple self-help design and convenient operation,and the analysis efficiency can be improved;the power pivot tool flexibly establishes metrics through DAX functions,which can meet different analysis business needs and expand the application range of PivotTables.

关 键 词：数据透视表 卷烟 质量数据 可视化 Power Pivot 

分 类 号：TP391.13[自动化与计算机技术—计算机应用技术] F426.8[自动化与计算机技术—计算机科学与技术] F273.2[经济管理—产业经济]