DIAMOND VIDEO RENTALSBusiness Analysis- Assessment Task 1 LAST UPDATED: March 2015, Version No. 3 Page 1 of 12 T. +61 2 9283 4388 | E. info@wic.nsw.edu.au Lower Ground, 101 Sussex St., Sydney NSW 2000 Australia | www.wic.nsw.edu.au ABN: 19 080 559 600 | CRICOS CODE: 01856K | RTO: 90501 Assessment 1 Role Play Instructions: For this assessment students are allowed to work in small teams (Maximum number of 3 students) to gather information. However the all reports and documents must be prepared independently. For this reason it is expected that each of these documents will be written in their own words. The presentation may be prepared together however all team members should contribute in some way when it is delivered. Duration: Assessment will be handed out on week 1 and should be completed /submitted by week 4. Business Analysis- Assessment Task 1 LAST UPDATED: March 2015, Version No. 3 Page 2 of 12 T. +61 2 9283 4388 | E. info@wic.nsw.edu.au Lower Ground, 101 Sussex St., Sydney NSW 2000 Australia | www.wic.nsw.edu.au ABN: 19 080 559 600 | CRICOS CODE: 01856K | RTO: 90501 Your tasks: Task A: Business Requirements Documents (BRD) Read the scenario in Appendix A and document the business requirements for Diamond Video Rentals in a Business Requirements Document (BRD) format. Your BRD report is to summarise your findings and is required to be outlined as specified below: 1. Cover page identifying all team members 2. Version Control and Signoff 3. Table of Contents 4. Executive Summary 5. Introduction 6. Company Description 7. Problem Definition which includes: a. Business Need b. List of Stakeholders and their roles c. Scope d. Business Objectives e. Available Resources f. Constraints g. List of Assumptions 8. Specific Requirements including: a. Functional Requirements b. Non Functional Requirements 9. Conclusion 10. Glossary You are also required to create the forms and documents mentioned in the business case scenario as requested by Mary Adams the Project Manager. These forms and documents are to be supplied within the BRD report under the most appropriate section headings specified above (1-10). If the requested document is not relevant to any of the section headings specified, can be just attached as an additional document to the BRD report. The additional documents and forms requested by Mary Adams the Project Manager, Diamond Video Rentals are: ? Organisation chart for Diamond Video Rentals with brief description of area functions identified with chart ? Context diagram of the business functions ? Draft problem statement ? Memo to Mary re Standards for documentation and records management ? Summary report of the two techniques that you have chosen for information gathering, stating your reasons, and evaluate the advantages and disadvantages of each ? List of questions to ask the client in the form of a questionnaire ? Questionnaire that covers cover customer satisfaction levels, service requirements, availability ? Draft of Diagram 0/Context Diagram of Diamond Video Rentals ? Data dictionary ? Initial draft for a requirements document (you dont need to submit this document. Just show your draft report to your trainer to cover this task) Business Analysis- Assessment Task 1 LAST UPDATED: March 2015, Version No. 3 Page 3 of 12 T. +61 2 9283 4388 | E. info@wic.nsw.edu.au Lower Ground, 101 Sussex St., Sydney NSW 2000 Australia | www.wic.nsw.edu.au ABN: 19 080 559 600 | CRICOS CODE: 01856K | RTO: 90501 Task B Feasibility Study For this task you need to identify 2 possible solutions the meet the needs identified in the BRD. Each possible solution needs to be fully described and justified with respect to the business requirements. You should also identify the recommended solution. Summarise your findings under the following structure and add as a separate document with BRD: 1. Business Requirements Summary 2. Proposed Solutions (2) which includes: 3. Detail of each proposed solution and how it meets the Business Requirements 4. Advantages and disadvantages of the proposed solution 5. Recommended Solution including reasons for recommendation with respect to Business Requirements Task C Service Level Agreement (SLA) For this task assume that your recommended solution has been adopted by by Mary Adams the Project Manager, Diamond Video Rentals. You have now been asked to provide support for the solution. Your next task will involve documenting the SLA for this support. You will of course need to interview the client representative (your Trainer and minutes of interview is also available in the appendix A) to determine the requirements for support. Prepare your SLA so that it includes the following information: 1. Summary of Support Requirements 2. SLA Service Description which includes: a. Duration of the contract b. Areas of support c. Methods and Levels of support d. Hours of support e. Definition of Priority Levels f. Response times according to Priority g. Communications methods h. Costing 3. SLA Implementation which includes: a. Warrantees & Exclusions b. Customer Responsibilities c. Method for Service Level Monitoring (including a schedule of review meeting dates for the SLA) d. Process for handling complaints or concerns e. Process for changing the contents of SLA Task D Presentation Prepare at least 12 presentation slides to summarise your finding from the documents you created in Task A, B and C and submit to your trainer. Remember that you are pitching this idea to your client (trainer and class mates) and some salesmanship is required. This presentation should include the following: ? Identification of team and team members ? Summary of business requirements Business Analysis- Assessment Task 1 LAST UPDATED: March 2015, Version No. 3 Page 4 of 12 T. +61 2 9283 4388 | E. info@wic.nsw.edu.au Lower Ground, 101 Sussex St., Sydney NSW 2000 Australia | www.wic.nsw.edu.au ABN: 19 080 559 600 | CRICOS CODE: 01856K | RTO: 90501 ? Description of each proposed solution ? Recommended solution ? SLA service description ? Method for SLA monitoring and reviewing (changing) the contents You will be required to provide a handout for your trainer to accompany your presentation Also create an evaluation/feedback form (1 page) with sign-off option to gain consensus form your Trainer on the proposed solution and SLA that you have presented. Task E Response and resolution performance measured against the SLA Assume your SLA was accepted by Diamond Video Rentals and they have been getting the services from IT Solutions since then. Now, Diamond Video Rentals collected reports showing performance and measured this against the SLA as follows. Performance Vs. SLA Performance vs SLA Target Achieved Priority 1 response Priority 1 resolution Priority 2 response Priority 2 resolution Priority 3 response Priority 3 resolution Priority 4 response Priority 4 resolution Priority 5 response Priority 5 resolution 100% < 5 mins 100% ASAP 100% < 20 mins 100% < 1.5 hours 100% < 2 hours 100% < 5 hours 100% < 4 hours 100% < 8 hours 100% < 6 hours 100% < 24 hours 96% < 5 mins 99% ASAP 98% < 20 mins 100% < 1.5 hours 100% < 2 hour 100% < 5 hours 97% < 4 hours 95% < 8 hours 96% < 6 hours 90% < 24 hours List the priorities which were not achieved and indicate why you think they were not met? Appendix A IT Solutions Business Case Scenario IT Solutions is a software company. Recently it commenced work on a project for a video rental store. You have been employed as a systems analyst by the software company, IT Solutions. This company provides software solutions to small businesses that do not have their own information technology personnel. It has systems analysts, programmers and testers, as well as the necessary support staffs. The company has received a request from John Vandrine, owner of Diamond Video Rentals, a video store in a large rural town, for a report into the business need or opportunity in computerising some or all of the day Business Analysis- Assessment Task 1 LAST UPDATED: March 2015, Version No. 3 Page 5 of 12 T. +61 2 9283 4388 | E. info@wic.nsw.edu.au Lower Ground, 101 Sussex St., Sydney NSW 2000 Australia | www.wic.nsw.edu.au ABN: 19 080 559 600 | CRICOS CODE: 01856K | RTO: 90501 to day business of the video store with the aim of making it more efficient and providing better customer service. You have been assigned to work as part of the team undertaking this project. You will be working with Mary Adams who will be providing you with advice to assist you in meeting the clients business needs. Initial meetings have been held with the client and the following is the Initial Project Brief for Diamond Video Rentals and the minutes of an interview conducted by Mary Adams with John Vandrine. Initial Project Brief for Diamond Video Rentals Introduction Diamond Video Rentals is a small business that has been operating in a large country town for five years. Its main business is to rent videos to its members. There are approximately 5000 members and 10,000 videos in stock. In the early years the business grew steadily however, in the last year, growth in members and rentals has not occurred. Business Details The business is owned and managed by John Vandrine. There are six permanent staff and up to six casual staff. Of the permanent staff, Deb Papadopoulos and Dawn Schultz are the most experienced and supervise the running of the store, one on each shift. Danny Jones, Paul Trang, Mae Willis and Terry De Santo are also permanents and at least two of them are rostered on each shift. Ted Sloan is responsible for the accounting and purchasing functions of the business and Mary Johnson handles preparation of the rosters and payroll. The accounting function is currently computerised, using an accounting software package. All other functions are still performed manually. John Vandrine also manages the business. This involves planning and decision making regarding the business, and resolving problems and issues that arise, such as customer complaints that cannot be resolved by the staff. Deb and Dawn work mainly at the counter, handling rentals, bookings and overdues. Danny, Terry, Paul and Mae spend much of their time shelving videos and any other duties as directed. The casuals perform both counter work and reshelving tasks. Problem The population of the town has grown steadily in the last two years and another video store opened in the town six months ago, which, whilst not as old or as big as Diamond Video Rentals, has grown rapidly in the short period. John Vandrine is concerned that the business has not grown in line with the towns growth and patronage seems to be static or even in a slight decline. Also, customer complaints seem to be increasing. With the advent of the new video store, John is keen to increase the competitiveness of his business. John has asked IT Solutions to perform an investigation into the benefits of computerising the day-to-day business of the video store. Minutes of interview Diamond Video Rentals Date: Monday 12th June 201X, 2.00pm Present: John Vandrine, owner of Diamond Video Rentals Mary Adams, Systems Analyst, ITSolutions John believes that his business is not growing in line with expectations, based on the growth of the town. His measures of growth include: ? Profit down about 2% last year on the previous year. Mainly due to a decline in revenue. Expenses remained pretty much the same. Business Analysis- Assessment Task 1 LAST UPDATED: March 2015, Version No. 3 Page 6 of 12 T. +61 2 9283 4388 | E. info@wic.nsw.edu.au Lower Ground, 101 Sussex St., Sydney NSW 2000 Australia | www.wic.nsw.edu.au ABN: 19 080 559 600 | CRICOS CODE: 01856K | RTO: 90501 ? Number of members. Perception that the number of members has declined. Difficult to tell as members do not let you know they are leaving, they just do not come back. Not attracting new members as well as in the past. ? Number of rentals. Once again, difficult to determine, but feeling is that this is static or declining slightly. John attributes the lack of growth or possible decline to competition from the new video store in town. Some customer complaints include: ? the lengthy time it takes to answer queries, such as whether a particular video is available ? inaccurate information, such as indicating a video is available when it is not ? customers booking videos and not being notified when they are available ? the time it takes to process a video rental Two other areas of particular concern are: ? Overdues slow in following up overdue videos. Should be done daily, but sometimes more pressing tasks take precedence. A charge is levied on overdues, but not retrieving the videos as soon as they are due means that someone else misses out, and this causes member dissatisfaction. ? Decisions affecting future directions, marketing strategy etc. are made based on gut feeling rather than solid fact. The data about such things is in the card files, but is too cumbersome to extract. The accounting system is computerised a popular software package is currently used. Both the computer and the package are several years old but continue to work effectively. There are no current problems with the payroll or purchasing operations. Much of the staffs time is spent keeping the card records of members and videos up to date. Based on recent observation it is estimated that the equivalent of one third of a staff members time is spent recording this information. Using an average salary of $30,000 per year, approximately $10,000 can be allocated against record keeping. A maximum budget of $30,000 is available for this project, and a solution is required within a couple of months if possible. Advice and requests from Mary Adams Project Manager for you: 1. Identifying the business environment I originally assigned Mark West to do the initial investigation into this request. Unfortunately, Mark is now unable to continue with this project and you have been assigned to this role. Since Mark West has already completed the initial brief for the Diamond Video Rentals project, your first task will be to read Marks brief carefully so that you have a thorough understanding of the background to this request. To ensure that you understand the structure of the business I would like you to create an organisation chart for the company. There are software packages available for creating organisation charts, as well as facilities in common office applications. The chart should be incorporated into a word processing document for future use. For each of the areas identified in the organisation chart you will need to briefly describe the functions. 2. Defining and documenting business problems Now that you have an understanding of the existing business environment I would like you to define the scope of this particular business problem. Business Analysis- Assessment Task 1 LAST UPDATED: March 2015, Version No. 3 Page 7 of 12 T. +61 2 9283 4388 | E. info@wic.nsw.edu.au Lower Ground, 101 Sussex St., Sydney NSW 2000 Australia | www.wic.nsw.edu.au ABN: 19 080 559 600 | CRICOS CODE: 01856K | RTO: 90501 To define the scope of the project and its boundaries I would like you to create a context diagram of the business functions to be investigated. With this document and the information in Marks initial brief you should then be able to produce a draft problem statement which we will submit to John Vandrine for approval. Since John does not have any current standards for documentation and records management for his business he would like us to recommend a reference that could be used for this purpose. You can probably go to the Standards Australia website (www.standards.org.au) and research the standards and references that would be appropriate. Put your findings in a memo to me, including title, price and main topics covered. 3. Appropriate information gathering techniques The Preliminary Investigation report that you prepared for the Diamond Video Rentals project was approved by John Vandrine last week. He has authorised us to proceed to the next stage of the project, which is to now gather the detailed requirements of the proposed new system. As you are aware, there are several different techniques we could use to collect this information. I would like you to do some research into the options and identify two techniques that would be suitable for use at Diamond Video Rentals. Write a summary of the two techniques that you have chosen, stating your reasons, and evaluate the advantages and disadvantages of each. Put this into a report form for me. Whatever technique(s) we choose, I am sure that we will need to hold a one-to-one interview with John Vandrine and so I would like you to prepare a list of questions to ask John at the interview. It is important to keep in mind what information you are trying to obtain from John, and so you should also identify what you see as the objectives of this interview. 4. Gathering and recording client requirements data We are now in a position to carry out the information gathering process. To ensure that the solution we recommend to Diamond Video Rentals meets the industry best practice, a good starting point would be to survey some existing customers of video rental stores to see what facilities are important to them. I would therefore like you to create a questionnaire that could be used for this purpose. Make sure that you cover customer satisfaction levels, service requirements, availability etc. You should then get your questionnaire reviewed by a colleague to make sure that it is appropriate and unambiguous, and incorporate any feedback into the document. Once you are happy with it you should distribute it to current video store customers for completion. You will then have to collect the questionnaires and document the results. 5. Analyse and document requirements Now that you have recorded all of the information gathered during the investigation process, you will need to put it together into a formal document to present to John Vandrine (owner of Diamond Video Rentals). To do this you will need to create the lower level data flow diagrams to enable us to fully analyse the requirements. You should also include a data dictionary recording all of the data elements that you have identified in the system. Put it all together in a word processed document in an appropriate format. Based on this analysis you should create an initial draft for a Requirements Document which we can review together. Since we do not have a standard template for a requirements document I would like you to research Business Analysis- Assessment Task 1 LAST UPDATED: March 2015, Version No. 3 Page 8 of 12 T. +61 2 9283 4388 | E. info@wic.nsw.edu.au Lower Ground, 101 Sussex St., Sydney NSW 2000 Australia | www.wic.nsw.edu.au ABN: 19 080 559 600 | CRICOS CODE: 01856K | RTO: 90501 a suitable template and use it to prepare your draft. Make sure that you identify where the template came from. Business Analysis- Assessment Task 1 LAST UPDATED: March 2015, Version No. 3 Page 9 of 12 T. +61 2 9283 4388 | E. info@wic.nsw.edu.au Lower Ground, 101 Sussex St., Sydney NSW 2000 Australia | www.wic.nsw.edu.au ABN: 19 080 559 600 | CRICOS CODE: 01856K | RTO: 90501 Diamond Video Rentals Minutes of JAD Session Date: Monday 20th March 200X, 2.00pm Present: John Vandrine, owner of Diamond Video Rentals Deb Papadopoulos, Dawn Schultz, Ted Sloan Systems Analyst, ITSolutions Purpose ? Review the scope of the system as outlined in the interview with John Vandrine. ? Identify more detail of the data and processes required. ? Get agreement from the team that we are proposing a solution which will work well for all aspects of the business and that the staff are comfortable with using. ? Identify requirements raised outside the scope as components to be developed later if cost justified, ensuring that the design allows for easy later additions. Output Functions to be developed Data requirements Create a customer database Customer no, name, phone, address Create a video database Video no., name, classification, storage location, availability for rental or sale Customer/Video link Customer no., video no., date due, date booked Overdue video report Date due > current date, video no., title, customer name Reserved video report Date booked, video no., title, customer name Mail out to customers of advertised specials Customer name, address, labels, special information sheet Automatic links to accounting system May be a later enhancement to the system? Review available titles over the internet May be a later enhancement to the system? Reserve titles over the internet May be a later enhancement to the system? Low activity customers report Customer no., date last rented, number of videos rented Slow moving videos report Video no., date last rented, date purchased, number of days rented Reshelving list for returned videos Video no., title, storage location Access cards for new customers Customer Card swipe customer recognition and title link Customer no. from card reader, title from bar code reader. Allow for linking multiple titles in one transaction Business Analysis- Assessment Task 1 LAST UPDATED: March 2015, Version No. 3 Page 10 of 12 T. +61 2 9283 4388 | E. info@wic.nsw.edu.au Lower Ground, 101 Sussex St., Sydney NSW 2000 Australia | www.wic.nsw.edu.au ABN: 19 080 559 600 | CRICOS CODE: 01856K | RTO: 90501 The last two requirements may be outside the initial scope but the staff feel that speeding up the customer interaction will solve some customer satisfaction issues not previously raised by the owner. Actions ? John will review the initial budget and possible timing of implementation. ? IT Solutions will review the capacity of the current hardware to accommodate the required functionality of the proposed system. ? IT Solutions will draw up sample screen and report layouts for further review with the staff. Business Analysis- Assessment Task 1 LAST UPDATED: March 2015, Version No. 3 Page 11 of 12 T. +61 2 9283 4388 | E. info@wic.nsw.edu.au Lower Ground, 101 Sussex St., Sydney NSW 2000 Australia | www.wic.nsw.edu.au ABN: 19 080 559 600 | CRICOS CODE: 01856K | RTO: 90501 Appendix B Useful references & information 10 tips for a perfect business requirements document http//projectcourses.wordpress.com/2011/02/15/10-top-tips-for-a-perfect-business-requirements-document/ Business Requirements Document: a High-level ReviewHow to create business requirements document www.ehow.com/how_2067174_create-business-requirements.html Documenting business requirements www.klr.com/articles/Articles_BA_DocumentingBusinessRequirements.pdf Business Requirements Document template www.bced.gov.bc.ca/imb/downloads/cdmdt/dt_brd.doc 10 Tips for Preparing a Business Requirements Document www.brighthub.com/office/project-management/articles/116239.aspx The perfect business requirements document http://ezinearticles.com/?The-Perfect-Business-Requirements-Document&id=5894630 Information on Cause and Effect diagrams http://www.mftrou.com/ Explains what an SOE is http://soe.ecu.edu.au/about/ Article discussing requirements gathering http://www.techrepublic.com/article/gathering-business-requirements/1045549 Sample template for business requirements with explanations http://www.klariti.com/Business-Requirements-Specification-Template/index.shtml Active listening techniques www.mindtools.com For SLA: ? http://www.nkarten.com/sla.html (Naomi Karten: Article on service level agreements and customer expectations) ? http://www.nkarten.com/mce.html (Naomi Karten: Article on service level agreements and customer expectations; excellent readings on SLAs and customer expectations) ? http://www.cio.com/archive/111598/sla.html (CIO.com: Article on the benefits of an SLAs) ? http://www.dba.co.uk/main/tips.htm (Diane Bailey Associates -Training Consultants: interesting readings on SLAs and change management) Business Analysis- Assessment Task 1 LAST UPDATED: March 2015, Version No. 3 Page 12 of 12 T. +61 2 9283 4388 | E. info@wic.nsw.edu.au Lower Ground, 101 Sussex St., Sydney NSW 2000 Australia | www.wic.nsw.edu.au ABN: 19 080 559 600 | CRICOS CODE: 01856K | RTO: 90501