What Can Employee Salaries Tell Us About a Company?

"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.