Creating a COVID-19 Dashboard for GP Practice using Power BI and NHS Open datasets

About the Task

You are working for a local General Practitioner (GP) practice and have been asked to provide a dashboard that visualises key data and statistics of the pandemic, serving as business intelligent platform for this GP practice. This has been requested by the Practice Manager who wants to digitalise the practice. Firstly, she wants to explore more about what digital health actual means, what benefits it might bring or what challenges. Secondly, she wants to make better use of the data available to GP practices. They have recently invested in Power BI (https://powerbi.microsoft.com/en-us/) and want to make use of the NHS open data-sets (https://www.nhs.uk/about-us/nhs-website-datasets/) with a focus on the pandemic data. With better understanding of the data, the GP practice will be then be able to produce a business intelligent system as next step. 
Part 1 of your task will be producing three different models that are used in Information Systems to demonstrate how information is captured, flows and used.

Part 1: Modelling:
        
a. Draw a ‘rich picture’ that is a diagrammatical representation of digital health that illustrates the challenges and opportunities of the different technologies, platforms and applications that make up digital health (/40)
        
b. Draw a use-case diagram with proper notations of UML to indicate the key functionality and stakeholders (human or other IS/dataset) of the COVID -19 Dashboard 
        
c. Create a Level 2 Data Flow Diagram to indicate a scenario of how a stakeholder can use dataset in the COVID-19 Dashboard in the PG practice.

 

Assessed intended learning outcomes

On successful completion of this assessment, you will be able to:

1. Demonstrate an awareness of the function of Information Systems as part of the organisational infrastructure

2. Describe the basic principles of database and develop a database application

3. Select the appropriate tools and methodologies to plan an Information Systems development

4. Explain an awareness of the key contemporary issues relating to security, ethics and standards of an Information
System

1. Demonstrate and apply a range of Information Systems modeling (or analysing) techniques 

2. Demonstrate the developmental skills of database design and development

1. Competently (individually and as part of a team) use a range of digital literacy skills and applications to research,
analyse and communicate your findings to a non-technical audience.

2.Use a range of digital technologies to communicate and collaborate In virtual spaces.

3. Develop a range of organisational skills including: project managing, time manage, analyse, critique and evaluate written material.

 
4. Develop reflective skills for continued learning.

 

5.  To develop an understanding of the pivotal role of Information Systems within a business context
    a. To Introduce techniques and modelling tools necessary to analyse the information flows into, out of, within and between organisations
    b. To demonstrate an appreciation of a range of methodologies for Information Systems Development
    c. To develop an understanding of the key Information Systems related issues data, information and knowledge management
    d.To introduce the need to consider professional, business and societal issues in the planning and developmental process of Information Systems.