Skip to main content

2023 | OriginalPaper | Buchkapitel

Development of Analytical DataMart and Data Pipeline for Recruitment Analytics

verfasst von : Ashish Chandra Jha, Sanjeev Kumar Jha, J. B. Simha

Erschienen in: Intelligent Systems and Machine Learning

Verlag: Springer Nature Switzerland

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

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.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

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!

Literatur
Zurück zum Zitat 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)
Zurück zum Zitat 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)
Zurück zum Zitat 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)
Zurück zum Zitat 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)
Zurück zum Zitat 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)
Zurück zum Zitat 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)
Zurück zum Zitat 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)
Zurück zum Zitat 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)
Zurück zum Zitat 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)
Zurück zum Zitat 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
Zurück zum Zitat 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)
Zurück zum Zitat Gabcanova, I.: Human resources key performance indicators. J. Competitiveness (2012) Gabcanova, I.: Human resources key performance indicators. J. Competitiveness (2012)
Metadaten
Titel
Development of Analytical DataMart and Data Pipeline for Recruitment Analytics
verfasst von
Ashish Chandra Jha
Sanjeev Kumar Jha
J. B. Simha
Copyright-Jahr
2023
DOI
https://doi.org/10.1007/978-3-031-35081-8_5