The Application & Prospect of Business Intelligence in Metallurgical Manufacturing Enterprises in China He Haoran, CTO for AP, 5 Shanghai Baosight Software Co., Ltd (China)
The Informization Situation at Metallurgical Manufacturing Enterprises in china The complete information system was built at metallurgical manufacturing enterprises in china, It can satisfy needs of operation and production in enterprises. After information system was built, enterprises will face a lot of new business problems How do we really can use a large number data from different kinds of application systems with different levels such as MES, ERP, CRM, SCM, for the further analysis? How do we can provide decision-making for enterprise? How do we realize technical innovation and administration innovation?
The application of Business Intelligence in metallurgical manufacturing enterprises Data Warehouse: Considering the size, complexity and technical level, Metallurgical manufacturing enterprise data warehouse system is a rare and advanced system. Such data warehouse system has become a hot topic in metallurgical manufacturing today. Quality Control and Analysis: In such area, many data mining techniques with high level technologies and characteristics have been widely applied for quality improvement, and can be extended to other manufacturing enterprises as well. SPC Statistic Process Control IPC Integrated Process Control : As basis of quality control, SPC and IPC systems with special characteristics are commonly used in metallurgical manufacturing enterprise.
Production Administration Based on Data Warehouse Data Information Knowledge
Production Administration Based on Data Warehouse Data Store Inquires & Reports Portal ERP / OLTP,, ETL, DW OLAP Miner DW Model Metadata Data Mart Business Modelling Final User
Production Administration Based on Data Warehouse The data warehouse system should help metallurgical manufacturing enterprises to organize every kind of data required by the enterprise analysts and to transfer all needed information to end users. ODS The data warehouse system includes ODS data stores, and perfectly integrated subject data stores according to the Quick Data Warehouse Building methodology.
Production Administration Based on Data Warehouse Assessment Requirement Review Design Construction Deployment Quick Data Warehouse Building
Production Administration Based on Data Warehouse Subject data mart enterprise statistics management data mart technique and quality management data mart sales and marketing management data mart production management data mart equipment management data mart finance and cost data mart energy management data mart
Integrated Process Control Systems Integrated Process ControlIPC / /
Integrated Process Control Systems IPC Integrated Process Control (KIV) (KOV) Know How IPC realizes effect control of KOV via analysis and monitor KIV, improves quality of production continually.
Integrated Process Control Systems Data Warehouse History Case Adjustment Match Function model
Production Information Successful cases of BI application in metallurgical manufacturing enterprises BI The Production Administration System 1700 / 1700 Static Reports 1600 1600 Dynamic Screen Automatically Issue Production Information
WEBSuccessful cases of BI application in metallurgical manufacturing enterprises BIThe Web Page of the Storage Presentation
Successful cases of BI application in metallurgical manufacturing enterprises BIIntelligently Recommend of the Steel Class
Successful cases of BI application in metallurgical manufacturing enterprises BIThe Quality Control of IPC
30 25 20 P e r c 15 e n t 10 5 0 Successful cases of BI application in metallurgical manufacturing enterprises 150 162 174 186 198 210 222 Speci f i cat i ons and Cur ve: Lower =180 Target =230 Normal (Mu=177. 85 Si gma=17. 645) TENSI LE_RE_N 40 35 30 P 25 e r c 20 e n t 15 10 5 0 BI 176 184 192 200 208 216 224 TENSI LE_RE_N Speci f i cat i ons and Cur ve: Lower =180 Target =230 Normal (Mu=206. 07 Si gma=9. 6836) Improvement the Bend Strength of the Steel
BISuccessful cases of BI application in metallurgical manufacturing enterprises The Forecast of the RDI in the Iron Ore
Successful cases of BI application in metallurgical manufacturing enterprises BIThe Diagnosis Expert System of the Steel Tube
Prospect of BI application System development base-on Data warehouse and data mining techniques. 6 quality control notion of 6 sigma together with process control and fuzzy control neural networks Develop the expert system KPI establish KPI system BI
The introduce of Integrated Quality View
The Framework of Integrated Quality View iqv Designer iqv Server
Main Features of Integrated Quality View XBar-S X-MR XBar-R PPNPCU XBarSR
Main Features of Integrated Quality View
Thank y u!