Skip to main content
Top

2023 | OriginalPaper | Chapter

Development of Analytical DataMart and Data Pipeline for Recruitment Analytics

Authors : Ashish Chandra Jha, Sanjeev Kumar Jha, J. B. Simha

Published in: Intelligent Systems and Machine Learning

Publisher: Springer Nature Switzerland

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

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.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literature
go back to reference Kailash, M.P.: HR Analytics methodical measurement of HR processes. Int. J. Innov. Sci. Res. Technol. (2020) Kailash, M.P.: HR Analytics methodical measurement of HR processes. Int. J. Innov. Sci. Res. Technol. (2020)
go back to reference Kimball, M.R.: Data warehousing, business intelligence, and dimensional modeling primer. In: Kimball, M.R. (ed.) The Data Warehouse Toolkit, 3rd edn., pp. 7–16. Wiley (2016) Kimball, M.R.: Data warehousing, business intelligence, and dimensional modeling primer. In: Kimball, M.R. (ed.) The Data Warehouse Toolkit, 3rd edn., pp. 7–16. Wiley (2016)
go back to reference Kimball, M.R.: Employees tracking for profile. In: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd edn., pp. 263–265. Wiley (2016) Kimball, M.R.: Employees tracking for profile. In: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd edn., pp. 263–265. Wiley (2016)
go back to reference Kimball, M.R.: Data warehousing. In: Business Intelligence, and Dimensional Modeling Primer, in Kimball The Data Warehouse Toolkit, 3rd edn., pp. 7–16. Wiley (2016) Kimball, M.R.: Data warehousing. In: Business Intelligence, and Dimensional Modeling Primer, in Kimball The Data Warehouse Toolkit, 3rd edn., pp. 7–16. Wiley (2016)
go back to reference Kimball, R., Ross, M.: Employees tracking for profile. In: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd edn., pp. 263–265. Wiley (2016) Kimball, R., Ross, M.: Employees tracking for profile. In: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd edn., pp. 263–265. Wiley (2016)
go back to reference Prado, A., Freitas, C., Sbrici, T.R.: Using OLAP tools for e-HRM: a case study. Int. J. Technol. Human Interact. (2010) Prado, A., Freitas, C., Sbrici, T.R.: Using OLAP tools for e-HRM: a case study. Int. J. Technol. Human Interact. (2010)
go back to reference Hamoud, A.K., Ulkareem, M.A., Hussain, H.N., Mohammed, Z.A., Salih, G.M.: Improve HR decision-making based on data mart and OLAP. J. Phys. Conf. Ser. (2020) Hamoud, A.K., Ulkareem, M.A., Hussain, H.N., Mohammed, Z.A., Salih, G.M.: Improve HR decision-making based on data mart and OLAP. J. Phys. Conf. Ser. (2020)
go back to reference Udhay Kailash, M.P.: HR analytics methodical measurement of HR processes. Int. J. Innov. Sci. Res. Technol. (2020) Udhay Kailash, M.P.: HR analytics methodical measurement of HR processes. Int. J. Innov. Sci. Res. Technol. (2020)
go back to reference Kimball, R., Ross, M.: Data warehousing, business intelligence, and dimensional modeling primer. In: Kimball The Data Warehouse Toolkit, 3rd edn., pp. 7–16. Wiley (2016) Kimball, R., Ross, M.: Data warehousing, business intelligence, and dimensional modeling primer. In: Kimball The Data Warehouse Toolkit, 3rd edn., pp. 7–16. Wiley (2016)
go back to reference ttttt (n.d.). Retrieved from Gartner Identifies Three Most Common AI Use Cases in HR and Recruiting ttttt (n.d.). Retrieved from Gartner Identifies Three Most Common AI Use Cases in HR and Recruiting
go back to reference Inuwa, I.: Design of a data warehouse model for a university decision support system. J. Inf. Knowl. Manage. 5 (2015) Inuwa, I.: Design of a data warehouse model for a university decision support system. J. Inf. Knowl. Manage. 5 (2015)
go back to reference Gabcanova, I.: Human resources key performance indicators. J. Competitiveness (2012) Gabcanova, I.: Human resources key performance indicators. J. Competitiveness (2012)
Metadata
Title
Development of Analytical DataMart and Data Pipeline for Recruitment Analytics
Authors
Ashish Chandra Jha
Sanjeev Kumar Jha
J. B. Simha
Copyright Year
2023
DOI
https://doi.org/10.1007/978-3-031-35081-8_5

Premium Partner