Question

Think about the type of job or career you want when you finish your degree (or a job you have now). Describe a scenario where you would have to use one of the following skills:

• Create and Sort/Filter a table
• Create a Pivot Table
• Importing Data

Why would this be the best way to organize your data? What will this help you do? Why would you choose this method over another? Be specific.

Answer 1

Create and Sort/Filter a table: The job where it would be relevant to create and even sort or filter a table would be the data analytic or big data handler job. This job requires you to manage the data by creating the table and sorting about the needs that the company requires. The same data is then sorted and then sent to the relevant department manager and functions for the relevant functioning of the company.

Create a Pivot Table: A statistics engineer and research analyst would use the statistics and the use of pivot table that would summarise the data for more extensive tables. This would include how the same data is then grouped together to take the sum, average to make sure the research analyst would use this data to create and forecast average demand and supply for the coming year and make the best performance of the company as per the changing the environment.

Importing Data: At last, the importing of data refers to use the data from another table to be imported into your table to use the same data. This importing of data could be used by many human resource manager to use the same employee id data to determine the salary, the base performance and also the variable performance and pay to be determined. This same employee id and pay per performance would then be used to be imported into another table to determine who is most relevant for the promotion and growth of the employee in the company.