BSS0041- Using Data to Build Business Practice - Business Report Writing Assessment Answer

BSS004-1 Using Data to Build Business Practice Report Writing Assessment Answer

Assessment Task:

This is an individual piece of assignment accompanied by a dataset. You MUST prepare all your charts and perform all your calculations in Excel. You will be assessed on your Excel skills, so make sure that you use appropriate Excel functions and layout your work in a suitable manner.

Your findings should be interpreted within the context given in the assignment brief. You must present your findings in a report in Word of no more than 2,500 words (including all charts/tables). You MUST use Harvard referencing for any sources you cite. This includes in-text references as well as a reference list.

Please submit BOTH your Excel file and Word document through the link on BREO. Note that this is an INDIVIDUAL assignment. The work you
submit MUST be your own, individual work. This applies to BOTH your work in Excel and your report in Word. Note: Your report will be based on your charts and
calculations in Excel. You MUST, therefore, submit BOTH your Excel file and your report in Word. You will be marked down if you do not show clear evidence of your calculations in your Excel file.

Referral Assignment Brief:
The International Passenger Survey (IPS) collects information about passengers entering and leaving the UK, and has been running continuously since 1961.  The Excel file TravelPac Q3 2017 contains the latest data from the third quarter of 2017. The first tab (Metadata) contains descriptions of the variables in the dataset which can be found in the second tab (Labelled 2017

Q3). The last tab (Numeric 2017 Q3) contains coded data.
You have just started employment in the Marketing department of a firm of travel agents who serve overseas residents wishing to travel to Britain.

Your tasks:

1. Analyze the data in the TravelPac Q3 2017 in order to gain an understanding of the pattern of travel by overseas residents.

2. Highlight interesting findings.

3. Make recommendations about a potential target segment.

4. Present your work to the Head of the Marketing Department in the form of a report in Word.

Submit your analysis in an Excel file which the Head of the Marketing Department can use for further investigation.

Suggested steps:

•  Familiarise yourself with the data by using Excel’s facilities like sorting, filtering, etc.
•  Pick particular aspects that you want to conduct further, more detailed analysis on.
•  Conduct a visual examination of the data by plotting appropriate charts.
•  Calculate some standard statistics (e.g., mean, mode, range, standard deviation, etc.).
•  Conduct additional analysis that you feel is appropriate to address the tasks above.

Threshold expectations:
In order to pass this assessment you will need to:

•  Display a defined level of knowledge of indicated tools and techniques common to business decision making
•  Select an appropriate technique to summarise and interpret business data
•  Demonstrate competence in a defined range of skills in Excel
•  Communicate results effectively to the relevant audience

This BSS004-1: Business Assessment has been solved by our Business experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.