By CA. Pankaj Deshpande B.Com, FCA, D.I.S.A. (ICA) Any business unit, A group of people, Using common resources To achieve a common goal, 3 Acquire Utilize Dispose off A common system.
Download ReportTranscript By CA. Pankaj Deshpande B.Com, FCA, D.I.S.A. (ICA) Any business unit, A group of people, Using common resources To achieve a common goal, 3 Acquire Utilize Dispose off A common system.
By CA. Pankaj Deshpande B.Com, FCA, D.I.S.A. (ICA)
1
Any business unit, A group of people, Using common resources To achieve a common goal, 2
3
Acquire Utilize Dispose off 4
A common system used by all and used for all types of resource planning and utilization. 5
Human Resource Production Material Management Production Planning Finance / Accounts Quality Control Logistics Sales & Distribution 6
Stores Out of Stock Raw Material Not in Stock Sales Dept.
Finance Production Planning H.R.
Shop Floor Vendor 7
Proper Communication and exchange of data between business units. 8
De-centralized Centralized 9
Data is maintained by each department separately. Department does not have access to data of other department. 10
Stores Out of Stock Sales Dept.
Loss of Revenue, Loss of Reputation New Vendor 11
Sales Dept.
Stores Finance Out of Stock Raw Material Information is stored separately by both departments Raw Material Not in Stock Production Planning H.R.
Production Floor Vendor 12
Increase in cost Increase in delay Increase in data Increase in dis-satisfaction 13
Stores Sales Dept.
Finance Central Database Production Planning Vendor H.R.
Shop Floor 14
E
fficiency
R
evenue
P
roductivity
15
Planning Materials Management Production Sales & Distribution Finance & Accounting Human Resource Research & Development 16
Combination of activities that takes some input and generates an output.
Creates value for customer.
May spread across different functions. 17
Service Department Customer Service Department Stores Department Purchase Department Stores Department 18
Sharing of common data. 19
Material requisition is sent by Production to Stores Department Stores department sends the requirement to Purchase Department Purchase Departments raises a purchase order on approved vendor.
Material is received by Stores Department Invoice is sent to Accounts Department Material is sent to Production Department Payment is made to the vendor by Accounts Department.
20
◦ Use of common master data. E.g. Name of stock items, Name of vendors, etc. ◦ Use of common transaction data. E.g. Sales figures used by Accounts and Marketing Department shall be from same data. 21
User Application Database Application 22
Business Intelligence Data Warehousing Online Analytical Processing Product Life Cycle Management Supply Chain Management Customer Relationship Management 23
Decision Making Tool Includes Skills, Processes, Technologies, Applications, Practices, etc. Facilitates quicker, better and correct decision making. 24
Identify and exploit areas of strength.
Address areas that are not performing well.
Identify areas of opportunity Know consequences of decisions (What if) Reward those who perform well Educate those who do not perform well Identify areas of business growth 25
Data Warehouse Business Intelligence BI Tools Applications 26
27
A system of separating operational and non operational data. Database Operational Data Non Operational Data 28
29
Operational Data – Recording of transactions Non Operational Data – Viewing / Analysis 30
Extract Transform Load 31
32
Data Warehouse Old Software to New Software Mergers & acquisitions Data from third parties 33
Definitions of data elements in the data warehouse/data sources Transformation rules Data about data Used by the end user to find and understand data in data warehouse 34
Data – Books Meta Data – Numbering system, Arranging System, Titling System 35
Fast and smooth working with operational data by reducing the load. Easy reporting and analysis of information. Facilitate Decision Support System 36
Cost of maintenance Latency as compared to operational data 37
Credit Card Analysis Insurance Fraud Analysis Phone Call Record Analysis Logistic Management 38
39
Extracting information from data and converting it into knowledge.
Data Information Knowledge 40
Mobile Call Rates Decision Call Duration Gender of caller City of caller Time of call Age of caller 41
Approach to quickly answer multi dimensional analytical queries. Part of Business Intelligence 42
What are the top five products sold from these three points to the customer between the age of 15 to 30 ? Point of Sales Call Centre Analysis of Sales Web Store 43
In case of web store, age is stored as date of birth. In case of point of sales – age is stored as a range, i.e. between 15 to 30. 44
Oracle Express Server Hyperion Solutions Essbase Cognos Business Objects MicroStrategy 45
Process of managing entire lifecycle of a product.
Integrates people, data, processes, business systems. 46
◦ Phase 1 : Conceive – Imagine, Specify, Plan, Innovate ◦ Phase 2 : Design – Describe, Define, Develop, Test, Analyze, Validate ◦ Phase 3 : Realize – Manufacture, Make, Build, Procure, Produce, Sell, Deliver ◦ Phase 4 : Service – Use, Operate, Maintain, Support, Sustain, Phase Out, Retire, Recycle, Dispose. 47
Process of planning, implementing, controlling the operations of supply chain. Includes movement and storage of raw materials, work in process inventory and finished goods from point of origin to point of consumption. Integrates supply and demand management within and across companies. 48
It starts with Customer/Customers Its about gaining and retaining customer. 49
CRM Operational CRM Analytical CRM Sales Intelligence CRM 50
Network as platform spanning all connected devices. Continuous updations.
Consumption and mixing of data from multiple sources, even from users. Rich user experience. 51
Desktop Application Browser Application 52
◦ ◦ A software where with its source code made available with a license in which the copy right holder provides the right to study, change and distribute software to any one for any purpose. 53
Open Bravo ( www.openbravo.com
) SQL Ledger ( www.sql-ledger.org
) xTuple Post Books ( www.xtuple.com
) Open Source (opensourceaccountingsoftware.com) ERP5 ( www.erp5.com
) Project Open ERP ( www.project-open.org
) 54