CrossEnterprise Data Analysis Methodologies Challenges Opportunities James Ding

  • Slides: 18
Download presentation
Cross-Enterprise Data Analysis Methodologies, Challenges, Opportunities James Ding Michael G. De. Groote School of

Cross-Enterprise Data Analysis Methodologies, Challenges, Opportunities James Ding Michael G. De. Groote School of Business Mc. Master University May 23, 2003 QPRC 2003 IBM TWRC

James Ding Cross-Enterprise Data Analysis Presentation Agenda n n n Enterprise Decision-Making After-ERP Solutions

James Ding Cross-Enterprise Data Analysis Presentation Agenda n n n Enterprise Decision-Making After-ERP Solutions Modeling and Analysis Tools n n Case Studies n n Adaptive System Design (ASD) Global Development Modeling (GDM) Differential Integration System (DIS) Quality-related Information Sharing under JIT Operation DW/DM Integration for Massive Data Processing Cross-Enterprise BPR for Supply Chain Design Concluding Remarks QPRC 2003 Slide 1 IBM TWRC

James Ding Cross-Enterprise Data Analysis Enterprise Decision-Making: Framework MANAGEMENT INFORMATION SYSTEM Strategy EIS Planning

James Ding Cross-Enterprise Data Analysis Enterprise Decision-Making: Framework MANAGEMENT INFORMATION SYSTEM Strategy EIS Planning DSS Operation ERP QPRC 2003 Slide 2 IBM TWRC

James Ding Cross-Enterprise Data Analysis Enterprise Decision-Making: Contents MANAGEMENT - Time Horizon - Life

James Ding Cross-Enterprise Data Analysis Enterprise Decision-Making: Contents MANAGEMENT - Time Horizon - Life Cycle Global Strategy Competitive Priorities Process, Quality, Technology Capacity, Location, Layout Strategy Planning SOP, MRP, CRP, DRP, IM/WM Transaction-based Decision Operation QPRC 2003 Slide 3 IBM TWRC

James Ding Cross-Enterprise Data Analysis After-ERP Solutions: Extension View Strategy (Organization) - Cross-Enterprise BPR

James Ding Cross-Enterprise Data Analysis After-ERP Solutions: Extension View Strategy (Organization) - Cross-Enterprise BPR - Out-Sourcing - Virtual Firm - Learning Organization Prior-ERP Solutions After-ERP Solutions Operation (Function) - SCM - CRM/SFA - APS - LIS - WMS ERP Solutions Technology - Data Warehouse/Data Mining - Intelligent Portal - Integration (BOB, Plug-in/Add-on) - E-Business QPRC 2003 Slide 4 IBM TWRC

James Ding Cross-Enterprise Data Analysis After-ERP Solutions: Value Chain View After-ERP Solutions Strategy Catalogue

James Ding Cross-Enterprise Data Analysis After-ERP Solutions: Value Chain View After-ERP Solutions Strategy Catalogue Management Planning Supply Chain Management APS Demand Management LIS ERP CRM Operation MES WMS Supplier Manufacturer Distributor Retailer SFA Customer Chopra (2001), Porter (1985) QPRC 2003 Slide 5 IBM TWRC

James Ding Cross-Enterprise Data Analysis After-ERP Solutions: Wave View System: ern Int tru Prior-ERP

James Ding Cross-Enterprise Data Analysis After-ERP Solutions: Wave View System: ern Int tru Prior-ERP Solutions - Mental Data - Relationship After-ERP Solutions Transactional Data: SRP ctu re ERP C/ SS Ma inf ra me Technology: et - Intelligent ERP - ERP II - XRP Analytic Inferential SAP AG (2003) QPRC 2003 Slide 6 IBM TWRC

James Ding Cross-Enterprise Data Analysis Modeling and Analysis: Framework MANAGEMENT MODELING TOOLS Strategy DIS

James Ding Cross-Enterprise Data Analysis Modeling and Analysis: Framework MANAGEMENT MODELING TOOLS Strategy DIS Planning GDM Operation ASD QPRC 2003 Slide 7 IBM TWRC

James Ding Cross-Enterprise Data Analysis Modeling and Analysis: ASD n Tools for decision-making under

James Ding Cross-Enterprise Data Analysis Modeling and Analysis: ASD n Tools for decision-making under complex systems n n n n Bayesian Statistics (Thomas Bayes, 1821) Information Theory (Shannon, 1948) Cybernetics (Wiener, 1950) System Dynamics (Forrester, 1961) Game Theory ………… Adaptive System Design (ASD) Approach n n Simulation is a useful tool for complex systems but can not explore values of latent variables Prediction with updated training data can lead to graduate exploration of values of latent variables QPRC 2003 Slide 8 IBM TWRC

James Ding Cross-Enterprise Data Analysis Modeling and Analysis: GDM n as the decision function

James Ding Cross-Enterprise Data Analysis Modeling and Analysis: GDM n as the decision function Global Development Modeling (GDM) is all about Optimization under Different Decision Spaces with Different Information Define A, B, C as decision spaces, under the decision space X. n Step I, Generalization: Derive the optimal function from A to C. n Step II, Specialization: Derive the optimal function from C to B. n A Managerial Interpretation and Pitfalls in the Implementation B A n Approach I, Strategic Solution C B A n A Approach II, Myopic Solution QPRC 2003 Slide 9 B C B IBM TWRC

James Ding Cross-Enterprise Data Analysis Modeling and Analysis: DIS Differential Integration System (DIS) is

James Ding Cross-Enterprise Data Analysis Modeling and Analysis: DIS Differential Integration System (DIS) is all about Effective Integration PI: Process Integration II: Information Integration OI: Organization Integration KI: Knowledge Integration BI: Business Integration SI: System Integration Strategy KI PI QPRC 2003 II Planning BI Operation SI Slide 10 OI IBM TWRC

James Ding Cross-Enterprise Data Analysis Modeling and Analysis: DIS is a Powerful Tool to

James Ding Cross-Enterprise Data Analysis Modeling and Analysis: DIS is a Powerful Tool to Achieve Strategic Fit under Complex Systems KI Strategic Fit BI SI Certainty Information Uncertainty Chopra (2001) QPRC 2003 Slide 11 IBM TWRC

James Ding Cross-Enterprise Data Analysis Case Study: Information Sharing Bullwhip Effect: Good Thing or

James Ding Cross-Enterprise Data Analysis Case Study: Information Sharing Bullwhip Effect: Good Thing or Bad Thing n n n Information Sharing in Practice Data Model Truncated Quality Data Censored Quality Data Complete Quality Data Mixed Distribution Model PH Regression Model Log-Linear Regression Model Integration Case Study: Intl. Pump Mfg. Company n n Pull for Implementation n Academic Research Focuses on Evaluations of Information Sharing Practitioners are in need of Methodologies to Guide Practices Push for Complete Data n Scrap-Processing for the Optimal Order Quantity under ATO Global JIT/SCM/TQM Strategy in Emerging Economy Area QPRC 2003 Slide 12 IBM TWRC

James Ding Cross-Enterprise Data Analysis Case Study: DW/DM Integration Utilization of the Accounting Transaction

James Ding Cross-Enterprise Data Analysis Case Study: DW/DM Integration Utilization of the Accounting Transaction Data for Standard Costing Classification Entry ERP F/S COA Algorithms Entry COA DW DM Consolidated Entry ERP COA Entry Actual Costing System Standard Costing System QPRC 2003 Slide 13 IBM TWRC

James Ding Cross-Enterprise Data Analysis Case Study: DW/DM Integration Automatic BOM Generation System with

James Ding Cross-Enterprise Data Analysis Case Study: DW/DM Integration Automatic BOM Generation System with Finite Experiment Design n Business Scenario n n n DW/DM Integration Solution n n Semi-mechanical, semi-chemical industry, Bill of Materials (Recipe) is decided by latent variables, eg. temperature, location, hardness, etc. Repeated experiments are needed for each individual order to decide the BOM, hence generate massive technical data in the computer. Utilization of the existing experimental data in the Data Warehouse to construct the function curve for each known product series Utilization of the existing function curves to construct the critical points of the finite experiment design for unknown product series Utilization of the DM algorithm to predict the function curve for unknown product series based on results from the finite experiment design What is the Advantage of DW for DM ? QPRC 2003 Slide 14 IBM TWRC

James Ding Cross-Enterprise Data Analysis Case Study: Cross-Enterprise BPR n Strategic Planning is Important

James Ding Cross-Enterprise Data Analysis Case Study: Cross-Enterprise BPR n Strategic Planning is Important for the Supply Chain Design, even before the ERP Implementation n SWOT Analysis helps to leverage Priorities of SCM during the ERP Implementation Cross-Enterprise Business Process Re-engineering (BPR) helps to smooth the move to SCM and E-Business after the ERP Implementation Comparison of Three Companies in Asia Company BASF Kodak GM QPRC 2003 ERP SCM Focus Integration R/2, R/3 Resource COSMOS System R/3 DC Network Sales/Mfg. R/3 Supply Network Supply/Mfg. Slide 15 IBM TWRC

James Ding Cross-Enterprise Data Analysis Concluding Remarks: Conclusion n Challenges in Cross-Enterprise Data Analysis

James Ding Cross-Enterprise Data Analysis Concluding Remarks: Conclusion n Challenges in Cross-Enterprise Data Analysis n n n Approaches for Cross-Enterprise Data Analysis n n Increasing Qualitative Data Increasing Uncertainty in Data Resource Involvement of Relationships Involvement of Mental Data and Latent Variables Utilization of the Dynamic/Adaptive Mechanism Utilization of the Power of Integration for the Existing Methods Utilization of the Differential Strategy for the Integration Challenges are just Opportunities n n New Tools to Quantify the Qualitative Data New Methodologies to Make Prediction under Latent Variables QPRC 2003 Slide 16 IBM TWRC

James Ding Cross-Enterprise Data Analysis Concluding Remarks: Further Information To request working papers or

James Ding Cross-Enterprise Data Analysis Concluding Remarks: Further Information To request working papers or further information, contact: James Ding MGD A 210, School of Business, Mc. Master University Hamilton, Ontario, Canada Tel. : (905) 525 -9140 X 26181 (Voice) Fax: (905) 521 -8995 E-Mail: dingt@mcmaster. ca QPRC 2003 Slide 17 IBM TWRC