摘要
以柔性自动化生产线日志数据管理为实例。介绍了日志数据及应用在生产线上的环节,演示了利用批处理进行日志数据获取与合并的编写方法,阐述了Power Query、Power Pivot、Power View的使用技巧与用途,总结了利用日志数据完成柔性自动化生产线设备数据管理后取得的效果。
Taking the log data management of flexible automatic production line as an example,this paper introduces log data and what link it is applied in the production line.This paper demonstrates the preparation method of acquiring and merging log data by batch processing,expounds the use skills and uses of power query,power pivot and power view,and summarizes the results obtained after using log data to complete the data management of flexible automatic production line equipment.
出处
《工业控制计算机》
2022年第8期132-133,共2页
Industrial Control Computer
关键词
柔性自动化生产线
数据获取
数据清洗
数据分析
数据可视化
flexible automatic
roduction line
data acquisition
data cleaning
data analysis
data perspective