Bi scm presentation - Using Business Intelligence to Optimize your Supply Chain

50 %
50 %
Information about Bi scm presentation - Using Business Intelligence to Optimize your...
Data & Analytics

Published on October 12, 2014

Author: VispiMunshi

Source: slideshare.net

Description

Using Business Intelligence to Optimize your Supply Chain
Vispi Munshi
CEO - ERP India
http://www.erp-india.org
vmunshi@erp-india.org

1. Using Business Intelligence to Optimize your Supply Chain Vispi Munshi Founder - ERP India vmunshi@erp-india.com http://www.erp-india.com Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 1

2. Using Business Intelligence to Optimize your Supply Chain Today’s Agenda - Introduction - What is Supply Chain Management (SCM) - Supply Chain Functions - What is Business Intelligence - Data Analytics - Applying BI to the Supply Chain - Supply Chain Intelligence System - Measuring Supply Chain performance - Supply Chain Scorecard - Future, Conclusion, Q&A Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 2

3. Using Business Intelligence to Optimize your Supply Chain Ground Rules - Please turn mobile ringer to SILENT MODE - If you have to take a call, please leave the room and then start talking - Questions can be asked any time - Before asking question, raise your hand - No talking with each other - Disagreements allowed, but no disrespect - Timeframe awareness - Lets learn from each other and increase our knowledge Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 3

4. Using Business Intelligence to Optimize your Supply Chain Introductions - Full Name - Where do you work (Company/Consultant/Student etc) - Your job designation and responsibilities - Any BI tool you have already used? - Any Supply Chain experience? - Expectation from this workshop Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 4

5. Using Business Intelligence to Optimize your Supply Chain What is Supply Chain Management Supply chain management is the integration of the activities that procure materials and services, transform them into intermediate goods and final products, and deliver them through a distribution system. Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 5

6. Using Business Intelligence to Optimize your Supply Chain Supply Chain Overview Warehousing Transportation Factory Transportation Warehousing Transportation Customers Vendors/plants/ports Transportation Information flows Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 6

7. Using Business Intelligence to Optimize your Supply Chain Focus Company Suppliers Supplier’s suppliers Customers Customers/ End users Acquire Convert Distribute Product and information flow Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 7

8. Using Business Intelligence to Optimize your Supply Chain Key SCM Functions - Loose partnering with Suppliers, Suppliers of Supplier, Contract Manufacturers, Wholesalers, Distributors, Dealers, Logistics Partners, Retailers, Service Providers - http://www.youtube.com/watch?v=wLNdDSYqhNw - Demand forecasting - Propagation to suppliers (Demand Management) - Lead time estimation and propagation towards manufacturer (Order Fulfillment) - Efficiency in Inventory Management (Warehousing) - Automated orders and payments (pricing determined in advance, EDI) - Supplier Relationship Management - Logistics Management - Manufacturing coordination - Information sharing across companies in the chain Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 8

9. Using Business Intelligence to Optimize your Supply Chain What is business intelligence? Business Intelligence is a term generally used to identify a class of Information System applications useful for supporting operational, tactical and strategic decision making of a organization. BI deals with producing (and presenting) Accurate, Relevant and Timely (ART) INFORMATION from integrated data. Not Accurate: Users loose faith in system Not Relevant: Users ignore the system Not Timely: Users find alternatives to the system Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 9

10. Using Business Intelligence to Optimize your Supply Chain BI System Anatomy BACK-END Data Collection and Integration Tools Forecasting, Mining Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 10 ERP Ecomm CRM Files …. Data Mart PRESENTATION FRONT-END Analytics, Visualization, Dashboards, … DISTRIBUTION Alerts, Email, Mobile, Intranet ….

11. Using Business Intelligence to Optimize your Supply Chain Backend BI Tools: Used for collection, integration and consolidation of data from various sources. Intermediate BI Tools: Allows users to create forecasts and identify trends (data mining) from the data. Frontend BI Tools: Provides users with a interactive and intuitive interface to view the information generated. Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 11

12. Using Business Intelligence to Optimize your Supply Chain Data Analytics (New Age Decision Support Systems) - Based on multi-dimensional view of data (cubes) - Pivot Table demo - Features for drilling in and across data - Slicing and dicing of data - Graphics capabilities - Similar to Excel - Exception reporting - Data Analyst would use such tools and create Reports/Analysis/Graphs (objects) - These objects would be supplied to Executives using Dashboards, Alerts etc. Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 12

13. Using Business Intelligence to Optimize your Supply Chain Multi-dimensional Data Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 13

14. Using Business Intelligence to Optimize your Supply Chain Data Analytics Tools in Market High-end: Business Objects, OBIEE, Microstrategy, … Open Source: http://en.wikipedia.org/wiki/Business_intelligence_tools Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 14

15. Using Business Intelligence to Optimize your Supply Chain Dashboards and Alerts - Dashboards are collection of reports/analysis/graphs - Alerts are specific events that the system finds and sends a email/sms etc to the executive - Key Performance Indicators (KPI’s) can be set and linked to alerts - Linking across objects provides executive with ability to go through the generated information in a very intuitive manner Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 15

16. Using Business Intelligence to Optimize your Supply Chain Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 16

17. Using Business Intelligence to Optimize your Supply Chain Data Mining - Also known as KDD (Knowledge Discovery in Databases) - Involves use of large data sets - Involves uses of Statistical Methods, Database Systems and Artificial Intelligence - The objective is to discover patterns or knowledge from existing data - Involves four step process: Data Preparation (classification), Hypothesis (user provided guidance), Discovery (of knowledge) and Validation (of discovered knowledge against hypothesis) - High end tools: SPSS, SAS, … - Open Source: http://en.wikipedia.org/wiki/Data_mining Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 17

18. Using Business Intelligence to Optimize your Supply Chain Using BI in the Supply Chain - Demand Forecasting - Inbound dashboards and alerts (Supply bottlenecks) - Outbound dashboards and alerts (Distribution efficiency) - Supplier Analysis using Data Analytics - Purchase Order Performance Analysis - Warehouse Utilization Analysis - Inventory Turns Analysis - Distribution Channel Analysis - Simulation of Change Impact (Pricing, Batching Orders, Warehouse location) - Alerting Partners (suppliers, contract manufacturers, transporters, distributors) Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 18

19. Using Business Intelligence to Optimize your Supply Chain Supply Chain Intelligence System BACK-END Data Collection and Integration Tools SCM WMS Partner Systems …. Forecasting, Mining SCI Mart PRESENTATION FRONT-END Analytics, Visualization, Dashboards, … EXTRANET ACCESS To PARTNERS (SCI Portal) ALERTS by email and mobile to SC Managers And Partners Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 19

20. Using Business Intelligence to Optimize your Supply Chain Measuring Supply Chain Performance - Key factors: Speed, Quality and Cost - Suppliers and Contract Manufacturers: On Time Delivery, % Returns, % Compliance, Lead Time Consistency, Comparison with Market Price - Transporters: On Time Delivery, % Damage, Transport Cost per Unit - Distributors: Ordering Consistency, Information Sharing, Complaints from Dealers/Customers - Inventory: % Automation, Optimizing Turns (Velocity), Shelf Age, Holding Cost - Warehouse: % Accident/Damage, Picking Time, % Utilization of space, Manpower cost - Total: Summary for Speed, Quality and Cost, Trust and Transparency Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 20

21. Using Business Intelligence to Optimize your Supply Chain Supply Chain KPI Scorecard Speed Quality Cost Suppliers Inbound Transport Warehouse Outbound Transport Distributors Total Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 21

22. Using Business Intelligence to Optimize your Supply Chain Conclusion Q&A Thank You vmunshi@erp-india.com 98250 11489 Proprietary and Confidential © ERP India – Vispi Munshi – erp-india.org 22

Add a comment

Related presentations

Research/ Dissertation on “How online selling has changed the marketing perspectiv...

مشروع قانون يتعلق بالقضاء على كل أشكال العنف ضد المرأة

Remedial geo

Remedial geo

November 6, 2014

nnn

This brief examines 2013 demographic data recently released by the U.S. Census Bur...

Introduction into Big data

Introduction into Big data

October 22, 2014

This presentation shows you the advantages and the importance of Big Data in these...

Info om powerpoint

Info om powerpoint

November 10, 2014

Powerpoint

Related pages

Supply Chain Business Intelligence (SCM BI) | Supply Chain ...

Demand Solutions offers supply chain business intelligence ... business intelligence (SCM BI) to provide you ... are using another supply chain ...
Read more

Business Intelligence in the Supply Chain - Inbound Logistics

The definition of business intelligence (BI) depends on who you ... and supply chain sector. Business intelligence ... using BI to improve supply chain ...
Read more

Optimize Supply Chain | LinkedIn

View 132 Optimize Supply Chain posts, presentations, ... Establishing the Optimal Supply Chain | Business Transformation ... Optimize your supply chain.
Read more

Supply-Chain Analytics - Analytics, Business Intelligence ...

Supply-Chain Analytics: Beyond ERP & SCM. ... Even companies that report using supply-chain ... able to determine the best way to optimize your production ...
Read more

Business Intelligence: On the Road with BI

TECHNOLOGY: Business Intelligence . On the Road with BI By Mark Rittman . Oracle Business Intelligence Mobile gives your iOS device the business. In ...
Read more

Supply Chain Management - SCM | Omni-Channel Solutions | SAP

Watch this short demo to see how our supply chain management solutions can help you respond to demand in the most profitable way possible.
Read more

What is Business Intelligence (BI)? | AP Institute

What is Business Intelligence? ... Improving delivery and supply chain ... Performance indicators are essential tools which will tell you if your business ...
Read more

Supply Chain Intelligence | Manhattan Associates

Business intelligence for end-to-end supply chain operations. ... Our Supply Chain Intelligence tool provides at-a-glance insight into your supply chain ...
Read more