Predictive Hr Analytics Text Mining And Organizational Network Analysis With Excel
Download Predictive Hr Analytics Text Mining And Organizational Network Analysis With Excel full books in PDF, epub, and Kindle. Read online free Predictive Hr Analytics Text Mining And Organizational Network Analysis With Excel ebook anywhere anytime directly on your device. Fast Download speed and no annoying ads. We cannot guarantee that every ebooks is available!
Predictive HR Analytics, Text Mining and Organizational Network Analysis with Excel
Author | : Dpg |
Publisher | : Independently Published |
Total Pages | : 501 |
Release | : 2019-06-30 |
Genre | : |
ISBN | : 9781077226906 |
Download Predictive HR Analytics, Text Mining and Organizational Network Analysis with Excel Book in PDF, Epub and Kindle
A lot of organizational data is often untapped unstructured data in the form of text & numbers. You don't need to spend months learning R programming & you don't need to buy expensive SPSS statistical software. This is the only book that teaches you how to use Microsoft Excel for Predictive HR Analytics, Text Mining & Organizational Network Analysis (ONA) with step-by-step print-screen instructions: 1) Predictive HR Analytics: Use Excel's Statistical Analysis tools (Decision trees, Correlation, Multiple & Logistic Regression) to run Predictive HR Analytics. E.g. an employee is predicted to have a 60% probability of getting into accidents, if he is age 25, worked 1 year in the company & took 6 days sick leave. An employee is predicted to get rated "7" for Customer Service, if the training program that he attended has a training evaluation score of "8". An employee is predicted to resign if she is age 23, worked for 2 years, and takes 60 minutes to commute to work. 2) Organizational Network Analysis (ONA): Run ONA using Excel's network analysis tool. Learn how to convert an employee's organizational network into a score & then predict if they will be a high-potential (HiPo). E.g. an employee is predicted to be a HiPo with performance rating of "9", if his "Social Network Size" is "16", "Social Network Diversity Index" is "3" & "Competency Score" is "8". 3) Text Mining, Sentiment Analysis & Word Clouds: Mine text from social network posts, employee engagement surveys & Glassdoor comments, then run Sentiment Analysis using Excel & visualize the insights with "Word Clouds". Learn how to predict a company's average employee attrition rate based on its sentiment. E.g. a company's average employee attrition rate is predicted to be 8%, if unemployment rate is 3%, GDP growth is 2%, Glassdoor public sentiment rating is "5", and engagement score is "7".
Predictive HR Analytics, Text Mining and Organizational Network Analysis with Excel Related Books
Pages: 501
Pages: 417
Pages: 501
Pages: 131
Pages: 529