Part $2$: Making informed decisions using pivot table $($Weight: $20\%)$

In this part, the R & D department in your selected company in part$1$ would like to investigate how other companies $($based on their type, size, and sector$)$ use "data science" in their business environment. For this purpose, the R & D team will use real$-$world data named "Australia Data Science Jobs" to decide on the programming$/$software skills applied in the other companies. Using this data, you should create a pivot table that helps the R&D team decide on preparing a comprehensive report for the Executive committee.

In this section, you need to describe the structure of the pivot table, including the below information:

The variables which you assigned to the four areas of the pivot table, including Report Filter, Column Labels, Row Labels, and Values $(8\%)$

The function you choose for the value area, including sum, average, min, max, count & product $(2\%).$

Justify your selection $(10\%).$

You need to present your results to the R & team. You may use the screenshots and some statistics to support your justification and report.

Tips:

The excel data is uploaded to Canvas$>$ Assignment $4.$

You can find the name of programming languages and technologies from Column $Z$ to Column BA$.$ The values of these variables are binary. For example, in the sixth row, for the job title "data scientist" in the ANZ banking group, python, R$,$ and SQL are used.

Features such as Job Title, company sector, Company Industry, and programming languages and technologies can help you find your pivot table's structure.

How to make the Pivot table? Please review the tutorial of Week $7.$