Manufacturing Supply Chain Analytics: Information Integration Techniques for Increased Business Effectiveness (Part 2)

Supply Chain Analysis, from demand forecasting to actual production, requires the integration of information across multiple platforms and systems. This is a case study presenting the approach and results from an effort to deploy a highly integrated Supply Chain Data Mart in a highly distributed and fragmented environment. The presenter will review the business situation that lead to the chartering of this effort, the critical business objectives, the critical design considerations, the rationale for using “fact-dimensions” for the data design, the data movement process for data integrity using the standard ETL tool, and the implementation techniques for high performance. The presentation also includes a description of the “Event Management System;” a supporting capability to enable the collection, notification and analysis of events. Events are usually caused by defective information detected early on in the data movement process. The system provides immediate (e-mail, fax) notification to the affected parties of events. Also, provides custom and ad-hoc reports using the standard BI tool for current events and for event trend analysis. This in-depth session provides the attendees with advanced analysis and design techniques that are practical and can be readily applied to their own situations.