Skip to content

Booksellers & Trade Customers: Sign up for online bulk buying at trade.atlanticbooks.com for wholesale discounts

Booksellers: Create Account on our B2B Portal for wholesale discounts

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

by Mong Shen Ng
Save 9% Save 9%
Current price ₹4,452.00
Original price ₹4,900.00
Original price ₹4,900.00
Original price ₹4,900.00
(-9%)
₹4,452.00
Current price ₹4,452.00

Imported Edition - Ships in 18-21 Days

Free Shipping in India on orders above Rs. 500

Request Bulk Quantity Quote
+91
Book cover type: Paperback
  • ISBN13: 9781077226906
  • Binding: Paperback
  • Subject: N/A
  • Publisher: Independently Published
  • Publisher Imprint: Independently Published
  • Publication Date:
  • Pages: 502
  • Original Price: USD 50.0
  • Language: English
  • Edition: N/A
  • Item Weight: 853 grams
  • BISAC Subject(s): Languages / General and Graphic Methods

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".

Trusted for over 49 years

Family Owned Company

Secure Payment

All Major Credit Cards/Debit Cards/UPI & More Accepted

New & Authentic Products

India's Largest Distributor

Need Support?

Whatsapp Us