Research Article
Development of Analytical DataMart and Data Pipeline for Recruitment Analytics
@INPROCEEDINGS{10.1007/978-3-031-35081-8_5, author={Ashish Chandra Jha and Sanjeev Kumar Jha and J. B. Simha}, title={Development of Analytical DataMart and Data Pipeline for Recruitment Analytics}, proceedings={Intelligent Systems and Machine Learning. First EAI International Conference, ICISML 2022, Hyderabad, India, December 16-17, 2022, Proceedings, Part II}, proceedings_a={ICISML PART 2}, year={2023}, month={7}, keywords={HR Analytics Recruitment DataMart Analytical DataMart Dimensional DataMart}, doi={10.1007/978-3-031-35081-8_5} }- Ashish Chandra Jha
Sanjeev Kumar Jha
J. B. Simha
Year: 2023
Development of Analytical DataMart and Data Pipeline for Recruitment Analytics
ICISML PART 2
Springer
DOI: 10.1007/978-3-031-35081-8_5
Abstract
The HR department handles all the data regarding the recruitment process while also analyzing them to select suitable candidates for the organization. The HR department interacts with the data regarding the recruitment using many tools for data analysis and interpretation. Such data should be organized properly to ensure the screening of candidates. Each system gives their own report in their own format. Data is not integrated and aggregated at proper granularity suitable for analysis. This can be mitigated by the use of Dimensional and Analytical DataMarts. The dimensional DataMarts will contain transitional data modified for analysis with dimensions and facts. These DataMarts can be used for any adhoc analysis like drill down/roll up, slice and dice, drill through, comparative analysis etc. The analytical DataMart will contain the aggregated data in one row per employee format. This will be task specific like Quality of Hire modeling, Cost of Hire, Time to Hire, demand prediction etc.
This paper has focused on creating a recruitment DataMart for Human Resource Department with the assistance of the data modeling technique. This Paper has also discussed the exploratory data analysis and model building in relation to the DataMarts for the recruitment.
