{"product_id":"predictive-hr-analytics-text-mining-organizational-network-analysis-with-excel-paperback-1","title":"Predictive HR Analytics, Text Mining \u0026 Organizational Network Analysis with Excel - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eMong Shen Ng\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003ePredictive HR Analytics, Text Mining \u0026amp; 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 \u0026amp; you don't need to buy expensive SPSS statistical software. This is the \u003cb\u003eonly book that teaches you how to use Microsoft Excel for Predictive HR Analytics, Text Mining \u0026amp; Organizational Network Analysis (ONA)\u003c\/b\u003e with step-by-step print-screen instructions: \u003cbr\u003e\u003cb\u003e1) Predictive HR Analytics: \u003c\/b\u003e Use Excel's Statistical Analysis tools (Decision trees, Correlation, Multiple \u0026amp; Logistic Regression) to run Predictive HR Analytics. You will learn how to predict Ethnic \u0026amp; 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.\u003cbr\u003e\u003cb\u003e2) Organizational Network Analysis (ONA): \u003c\/b\u003e Run ONA using Excel's network analysis tool. Learn how to convert an employee's organizational network into a score \u0026amp; 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\" \u0026amp; \"Competency Score\" is \"8\". \u003cbr\u003e\u003cb\u003e3) Text Mining, Sentiment Analysis \u0026amp; Word Clouds: \u003c\/b\u003e Mine text from social network posts, employee engagement surveys \u0026amp; Glassdoor comments, then run Sentiment Analysis using Excel \u0026amp; 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\".\u003c\/p\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 502\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 1.01 x 9.25 x 7.5 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e June 30, 2019\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":47212235948281,"sku":"9781077226906","price":67.5,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0789\/2782\/3097\/files\/Mm9QRWVRK3poUTlsS1BBU3pKQVdXQT09_cf199ca6-9b09-492d-9d1e-5c7027c21a4c.webp?v=1768088339","url":"https:\/\/bookscloud.io\/products\/predictive-hr-analytics-text-mining-organizational-network-analysis-with-excel-paperback-1","provider":"BooksCloud Book Dropshipping","version":"1.0","type":"link"}