Case Scenario: Youre a Data Analyst / Business Analyst working for Data Analytics company that provides data management solutions to its customers. Your company receives a project from the CEO of a multispeciality hospital where you have been asked to understand the current state of their operations, elicit the data needs, and prepare a suitable data management solution. The documentation should include a summary of current state of the scenario, current data and infrastructure related problems, and a holistic approach to handle problems and improve their workflow by improving their data management approaches. Current state of business and data related problems: The hospitals existing database system has their patient and staffs data fragmented i.e., divided across several applications and databases. The database system has been growing organically and now suffers from several shortcomings. Many different form of data storage systems and formats are used such as local disks, network access storage systems, spreadsheets, relational databases etc. Many different forms of data exist such as tabular data in excel sheets, images and videos, digital documents, scanned paper documents, specialised medical images in DICOM format, transcriptions, nurse, GP, specialists and psychologist records and notes. The staff are currently spending lot of time to retrieve data from different databases and connect them to make the case history of a particular patient or staff. Moreover, there are constant changes regarding to the patient s personal details, their locations, medical condition, physicians or psychologists that they get treated from. Staffs records also need to be updated. For example, employments details such as their expertise, work experience, new positions needed to be updated. Based on the hospital strict security policies, they want to keep record of all present and past staff. Although these data would not be used much, hospital would like to store and secure them. With all these complexities, generating a patients or staffs report is time consuming and suffers from several integrity issues. Multiple copies are created and stored which causes redundancy, affects quality, and increases risk of data loss and exposure. Thus, the hospital is looking for ways to manage their documents and contents efficiently. They aim to digitize and store all archived patient history, collect present data responsibly, so that healthcare providers can easily request, use, update, and delete it as necessary. Furthermore, by digitizing the staffs record they will be able to keep track of staff and their responsibilities. The data are currently stored in on-premises storage facilities such as network access storage and local disks with back-up servers all on a local network. The hospital considers this local storage of data as a secure option for storing personal health and other sensitive information, though it is affecting their data quality and impacts the outcomes during audits where they struggle to meet regulatory requirements. Hence, they are seeking advice on benefits and challenges of their current in-house storage approaches and potential alternatives to data management with increased security and data protection. To keep up with their growing patient populations and accommodate their needs, the hospital recently opened an in-house imaging facility, and their database is expected to rapidly grow with high volume of digital unstructured data such as MRIs, CT scans, X-ray, and PET scans. Hence in addition to security, they are also aiming to achieve scalability, interoperability, and ease of integration without a huge impact on their funding. To improve patient support, they are introducing a new model of medical treatment using a telehealth platform and are accommodating new sources of data through IoT for remote monitoring. This again is creating new types of data with integrity and security issues. Overall, the organization needs a highly scalable and reliable data management solution that identifies and address their existing issues and provide a futuristic solution to accommodate their digital transformations and growth.

Question: 1. Identifying the business requirements, data requirements and the existing issues in data handling.

2. Identify data management operations needed to tackle the issues, meet their data-based requirements and steps to be taken to improve their overall workflow and operational efficiency.

3. For example, issues may include but not limited to: Data integrity Data Storage Metadatamanagement Handling legacy data Data migration Data archival Data governance Data privacy Handling documents Data integration

4. Propose a DM strategy that addresses what needs to be done, how new approaches can be implemented or how existing methods and workflow can be improved etc. Your DM strategy should be relevantto each of the issues that you identify from the case scenario.

5. Also provide a schematic of a suitable data architecture (at a conceptual level) that describes how data is proposed to be managed in this scenario from storage and collection through to integration, transformation, distribution, and consumption.