Part $2$: Making informed decisions using pivot table $($Weight: $20\%)$In this part, the R & D department in your selected company $($Qantas$)$ 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 &D 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.