Human capital is an organization’s most important asset. Without the knowledge and skills of people, an organization can accomplish nothing. The acquisition, development, and retention of critical talent has become increasingly more complex and challenging, and organizations are making significant investments to gain a deeper, data-informed understanding of organizational phenomena impacting the bottom line. This book prepares current and aspiring analytics professionals to effectively address this need by curating key concepts spanning the entire analytics lifecycle, along with step-by-step instructions for their applications to real-world problems, using ubiquitous and freely available open-source software.This book provides learners with the ability to:• Design and conduct empirical research• Query and wrangle data using SQL• Profile, clean, and analyze data using R• Apply appropriate statistical and ML models to a range of people analytics use cases• Package and present analyses to communicate impactful insights to stakeholders

OrgAcuity is a B2B SaaS company making advanced people analytics accessible to all organizations. Our integrated platform combines people analytics and employee listening, translating data into engaging stories and delivering tailored recommendations directly through managers' everyday channels.

- Set the people analytics strategy and roadmap, including the implementation of One Model (data infrastructure) and Qualtrics (candidate and employee listening)- Supported Robinhood's IPO and significant workforce growth by leveraging data and analytics to optimize org designs and recruiting productivity- Implemented a federated analytics model to drive impact at scale and hired Robinhood’s first people analytics team organized within three pillars: (1) Business Intelligence & Consulting, (2) Research & Data Science, and (3) Data Management & Governance

- Led a significant effort to address a highly fragmented org structure and centralize 15 geographically dispersed people data and analytics resources within a single COE under my leadership- Defined the global strategic roadmap for people analytics, including the design and build of a best-in-class Workforce Intelligence Platform to support use cases spanning descriptive, diagnostic, and predictive analytics, as well as ONA, workforce planning, and A/B testing- Drove standardization and automation across core reports and dashboards to create space for more valuable consulting engagements with business partners- Provide thought leadership on how best to address people questions and challenges with data and analytics- Responsible for ensuring all repositories of HR data have consistent, structured and aligned data models for organized relational elements and an optimal data warehousing platform/access model- Drive continual improvement in data management practices and identify ways to standardize and automate analytical solutions to enable scaling and enforce HR function-wide data quality as aligned with broader business standards

- Developed both an on-ground and online graduate-level Business Analytics course, which I regularly taught- Taught Statistics & Quantitative Analysis in the MBA and M.S. in Finance programs

- Built a team of data scientists, engineers, and analysts that designed and developed innovative customer-facing talent solutions to aid organizations in making data-driven decisions about their workforce- Player-coach within a highly matrixed environment, collaborating closely with Product Management, Sales and external customers to ensure priorities are aligned with market demand and enable significant revenue opportunities- Regularly consulted with HR leaders in client organizations to translate results of analyses into actionable insights and quantify the impact of changes on talent and financial performance- Leveraged vast data assets to understand labor supply and demand by geography, industry and job, and generate insights around compensation, retention, and turnover that compare an employer to business and talent competitors- Managed a R&D and innovation pipeline leveraging customer insight, disparate data sources, and advanced analytics

- Pioneered a people analytics capability with limited budget, whose accomplishments won two hiQ Elevate People Analytics awards accepted alongside winners from Google, LinkedIn, and others at Intel’s HQ in Santa Clara, CA- Functioned as a change agent and champion for people analytics, building relationships with key business stakeholders to translate complex workforce challenges and questions into viable projects- One of 25 managers enterprise-wide nominated by senior leadership for a one-year leadership development program- Built and maintained executive dashboards that related HR KPIs to business outcomes and regularly presented insights to the Executive Leadership Team- Built predictive models to identify drivers of voluntary attrition by job profile to inform major action plans- Led the enterprise employee engagement program, including the transition from an annual survey to quarterly pulses- Led integrations, data conversion, and reporting workstreams to complete a Workday HCM deployment in six months

- Supported residential mortgage default management initiatives by acquiring new data sources for use in models predicting the probability of prospective borrowers defaulting on loans in order to promote more conservative lending practices following the financial crisis- Responsible for goal-setting, performance evaluations, training and development, and the assignment and coordination of work among eight geographically dispersed direct reports- Developed and facilitated U.S. Bank’s First Time Leader program, implemented to develop newly promoted managers

- Designed, developed, tested, optimized, deployed, and automated ETL processes within two-week Agile sprints, which involved integrating data from HR applications, SalesForce, third party loan origination, processing and servicing systems, and various SQL Server, Oracle, and DB2 database sources for consumption by the data warehouse and other consuming applications and reporting groups- Responsible for architecting the technical design for mortgage data integration initiatives and articulating the approach for project stakeholders- Responsible for incident metrics and SLA reporting to deliver quantitative trends and qualitative depth in order to identify reoccurring issues and inform the implementation of measures to address them- Functioned as the data integration architect and development lead on a Top 10 USB project, Residential Mortgage Consolidation. This involved launching a new application to house loan servicing data, for which I routinely led design sessions and touch point meetings, delegated assignments to developers, provided training to the team tasked with production support responsibilities, created and configured new Informatica repositories and integration services, and scheduled and automated data integration processes.

- Lead developer for a chronic care management application that was leveraged to monitor members with serious medical conditions and reduce catastrophic claims by proactively alerting them of measures to promote wellbeing- Scheduled and coordinated the automation of Informatica workflows, DDL and DML changes, and the individual assignments of engaged developers- Redesigned nightly and monthly ETL batch processes by which flat files had historically been processed via bulk copy to one in which SQL Server views were utilized to address incidents due to the late delivery of files- Collaborated regularly with several teams within the organization to gain clarity on requirements, ensure business needs were satisfied, and complete testing in a thorough and timely manner- Led monthly staff meetings in which to discuss upcoming projects and reporting needs, progress on current initiatives, and plans to address production issues and shortcomings

- Worked closely with analysts and department leaders across the organization to gain a deeper understanding of their unique business challenges and goals and help construct and optimize SQL queries to surface relevant insights- Led several migration initiatives warranted by acquisitions of smaller health insurers, which involved conducting training sessions to educate data warehouse users on how to access medical and pharmacy claim data for the combined organization post-conversion and communicate key milestones to stakeholders through both cross-functional meetings and electronic publications with significant readership- Developed and implemented two VBA applications for temporary table tracking and data warehouse course scheduling