Predictive HR Analytics, Text Mining Organizational Network Analysis with Excel

Mong Shen Ng

A practical, do-it-yourself guide showing HR professionals how to run predictive analytics, text mining, sentiment analysis, and organizational network analysis entirely in Microsoft Excel to drive better business decisions.

This is the only book that teaches Predictive HR Analytics, Text Mining, and Organizational Network Analysis using tools you already own and know—Microsoft Excel and free add-ins—without months of learning R or buying expensive SPSS software. Through step-by-step print-screen instructions, it walks you from defining a business problem through the ARHAT framework, gathering and analyzing data with decision trees, correlation, multiple and logistic regression, mining unstructured text into word clouds and sentiment scores, and mapping employees' social networks into measurable centrality metrics. Packed with real-world case studies (Best Buy, Nielsen, Xerox, HP, Hilton, JetBlue) and dozens of HR metrics, it shows you how to predict attrition, performance, engagement's impact on sales, diversity's impact on EBIT, and workplace accidents—and crucially, how to translate those findings into an engaging data story that drives change.

The model it argues

A causal model in which HR design levers and contextual conditions (compensation, training, diversity practices, network position, demographics, sentiment) influence psychological and behavioral states (engagement, job satisfaction, flight risk) that in turn drive organizational outcome metrics (attrition, performance, sales, EBIT, safety incidents). The analytics process itself (ARHAT framework + storytelling) is the meta-lever that surfaces these relationships.

Key ideas

Employee Engagement: The emotional commitment and discretionary effort employees give to their work and organization.
Compensation Competitiveness: How an employee's pay positions against external market and internal salary ranges.
Training & Development Investment: The extent and effectiveness of learning opportunities provided to employees.
Diversity & Inclusion: Workforce compositional variety plus inclusive practices giving equal opportunity.
Organizational Network Position: An employee's structural importance within the organization's social network.
Employee Demographics & Context: Background and situational attributes conditioning employee behavior.
Personality Traits: Stable dispositions predicting work behavior and performance.
Employee Sentiment: The polarity of opinions expressed in employee and candidate text.