__STYLES__
Legacies Group (also known as Legacies Media and Entertainment) is an American media company formed in 2010. it is the owner of the largest commercial radio company in America and has expanded through a number of historical acquisitions, including Toyoda Radio, Dswag Media and HED Radio. Legacies Group owns and operates seven core radio brands, all employing a national network strategy.
Legacies Group also owns and operates one of the leading out-of-home advertising (OOH) companies in America through its outdoor division. They are currently having HR issues and need an experienced HR analyst.
As an HR Analytics Consultant, the goal is to provide an in-depth analysis of what is happening in the Legacies Group.
The dataset was in CSV format with the following columns;
The dataset had several blank cells, most especially the Date of Termination column. Not all employees were terminated hence the blank cells. I handled the blank cells by replacing all blanks with a hyphen (-) in Excel.
All other manipulation was done in Power Query after importing the dataset into Power BI.
The employee's age was calculated in the power query editor using the Date of Birth of the employee.
The employee's ages were grouped into 5 categories using Data Analysis Expressions (DAX). The categories; 20-29 (Youth), 30-39 (Young Adult), 40-49 (Adult), 50 -59 (Elderly) and >60 (Aged).
Length of Service = Date of Termination - Date of Hire. This was calculated using the DATEDIFF function.
Interact with my dashboard here.
The age range 40 -49 are the most populated group and are the most likely to leave, upskilling and reskilling is a good initiative while recruiting the younger age group and contributing to their career advancement. The purpose of upskilling and reskilling; is to boost employees' ability to carry out their roles, to improve staff's performance in existing functions and for employees to understand changing trends in the media and entertainment industry and update their skills so they are relevant. This could be through internal training, courses, or partnerships with other companies.
How often are employees appraised and how are the results best used to encourage the employees? The manager of the production department should look into the appraisal of employees in this department. Employees in this department voluntarily left either for another position, unhappiness, more money or career change. Appraisals lead to development and motivation.
The company should consider revising the salary of their long-term employees to keep motivating them. Some organisations carry out salary revisions; when the company's salary structure doesn't match the market, to afford a cost-of-living adjustment and when staff is promoted to a new job. An effective salary revision can drive higher rates of workplace satisfaction and retention.
Employee satisfaction goes beyond simply keeping workers happy, which is an emotion that no organization can create on demand. Instead, Gallup reports what employees really want is to be engaged with and inspired by their workplaces. Some of the factors driving employee satisfaction; are feeling energized by work, feeling like they belong, having a sense of purpose, achieving goals and having a culture of inclusion.