Practical Data Analysis for Business - Level 7

Learning Outcome 1: Critically evaluate ethical and methodological considerations associated with applied secondary research, considering the implications for strategic leadership and organisational development.

Learning Outcome 2: Evaluate, and discriminate between, sources of secondary data and information, justifying relevance to the task and context.

Learning Outcome 3: Select, justify and apply appropriate data analysis tools.

Learning Outcome 4: Devise and justify use of ethical, workable and creative solutions in the light of evidence.

Assessment - TC1 Response to a live employer brief

The Assessment Task
The COVID-19 pandemic in the United Kingdom is part of the worldwide pandemic of coronavirus disease 2019 (COVID-19). The virus reached the UK in late January 2020. As of September 2021, there had been more than 6 million confirmed cases and over 120,800 deaths among people who had recently tested positive - the world's twentieth-highest death rate by population and the second-highest death toll in Europe after Russia. You work as a consultant for Tudor Data Solution limited, a data analysis firm and you have been requested by the line manager to conduct a detailed investigation on the problems related to COVID-19 in the UK for a local newspaper. Using the government-based data set provided, you will devise a 2000-words report that provides insight on COVID-19 issues in the UK.

You will use the secondary data provided retrieved from ONS for your analysis. Your data will be analysed using appropriate software packages (i.e. SPSS/NVIVO/Tableau/Excel) and be visualised for easier interpretation. You will be required to support your data set with insight from other selected information sources and to present this in a form appropriate for a specialist and not specialist audience. You have been given 72h to complete this task.

Your report should cover the following points

A brief review of the literature on the topic

Review the Data sets and its implications for strategic leadership

Data Analysis and visualisation of the data set to provide insight using the appropriate statistical packages (i.e. SPSS/NVIVO/Excel/Tableau)

Evidence of training completed on LinkedIn learning (screenshots of SPSS, Tableau & NVIVO certificates provided in appendix)

This should be a clear and visual presentation that uses your graphs and visual interpretations to highlight how insights are gained and evaluated.

The report should be in a page numbered report format and include the following:

Title page
Assignment title, module code, full name and student code, as well as submission date.

• Abstract
• Table of Contents
• Introduction
• Findings and Analysis
• Conclusions
• Recommendations
• References
• Appendices

In your appendix you may want to provide further detailed documentation of points made in the findings. Examples include: technical data, tables, charts or leaflets. An appendix contains supplementary information that you consider to be too long, complicated or not quite relevant to include in the main section of the report but is still relevant to your reader. Each appendix should be referred to in your text. You should not include something as an appendix if it is not discussed in the report except the certificates. LinkedIn certificates of completion will also be provided in this section.