Assignment Papers-A SAS-based information analysis and presentation system: Data management and Business Intelligence
The Task
Overall, you will specify, design and build a small management information analysis and presentation system to analyse the NHS Transparency RTT (Referral to Treatment Time) datasets from the following location https://www.england.nhs.uk/statistics/statistical-work-areas/rtt-waiting-times/rtt-data-2016-17/ and use the XLS spreadsheets for the Admitted Adjusted Commissioner statistics.
is a justified specification of the Management Information System (MIS).
Report Content
The key aspects that must be addressed in the specification report are:
- Identification and justification for the chosen Systems Logic to support the selection and presentation of the data necessary to provide answers to the questions
- Identification and justification for the chosen User Interface to support the selection and presentation of the data necessary to provide answers to the questions
- Identification and justification of the Test Data and Schedule to ensure that the system meets the Stakeholders’ needs
- Identification of the Stakeholder chosen for this MIS and justification of up to three types of questions
- Identification and justification for the chosen Data Architecture to support the selection and presentation of the data necessary to provide answers to the questions
Part 1 – Design and Justification – 30%
This will be a short business style report of approximately 1000 words which provides an outline of the MIS and its design. In order to prepare yourself to design the system and write the report, you will need to carry out at the following steps.
You are required to use the template provided for the Outline Design Specification. Please do not remove the section marking criteria. They provide you with a checklist of what you need to achieve for each section.
Step 1
Understand the structure and meaning of the data from the RTT Monthly spreadsheets; you will be able to do this using both Excel and SAS. From this, identify and justify the key stakeholders who have an interest in the data presented in the spreadsheets.
Step 2
Present and justify simple mock-ups of the relevant data entry and presentation interfaces. User interface can be developed using MENU, SELECT, FRAME, PROJECT etc. Select and deploy the appropriate user interface using SAS.
Step 3
Identify and justify how you will prove that the MIS system that will be developed based on this specification and provide suitable test schedule specifications and test conditions.
Step 4
Choose one of the stakeholders from the above analysis and identify and fully justify no more than three key questions that can be answered by a suitable selection and presentation of data from up to five of the RTT monthly sets of data.
Step 5
Identify the relevant data and the appropriate selection, summarisation and presentation necessary to allow the stakeholder to pose their question and then gain a suitably presented answer. You may need to consider performance issues in designing a reasonably efficient means of storing your data (this could be done using the Log statistics from the SAS 9.4 system when you experiment with different approaches).
Part 2 – Build MIS in SAS – 70%
Part 2.1 (50%):
Using the Outline Specification from part one of the portfolio, you will develop a small MIS application in SAS that implements the intent of your specification.
Part 2.2 (20%):
Each week you have been given a set of exercises to test your understanding of the material covered that week. You are to demonstrate a selection of the exercises that you have done for marking which will be randomly selected from exercises 1-10. Questions will be asked to test your understanding. The assessment will be based on your understanding and the knowledge of SAS programming.
Part 2.1 and 2.2 will be demonstrated together to your tutor during the last week of the semester. The demonstration schedule will be available on Udo Blackboard.
