QHO430 Data Analysis, Tools and Application - Solent University

Data Analysis Report

Assessment Task
This task consists of a group work where collaboration and teamwork play an important part. Within the group you should discuss what aspects you wish to study given the available data you can access and what you plan to achieve before deciding on the group project topic. This can be something with potential social impact such as the environment, population distribution, wealth, business, health, education, or international aspects. For a local perspective you could look at data available from the ONS, Office of National Statistics. The World Data Bank has also vast collection of open datasets you could consider. The members of the group should select their individual topic under the domain of the group project topic.

You will require to conduct data analysis on your chosen topic and produce academic report. You should identify your group project topic, your individual data analysis objective(s). Then, perform data analysis based on data analysis process: collect raw data (unanalysed data) from different sources, prepare your collected data (handle your collected data to be ready for your analysis using analysis techniques), analyse your collected data (you can select a wide range of analysis methods such as descriptive analysis, predictive analysis, or prescriptive analysis that suitable to your analysis objective. You can use Excel as your data analysis tool), present your data analysis results using suitable data visualisation. Your data analysis process and results from individual topic will be combined or summary to present insightful information to your stakeholder at the end of module as your group presentation. You also need to ensure that you keep good records of the group meetings, any discussions you have with the group and any collaboration during working on the group project. A self-reflection of your learning process throughout the module and group project will be included in your report.

Formatting of the report
A suggested format:
• Cover Page
• Table of Contents
• Table of Figures
• Report Contents
1. Introduction
- A brief statement of your group project motivation/problems
- Group project aim(s)
- Your objective(s) for your analysis part, you can have more than one objective
2. Methodology
- Data collection: where did you get the data from (you can identify both the dataset use in a group and any specific dataset you use for your individual analysis); how did you retrieve the dataset. Ensure you reference sources for any data you collected or used.
- Data preparation: identify process of data preparation that you perform on your collected data. The process can consist with all the following process or some of them depends on the suitability of the process and collected data. Data understanding, e.g., what variables that have collected, how many variables in that dataset, data cleaning e.g., handle with missing value, data pre-processing e.g., select certain variables to use for analysis, merge data from different file, sorting data etc.
- Data analysis: identify data analysis techniques/approach/method that you use to get the results. Analysis methods need to match with your analysis objectives. You need to perform data analysis using Excel based on your identified approaches
- Results: present the analysis results from your analysis with appropriate data visualisation
- Conclusion: conclusion or summary your individual analysis results
3. Project Management
- Project plan: present your work plan (tasks) and timeline using Gantt chart
- Project collaboration: identify your skill of collaboration - how you are meeting up, how did you work as a group, evidence of group work collaboration e.g., snapshot of discussion board, online-diary, share document on MS team etc.
- Learning reflection: discuss learning outcome you achieve, issues you have had and what in the future you might do differently
• References
A list of citations for all sources you have referred to in the body of your report. These should all be in Solent Harvard reference format