Question 1

The dataset “BusinessAnalyst_GBA.xlsx” contains the job listings for business analysts across the United States in 2020. It includes the job titles, salary ranges, ratings, locations, sizes, types, sectors, revenues, and the ease of job applications. Here are some additional details on the dataset:

• Missing values are represented as “-1” in fields like “Rating”, “Founded”, “Sector” and “Easy Apply”.

• Salary information (“Min Salary” and “Max Salary”) is in thousand dollars per year.

• “Rating” ranges on a scale from 1 to 5. You are to answer the following questions using this dataset.

(a) Identify one (1) business problem that can be addressed by analysing the dataset and discuss the relevant data fields that can be used to address the business problem. (Up to 150 words for part (a))

(b) Prepare a summary of the whole dataset in tabular format. It should contain each data field’s type and summary measures. (Up to 150 words for part (b))

(c) Develop a proposal for an analytics solution. It should contain a discussion of the appropriateness of at least one (1) business analytics technique to use and the explanation of how the technique(s) can be used to address the identified problem inconstruct the actual model(s). (Use up to 250 words for part (c))

(d) Employ data visualisation techniques to develop four (4) related charts to show interesting trends, patterns, or relationships among variables from the dataset. Provide a screenshot of each produced chart.

Explain how the charts are created and discuss why the charts are recommended to collectively address the problem identified in part a. (Use up to 250 words for part (d))

• Your group shall submit original work. Do not copy any content of your submission from any source (whether public or private).

• The quality of your report is paramount. Marks will be deducted for poor report writing skills such as poor command of English, poor paraphrasing, lacking clarity, etc. 20 marks will be allocated to professional presentation and writing of your GBA report, e.g., covering the following aspects,

•  Organisation
• Communication of ideas
• Citation and reference
• Grammar.