{"id":41828,"date":"2024-04-04T10:00:23","date_gmt":"2024-04-04T08:00:23","guid":{"rendered":"https:\/\/www.sqorus.com\/?p=41828"},"modified":"2024-08-20T10:50:46","modified_gmt":"2024-08-20T08:50:46","slug":"turnover-prepare-analysis","status":"publish","type":"post","link":"https:\/\/www.sqorus.com\/en\/turnover-prepare-analysis\/","title":{"rendered":"How can you prepare your turnover analysis by selecting the data that impact it?"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.16″ custom_padding=”0px|0px|0px|0px” global_colors_info=”{}”][et_pb_row _builder_version=”4.16″ custom_padding=”0px|||||” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.27.0″ custom_padding=”||5%||false|false” inline_fonts=”Roboto” global_colors_info=”{}”]<\/p>\n

Would you like to understand why you should conduct a turnover analysis in your organization and what data is important for this? The first part of our study on the data to be taken into account when analyzing turnover<\/a> has revealed the different facets of this phenomenon, and gives you the employee characteristics and variables to be taken into account.<\/p>\n

Let’s dive into the second part of our analysis. In this section, we’ll prepare our data for analysis. We’re going to look at each variable and understand its influence on the employee’s voluntary departure.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.0″ custom_padding=”||5%||false|false” inline_fonts=”Roboto” global_colors_info=”{}”]<\/p>\n

Keep in mind that the variable names represent our use case, but that you need to adapt them to your case.<\/em><\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.0″ custom_padding=”||||false|false” inline_fonts=”Roboto” global_colors_info=”{}”]<\/p>\n

Data preparation and exploratory turnover analysis<\/h2>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.0″ custom_padding=”||5%||false|false” inline_fonts=”Roboto” global_colors_info=”{}”]<\/p>\n

To better understand the factors influencing turnover<\/strong> within your organization, it’s essential to look atHR data analysis<\/strong>.<\/p>\n

Thanks to the use of data analysis tools such as Python (which we will also use in the rest of the study), we can import these data and prepare our study.<\/p>\n

What is exploratory data analysis?<\/h3>\n

Exploratory Data Analysis (EDA) is used to analyze and study data sets and then summarize their main characteristics, using visualization methods or statistical tests.
\nIt enables you to better understand the variables in a dataset and the relationships between them, and thus determine the best way to manipulate data sources to get the answers you need. <\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.0″ custom_padding=”||||false|false” inline_fonts=”Roboto” global_colors_info=”{}”]<\/p>\n

1st stage of EDA: analysis of missing values<\/h2>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.0″ custom_padding=”||5%||false|false” inline_fonts=”Roboto” global_colors_info=”{}”]<\/p>\n

The first thing to do is to look at the missing values. These gaps can be revealing and need to be treated with care. We notice that more than 50% of the employee and manager score data are missing, so we decide to exclude these variables. For the other variables, missing values represent less than 4% of the dataset, so we simply delete the rows associated with them. This way of thinking is just one example, but it’s important to analyze the impact this kind of decision can have on the final results.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.0″ custom_padding=”||||false|false” inline_fonts=”Roboto” global_colors_info=”{}”]<\/p>\n

What is chi2 and why use it to analyze turnover data?<\/h2>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.0″ inline_fonts=”Roboto” global_colors_info=”{}”]<\/p>\n

Now we want to know whether all the variables selected at the outset are relevant to our analysis. We will therefore apply a chi2 statistical test of independence to each of our variables individually.<\/p>\n

We choose to use the chi2 test because it’s a test of independence for categorical variables that shows whether one variable depends on another. Here, we want to know whether a variable has an influence on departures, i.e. whether departures are dependent on any variable. For example, in our case, if we apply the test to the age variable, we have seen that age has an influence on departures.<\/p>\n

We can therefore model a contingency table:<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/www.sqorus.com\/wp-content\/uploads\/2024\/08\/Tableau-contingence-turnover.png” title_text=”Contingency table – turnover” _builder_version=”4.27.0″ _module_preset=”default” custom_padding=”||5%||false|false” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.27.0″ custom_padding=”||5%||false|false” inline_fonts=”Roboto” global_colors_info=”{}”]<\/p>\n

This contingency table shows that the youngest employees
(aged 0-30 and 31-40) account for a high proportion of departures: 42% + 35% of departures are in these age brackets. This is not the final result, but a complement to the results that may or may not be visible on the dashboard.<\/p>\n

The chi2 test therefore enabled us to determine which variables to exclude from our study. In our case, we have deduced that the number of internal transfers and long-term leave have no impact on departures, so we will not take them into account in our study. Apart from these, we will use all other variables.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.0″ custom_padding=”||||false|false” inline_fonts=”Roboto” global_colors_info=”{}”]<\/p>\n

Conclusion on data preparation and exploratory turnover analysis<\/h2>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.0″ custom_padding=”||5%||false|false” inline_fonts=”Roboto” global_colors_info=”{}”]<\/p>\n

To conclude this second part,exploratory data analysis<\/strong> has proved to be a valuable tool for deciphering the complexities inherent in our data set.
\nIn this way, we have been able to identify the variables that merit particular attention in the next stages of the study.
The chi2 test<\/strong>, applied systematically to all variables over an extended period, provides a rich and relevant dataset for thestudy of turnover<\/strong>. <\/p>\n

SQORUS is your partner of choice in this process, providing expertise, innovation and personalized support. Contact us today to discuss your specific requirements.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.0″ background_color=”#f7fbff” custom_margin=”||8%||false|false” custom_padding=”5%|5%|5%|5%|true|true” border_radii=”on|23px|23px|23px|23px” inline_fonts=”Roboto” global_colors_info=”{}”]<\/p>\n

In our third and final part, we show you how touse PowerBI to easily visualize turnover data and find solutions<\/a>.<\/p>\n

This tool will enable you to immediately grasp trends,identify<\/strong> significantturnover factors<\/strong> and make informed decisions to optimize payroll management<\/strong>.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding_last_edited=”on|desktop” _builder_version=”4.26.1″ background_color=”#2029a0″ background_image=”https:\/\/www.sqorus.com\/wp-content\/uploads\/2023\/12\/Bandeau-LB-Strategie-RH.png” background_size=”contain” background_position=”center_right” width=”100%” width_tablet=”90%” width_phone=”90%” width_last_edited=”on|phone” custom_margin=”||3%||false|true” custom_padding=”50px|400px|50px|55px|true|false” custom_padding_tablet=”50px|55px|50px|55px|true|true” custom_padding_phone=”40px|55px|40px|55px|true|true” background_last_edited=”on|phone” background_enable_image_tablet=”off” border_radii=”on|23px|23px|23px|23px” global_module=”25050″ global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text module_class=”Titre_40 Titre_blanc” _builder_version=”4.24.0″ _module_preset=”default” header_2_font_size=”30px” global_colors_info=”{}”]<\/p>\n

What tools can you use to manage your HR strategy?<\/h2>\n

[\/et_pb_text][et_pb_text module_class=”FondBleu” _builder_version=”4.23.1″ _module_preset=”default” text_font=”||||||||” text_text_color=”#d6d8f4″ text_line_height=”30px” global_colors_info=”{}”]<\/p>\n

Optimize your HR strategy and discover the essential management tools you need to achieve your objectives. Don’t miss this opportunity to successfully manage your HR projects.<\/p>\n

[\/et_pb_text][et_pb_button button_url=”https:\/\/www.sqorus.com\/en\/ebook-which-tools-to-manage-your-hr-strategy\/” button_text=”Download” button_alignment=”left” button_alignment_tablet=”center” button_alignment_phone=”center” button_alignment_last_edited=”on|tablet” admin_label=”Bouton de t\u00e9l\u00e9chargement” module_class=”Bouton Fond_blanc” _builder_version=”4.27.0″ _module_preset=”default” custom_button=”on” button_text_size=”15px” button_text_color=”#f36145″ button_bg_color=”#FFFFFF” button_border_width=”1px” button_border_color=”#f36145″ button_border_radius=”50px” button_font=”||||||||” button_use_icon=”off” custom_margin=”20px||||false|false” custom_padding=”13px|25px|13px|25px|false|false” custom_css_free_form=”selector:hover{|| background-color: #FFF6F5 !important;||}” global_colors_info=”{}”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Section” _builder_version=”4.18.0″ _module_preset=”default” global_module=”12729″ saved_tabs=”all” global_colors_info=”{}”][et_pb_row _builder_version=”4.27.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.27.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.27.0″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n

See also our feature on “HR strategy management tools”. <\/h3>\n

 <\/p>\n