Using Data to Build Business Practice

Paper details:

Unit Learning Outcomes assessed: Identify data requirements and the appropriate data collection instruments required for effective business decision making Conduct appropriate analysis and clearly communicate findings to a stated audience Description of Assessment Task This is an individual piece of assignment accompanied with 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 lay out 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. Word Limit 2,500 words (maximum) Format 1.Report as a Word document of maximum 2,500 words including charts/tables 2.Excel file including all your charts and calculations using appropriate functions/formulae. 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.Analyse 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