NSW-Gov-Virtual-Intership

Data Analysis Case Study

Part 1:

You have been asked to prepare analysis on part-time employees to brief your Director prior to a meeting they are attending with the Workforce Diversity Steering Committee to review whether part-time employment arrangements are increasing.

Please provide:

Trends over time in male and female employment, including any notable changes The current representation of part time employees in the sector and in each Cluster The current representation of male and female part time employees as a proportion of the respective male and the female workforce in the sector and in each cluster Change in these two above statistics over the last 4 years Projection of what the representation will be by 2025 if the current trends continue The Microsoft Excel data file can be found in the task resources section below.

Part 2:

Please prepare a discussion paper (maximum 4 A4 pages of content or 6 presentation slides) of your analysis that would be suitable for a Director to use as a discussion aid in a meeting with senior executives. You must include tables or charts that illustrate your findings.

“This work has the potential to influence the direction of a sector wide target, so it needs to be of the highest quality ...”