关键词: 商业智能系统, 智能制造, 信息管理, 生产报表, 车间管理

Abstract: Aiming at the design and deployment of a business intelligence system for the traditional manufacturing industry，this paper designs a business intelligence system based on Python language and its related libraries，combined with XLSX file as the form of database management. This system can automatically analyze and provide static and dynamic reports at different production and time levels， and implement the monitoring of some key indicators. Its simplicity and flexibility satisfy the requirements of the analysis and management of the production data of the traditional manufacturing industry. The tracking statistics of the actual application of the business intelligence system show the analysis time often linearly with the number of output reports. A parallel processing platform can be built by a network cloud，which can overcome the time and geographical constraints.

Key words: business intelligence system, smart manufacturing, information management, production report, workshop management