Case Background:

Big Picture: Analyze the current employee composition, including diversity.

Details:

Why is this data important, and what questions or problems need to be addressed?

Human resources $($HR$)$ data gives the business valuable insights into the company corporate culture, as it can show the company current employee makeup and retention efforts.

Analysis of this data helps in identifying areas of the company that are not diverse or inclusive, have a high turnover rate, or have employees who are nearing retirement age, which could mean a knowledge loss unless there is a succession plan in place.

Plan:

What data is needed, and how should it be analyzed?

Data needed to answer the objective is pulled from Julia's Cookies' HR database. In most companies, the HR database contains not only data about employee demographics but payroll information. This data, however, is not available to everyone in the company, and the individuals who do have access to the HR data have different levels of access. For example, very few people in the company can view payroll data, as that is considered confidential, while all employees are able to view employees' full names, their supervisors' names, and their departments.

Now it's your turn to evaluate, analyze, and communicate the results!