An Introduction to HR and People Analytics in Excel
"What Can Employee Salaries Tell Us About a Company" is a comprehensive video course tailored for HR and Finance professionals keen on mastering salary analysis through Excel. This course equips you with strategies to efficiently structure and analyze employee salary data, enabling you to craft detailed analyses and presentations from your findings.
We begin with an intriguing scenario: "What insights about a company can be drawn from employee salaries in just 60 minutes?" Starting with basic descriptive statistics, we cut into advanced analyses, including the Lorenz Curve, Gini Ratio, and Palma Index. These tools help us explore salary equity within a company, shedding light on the company's structure. Is it hierarchical or flat? Does pay distribution suggest inequality between top earners and the broader employee base? We'll discuss whether to use mean or median salary as a representative figure, identify outliers, and interpret the distribution of the salary data histogram.
Whether you're an HR professional venturing into data analysis or a seasoned analyst looking to broaden your expertise with employee data, this course serves as an ideal introduction to People Analytics.
Included with the course are two Excel files, an opening file with the raw salaries and a complete file with all analysis and presentation insights. You can use the complete file to follow along with the video instructions or build the analysis yourself using the opening file. Plus, there is a final quiz to test your understanding of the concepts and Excel functions introduced in this course.
College Teacher in HR and People Analytics
I have always woven teaching into my professional journey, starting with consulting engagements across Canada and the United States before moving into academia. With a combined 40 years of experience in teaching data and analytics, my career has been rich and varied. At CPA Canada, I created IT course materials and devised several hundred multiple-choice questions for exams, in addition to publishing numerous articles on data in business IT publications. The advent of AI and machine learning, alongside the development of environments like RStudio, marked a pivotal moment in data analysis, transitioning from merely descriptive to advanced predictive analytics. This shift transformed the role of data in business and ignited my interest in how data can enhance human resources practices. At the college level, I developed two courses for HR graduate certificate students, focusing on leveraging people data to gain deeper insights into employee dynamics. Throughout my academic career, I have co-authored four papers, contributing the data analysis and interpretation sections. I am thrilled to share my insights and techniques with HR and other interested professionals on this platform. Whether you're new to working with people data or looking to enhance your existing skills, I hope to guide you through the fascinating world of data analytics in HR.
This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.
If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.
