Predictive HR Analytics, Text Mining & Organizational Network

Predictive HR Analytics, Text Mining & Organizational Network Analysis with Excel

Predictive HR Analytics, Text Mining & Organizational Network Analysis (ONA) are hot topics and powerful techniques to improve organization effectiveness. Best Buy is able to predict that a 0.1% increase in employee engagement results in an increase of $100,000 in the storeâ€™s annual income! VoloMetrix found that a salespersonâ€™s network size within their company is a more important leading indicator of sales, than the time salespeople spend with customers! 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. You will learn how to predict Ethnic & Gender Diversityâ€™s impact on EBIT, predict trainingâ€™s impact on sales revenue, predict employee resignation, predict impact of staff engagement on sales, predict workplace accident, etc.
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). You will also learn how to predict employee performance and resignation with ONA graph metrics. E.g. an employee is predicted to be a HiPo with performance rating of â€œ9â€, if his â€œSocial Network Scoreâ€ 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â€.
Country USA
Brand Independently Published
Manufacturer Independently published
Binding Paperback
UnitCount 1
EANs 9781077226906
ReleaseDate 0000-00-00

Country	USA
Brand	Independently Published
Manufacturer	Independently published
Binding	Paperback
UnitCount	1
EANs	9781077226906
ReleaseDate	0000-00-00

Predictive HR Analytics, Text Mining & Organizational Network Analysis with Excel

You might also like...