Service Desk Relevant Documentation Reviewed - Management Assignment Help

Assignment Task:

TASK:

Assessment/evidence gathering conditions
Each assessment component is recorded as either Satisfactory (S) or Not Yet Satisfactory (NYS). A student can only achieve competence when all assessment components listed under procedures and specifications of the assessment section are Satisfactory. Your trainer will give you feedback after the completion of each assessment. A student who is assessed as NYS is eligible for re-assessment. Should the student fail to submit the assessment, a result outcome of Did Not Submit (DNS) will be recorded.
Student should be provided with an appropriate time frame in which to resubmit their work, according to the RTO’s re-assessment policy and procedure.
Plagiarism, cheating and collusion.
Where a trainer/assessor believes there has been an incident of academic misconduct involving plagiarism, cheating, and/or collusion, they should report this along with reasons for the allegation. Assessors should refer to their RTO’s policy and procedures regarding training and assessment for further information.”
When all unit’s assessment tasks have been submitted and assessed (including resubmissions), print out a copy of this unit’s Final Results Record, included as the last page of this document. Record the result for each task and the final result for the unit as C (Competent) or NYC (Not Yet Competent). There is also space to give the student some written feedback for the overall unit.
Sign and date the middle section, and give the sheet to the student. After discussing their results with them, the student must fill out and sign the final section of the Record, where they acknowledge the result that you have given them.
When the student has filled out the final section of the Final Results Record, make a copy for them and retain the original with the student’s records.
Resources required for this Assessment
All documents must be created using Microsoft Office suites i.e., MS Word, Excel, PowerPoint
Upon completion, submit the assessment printed copy to your trainer along with assessment coversheet.
Refer the notes on eLearning to answer the tasks
Any additional material will be provided by Trainer
Instructions for Students
Please read the following instructions carefully
This assessment is to be completed according to the instructions given by your assessor.
Students are allowed to take this assessment home.
Feedback on each task will be provided to enable you to determine how your work could be improved. You will be provided with feedback on your work within 2 weeks of the assessment due date.
Should you not answer the questions correctly, you will be given feedback on the results and your gaps in knowledge. You will be given another opportunity to demonstrate your knowledge and skills to be deemed competent for this unit of competency.
If you are not sure about any aspect of this assessment, please ask for clarification from your assessor.
Please refer to the College re-assessment and re-enrolment policy for more information.
Please provide required references of the sources, if you use any information from any sources (such as: learner book, power point and online resources) to answer the assessment questions and make the required changes to justify that it is your own work.

Re-submission opportunities
Please read the following instructions carefully
Students will be provided feedback on their performance by their Assessor. The feedback will indicate if you have satisfactorily addressed the requirements of each part of this task.
If any parts of the task are not satisfactorily completed your assessor will explain why and provide you written feedback along with guidance on what you must undertake to demonstrate satisfactory performance. Re-assessment attempt/ s will be arranged at a later time and date.
Students have the right to appeal the outcome of assessment decisions if they feel they have been dealt with unfairly or have other appropriate grounds for an appeal.
Students are encouraged to consult with their assessor prior to attempting this task if they do not understand any part of this task or if they have any learning issues or needs that may hinder them when attempting any part of the assessment.
Please see Student Assessment, Reassessment and Repeating Unit of Competency Guidelines v1.1 for more detail.

Assessment 1: Report WritingInstructions:
Banking Products keeps the data about the customers, branch and the products of the bank. These are the products of the “HAND” Bank. The purpose of this data warehouse is to extract all the data from the transactional system and store it in the data warehouse. While the concept of a data warehouse sounds quite simple, in reality it is almost completely opposite. To store the data in the data warehouse first the data should be transformed to the common format then cleansing should be done to allow it to generate queries and reports to take some strategical decisions.
Scenario
“HAND” Bank was established in 2009. It has around more than 20 branches in all around the United States. The Headquarter of this branch is in the Houston. The bank managers in each branch want to know to whom the credit card and loan should be given if they are applying for the same. They also want to find out most profitable customer, profitable branch etc. All the data of the customers are stored in the transactional system from where the bank managers cannot make any decisions. You work as a Database Administrator in “HAND” Bank. So, for that you require to build the data warehouse to generate some strategical reports.
“HAND” Bank’s Current Schema:

Your Tasks:
Task 1: Explain Why “HAND” Bank use data Warehouse?
Task 2: Identify subject areas, with reference to the business processes and the required data.
Task 3: Develop the warehouse source specifications, with reference to the existing data tables and files. Task 4: Provide your suggestion about Implementation Methodology?
Task 5: Provide Dimensional Modelling and defining Data Structure for the case?
Task 6: Show the Cost-benefit analysis for suggestion.
Task 7: Design Data warehouse Plan for final approval.
Task 8: Implement the Data warehouse SQL SERVER 2008.
Task 9: Generate Report for Credit Card and Loan Approval, Most profitable customer, Most Profitable Branch.
Task 10: Create an action plan to implement the system. (Use the template provided below)
Action Plan
Actions/Activities Responsible Person Timeframe
Task 11: Develop an acceptance/handover agreement according to the sample given below for the system your team developed.
Task 12: What type of training services would you recommend for the new system as part of implementation process?

Introduction

This document is the ICT Operational Acceptance document and needs to be completed to ensure the smooth transition of new and enhanced services into the Business as Usual (BAU) support teams, both within Information Technology Services (ITS) and ANU.
This document is mandatory and is a deliverable for the majority of projects with an IT element. The document will ultimately be in the form of a checklist which references the many documents produced as the project progresses. It is anticipated that these reference documents will be reviewed and signed off appropriately. Accordingly, this document becomes a record of what is to be delivered, recording those documents and their state and owners. It is not anticipated that there will be large amounts of text within this document.
The Project Manager is responsible for ensuring that the appropriate documentation is provided to the various lines of services and that the Line of Service (LOS) then complete this document confirmation that they are happy with the information and training they have received to accept this new service into BAU.
The Project Delegate will review the Operational Acceptance document prior to presentation to the CIO.
The CIO ITS will have final sign off for the completed Operational Acceptance document.
Until sign off is achieved BAU support for the new / enhanced service will not be provided.
High Level Project DetailsPlease provide a high-level view of what is being delivered from this project.

2.1GeneralProject Name Project Reference No Project Delegate Project Manager Solution Architect(s) Service Architect Service Start Date Service End Date Client (business owner) – contact details Name of service as referred to by business Definition of the new or enhanced service/s Business process/purpose Please state what is being delivered:
Business Stakeholders – contact details Expected number of business users Please state the number of people who will be using this service from the go-live date (plus any expected bow waves/ramp up of user numbers)
WarrantyLength of Warranty Period Warranty Support Arrangements Hours of Support Contact Names/Details Design DocumentationPlease embed all relevant documentation for this new / enhanced service. Not all of these documents are required for all projects / changes.
NAME OF DOCUMENT AUTHOR EMBEDDED DOCUMENT COMPLETE
Project Initiation Documentation Selection Artefacts Project Management Documentation Project Financials Solution Design Physical Design Data Conversion Documentation Service Design Document Benefits Realisation Plan Security Assessment Test Records Release Policy Disaster Recovery Plan Business Continuity Plan Capacity Plan / Design Risk, Issue, Assumption and Dependency logs Open Issues Register IT Change Management RFCs Organisational Change Management Plan Communication Plan Training Plan & Associated Documentation Operational Handover Plan Knowledge Articles Governance model Post Implementation Review Schedule Asset ManagementIf not included in design documentation, please provide details of all hardware, software, licences, maintenance agreements, etc. procured for this project.
Asset Details (including costs) Owned by ITS / ANU
Third Party ManagementThird Party Relationship Owner Contract or details of service model agreed Reviewed
Additional InformationPlease provide any additional information relevant to this project.
Delivery UnitsAll delivery units involved in the BAU support of this new service are required to review the documents pertaining to their area of service. They need to ensure that they have been given adequate information to support this change/new service and need to sign below to state that they are happy to accept this into BAU support. Any gaps in support documentation should be routed back thought the Project Manager.
Unit Statement Sign Off Contact Details Date

• Service Desk Relevant documentation reviewed and happy to accept into BAU support Unit Statement Sign Off Contact Details Date
• Major Incident Management Relevant documentation reviewed and happy to accept into BAU support Unit Statement Sign Off Contact Details Date
• Problem Management Relevant documentation reviewed and happy to accept into BAU support Unit Statement Sign Off Contact Details Date
• Change Team (Local) Relevant documentation reviewed and happy to accept into BAU support Unit Statement Sign Off Contact Details Date
• Change Team (ANU) Relevant documentation reviewed and happy to accept into BAU support Unit Statement Sign Off Contact Details Date
• Release Management Relevant documentation reviewed and happy to accept into BAU support Unit Statement Sign Off Contact Details Date
• Capacity management Relevant documentation reviewed and happy to accept into BAU support Unit Statement Sign Off Contact Details Date
• ITS Security Relevant documentation reviewed and happy to accept into BAU support Unit Statement Sign Off Contact Details Date
• Business Continuity Team Relevant documentation reviewed and happy to accept into BAU support
   

Unit Statement Sign Off Contact Details Date

• Disaster Recovery Team Relevant documentation reviewed and happy to accept into BAU support Unit Statement Sign Off Contact Details Date
• Infrastructure Services Relevant documentation reviewed and happy to accept into BAU support Unit Statement Sign Off Contact Details Date
• Network Services Relevant documentation reviewed and happy to accept into BAU support Unit Statement Sign Off Contact Details Date
• Applications Support Relevant documentation reviewed and happy to accept into BAU support Unit Statement Sign Off Contact Details Date
• DBA’s Relevant documentation reviewed and happy to accept into BAU support Unit Statement Sign Off Contact Details Date
• Service Delivery Manager (ITS) Relevant documentation reviewed and happy to accept into BAU support GlossaryAcronym Definition Explanation
• BAU Business As Usual The point at which project work is transitioned into an agreed, measurable and provable “steady state” business working environment
• LoSLines of Service All the BAU teams who have some responsibility for the support of the new / enhances service.

Assessment 1 Checklist
Student’s name:
Did the student: Completed successfully Comments
Yes No Task 1: Explain Why “HAND” Bank use data Warehouse? Task 2: Identify subject areas, with reference to the business processes and the required data? Task 3: Develop the warehouse source specifications, with reference to the existing data tables and files? Task 4: Provide suggestion about Implementation Methodology? Task 5: Provide Dimensional Modelling and defining Data Structure for the case? Task 6: Show the Cost-benefit analysis for suggestion. Task 7: Design Data warehouse Plan for final approval? Task 8: Implement the Data warehouse SQL SERVER 2008? Task 9: Generate Report for Credit Card and Loan Approval, Most profitable customer, Most Profitable Branch? Task 10: Create an action plan to implement the system? Task 11: Develop an acceptance/handover agreement according to the sample given below for the system your team developed? Task 12: What type of training services would you recommend for the new system as part of implementation process? Task Outcome: Satisfactory Not Satisfactory
Assessor name: Assessor signature: Date: Assessment 2: Written Tasks (Attempts all questions)
Q1. Describe database design documentation steps? Describe about database design document essentials like data structure, queries, report and user interface?
Q2. What is Big Data? Why we consider Big Data? How it Works? How it helps corporate sector?
Q3. Compare the database access and security design, with the business security plan?
Q4. Explain the business operating systems related to the data sources?
Q5. What is DBMS used for? Why is the use of DBMS recommended? Explain by listing some of its major advantages? Explain the concept of ACID properties in DBMS?
Q6. Describe about Decision-support System related to Knowledge management strategies.
Q7. Explain encryption and authentication as they apply to database security features.
Q8. Outline the functions and features of dimension tables and fact tables.
Q9. Explain what is proprietary software? Describe the benefit of installation of proprietary software?
Q10. Explain the logical database model knowledge needed to facilitate data extraction.
Q11. Describe the relationship between databases and data warehouses.
Q12. Describe the levels of technical documentation required for newly developed data management systems.
Q13. What are the benefits of data warehouse system in the following Fields?
In business intelligence
In the healthcare industry
In political science
Banking sector

 

This Management Assignment has been solved by our Management experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.