1 / 18

Enterprise Business Processes and Re porting ( IS 6214 )

Enterprise Business Processes and Re porting ( IS 6214 ). MBS MIMAS 2010 / 2011 11th November 2010. Fergal Carton Bu siness Information Systems. Last week. Basic flows of information and integration Transition from process map to ERD Entities are objects we need to collect data on

albert
Download Presentation

Enterprise Business Processes and Re porting ( IS 6214 )

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Enterprise Business Processes and Reporting(IS 6214) MBS MIMAS 2010 / 2011 11th November 2010 Fergal Carton Business Information Systems

  2. Last week • Basic flows of information and integration • Transition from process map to ERD • Entities are objects we need to collect data on • Tables in database are entities • Sales order process and Cucina • Process mapping is analysis, design later • Example of cash or account sales: process implication? • Good understanding of requirements leads to good design leads to good solution • Talk to drivers, customers, bread makers • Difference between corner shop, supermarket and home delivery • IT systems come at a time of change • Competitive advantage for Cucina with respect to CdeF • Automation required to be able to scale up for growth • Strengths / weaknesses of process mapping • Feedback from Excel skills survey

  3. This week • Normalisation of Northwind data • What is a sales order • Cucina sales order process • Process mapping assessment • Northwind Sales orders • Order header • Order detail

  4. Normalisation of QuantityPerUnit • Product as sold • Package • Quantity of packages in unit • Weight of package Quantity of packages in unit Package dimensions

  5. Normalisation: 1NF

  6. Normalisation using Excel

  7. Cucina – additional notes • Cucina can create advantage by being “trustworthy” • Trustworthy means being backed by accurate data • GRN is good practice, makes for accurate process • Think about discounts for customers • Orders will provide data for: • Goods received notes (no price) • Invoices (with price) • Sales reports

  8. Cucina process flows • Work in groups • Describe sales order process • Show movement of goods and information • Document assumptions about business • Show process from customer viewpoint • Why will customer order from you and not from Cuisine de France?

  9. Cucina Sales process Sales order & GRN Sales order Accounts Sales order processing Customer Goods Delivery (GRN) Invoice Payment

  10. Questions on assessment • 1 Dec, lab 1.111 at 9am • Bring blank paper, pencil, eraser, ruler • Have your own copy of case study, but no other material • Questions distributed on the day • All work marked with student # and name • 3 questions in the assessment • 1 process map • 2 questions on how that map would be used

  11. Preparation for assessment • Background research on the business sector involved • how do convenience stores currently manage their supplies of fresh bread? • A process map should ideally be able to differentiate between physical flows (goods) and virtual flows (information). Use two different colours / line types • It should also be a basis for discussing challenges in the business (for example, why are manual invoicing processes causing “heartache”?) • Research simple process mapping exercises

  12. Cucina process flows • Work in groups • Describe sales order process • Show movement of goods and information • Document assumptions about business • Show process from customer viewpoint • Why will customer order from you and not from Cuisine de France?

  13. Narrative analysis rules • Look for who is doing something = Function • Mention of a department, person, responsibility • Eg. Once shipped by the shipping department • Look for action of what is being done = Process • Use of verbs (becomes, generates, requests, transfers, …) • Eg. Sales rep activities result in customer leads • Look for nouns (not people / geography) = Data • Leads, quotes orders, … • Eg. the order generates an invoice

  14. Sample bread products

  15. Weaknesses of process mapping • Biased representation? • Difficult to meet all people involved • Dependent on accuracy of information given by participants • Holes in understanding -> poor process • Doesn’t take into account new processes • Interpreted differently • Consistency in analysis when using multiple analysts • Only maps repetitive processes? • What about manual work? • Find right level of abstraction • Only theoretical? • Complexity / overcomplication

  16. Northwind Data : Customers

  17. Northwind Data : Order headers

  18. Northwind Data : Order details

More Related