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

Predictive HR Analytics, Text Mining and Organizational Network Analysis with Excel
Author :
Publisher : Independently Published
Total Pages : 501
Release :
ISBN-10 : 107722690X
ISBN-13 : 9781077226906
Rating : 4/5 (0X Downloads)

Book Synopsis Predictive HR Analytics, Text Mining and Organizational Network Analysis with Excel by : Dpg

Download or read book Predictive HR Analytics, Text Mining and Organizational Network Analysis with Excel written by Dpg and published by Independently Published. This book was released on 2019-06-30 with total page 501 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Predictive HR Analytics, Text Mining and Organizational Network Analysis with Excel
Language: en
Pages: 501
Authors: Dpg
Categories:
Type: BOOK - Published: 2019-06-30 - Publisher: Independently Published

DOWNLOAD EBOOK

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'
Predictive HR Analytics
Language: en
Pages: 417
Authors: Mong Shen Ng
Categories:
Type: BOOK - Published: 2018-11-27 - Publisher: Independently Published

DOWNLOAD EBOOK

You don't need to spend months learning the Python, R or SQL programming language, and you don't need to buy expensive statistical software like SPSS or SAS. Th
Predictive HR Analytics
Language: en
Pages: 537
Authors: Dr Martin R. Edwards
Categories: Business & Economics
Type: BOOK - Published: 2019-03-03 - Publisher: Kogan Page Publishers

DOWNLOAD EBOOK

HR metrics and organizational people-related data are an invaluable source of information from which to identify trends and patterns in order to make effective
Text Mining in Practice with R
Language: en
Pages: 320
Authors: Ted Kwartler
Categories: Mathematics
Type: BOOK - Published: 2017-07-24 - Publisher: John Wiley & Sons

DOWNLOAD EBOOK

A reliable, cost-effective approach to extracting priceless business information from all sources of text Excavating actionable business insights from data is a
People Analytics & Text Mining with R
Language: en
Pages: 372
Authors: Mong Shen Ng
Categories: Business & Economics
Type: BOOK - Published: 2019-03-21 - Publisher: Independently Published

DOWNLOAD EBOOK

You don't need to buy expensive statistical software like SPSS. This book teaches you R (R can be downloaded for free), People Analytics, Social Media Analytics