Project Overview

In this project, I performed an in-depth analysis on a dataset representing anonymized employee data to identify factors influencing salary. This blind analysis, conducted for an auditing client, required inferring data labels, understanding industry implications, and predicting salary determinants.

The analysis focused on:

• Renaming columns based on inferred data meanings.
• Conducting descriptive, correlation, and regression analyses to understand salary impact factors.
• Providing actionable recommendations for salary policy improvement.

This project showcases skills in statistical analysis, data interpretation, and executive reporting for real-world business insights.

Technologies Used

• SPSS: Statistical analysis and regression modeling
• Excel: Data cleaning, organization, and descriptive statistics
• Microsoft PowerPoint: Presentation and executive summary visualization
• Microsoft Word: Executive report creation

Repository Structure

• Data/: Contains the dataset file (Salaries.csv).
• Analysis/: Final report and presentation slides:
  • Executive Report - Stefano Compagnone.pdf: A 1-page report summarizing findings.
  • Individual assignment final (Stefano Compagnone).pptx: Presentation slides with insights and recommendations.

Key Insights

• Gender Pay Gap: Women earn approximately $2,000 less than men, underlining a gender disparity in salary policy.
• Education Impact: Each additional year of education increases salary by approximately $502.
• Entry Salary Influence: Initial salary has a strong positive correlation with current salary, indicating salary growth for long-term employees.
• Position Level: Higher-level positions are associated with significant salary increases, supporting a structured career progression within the company.

Instructions

1. Clone this repository.
2. Review the Data/ folder for the dataset (Salaries.csv).
3. Open Executive Report - Stefano Compagnone.pdf for a summary of findings.
4. Refer to Individual assignment final (Stefano Compagnone).pptx for an in-depth presentation.

Contact

Connect with me on LinkedIn for more information or explore my other projects on GitHub.