基于Qlik Sense试制车间MES系统数据分析研究

Research on MES System Data Analysis of Prototyping Workshop Based on Qlik Sense

试制车间无线暗灯(Andon)系统数据可以间接反应车间实际运行状态。利用Qlik Sense对暗灯系统当前运行状态和历史运行状态的数据建立分析模型,其中当前运行状态分析主要是方便用户能直接按照楼层/项目/车间等维度快速获取项目的运行状态;历史运行状态分析侧重于对车间的瓶颈工位/单车制造周期/车辆交付情况等维度进行分析。最终实现了对数据标准化和可视化的分析,帮助工程师和管理层快速掌握车间运行信息,成为辅助业务改进的有效工具。

The data of wireless Andon system in the prototyping workshop can indirectly reflect the actual running state of the workshop.In this paper,Qlik Sense was used to establish the analysis model for the data of the current and historical operation states of the Andon system.The current operation state analysis mainly facilitates users to quickly obtain the operation state of the project according to the dimensions of floor/project/workshop;the analysis of historical operation status focuses on the analysis of such dimensions as bottleneck station,single vehicle manufacturing cycle and vehicle delivery in the workshop.Finally,it realized the analysis of data standardization and visualization,helped engineers and managers quickly master workshop operation information,and became an effective tool to assist business improvement.