How I analyzed Employee Record for Splendor Investment Using SQL & Excel
I carried out this analysis to show the key performances of each department in Splendor Investments using SQL and Excel.
Introduction
In this SQL project, I analyzed employee data at Splendor Investments. In this project, I work with a comprehensive dataset containing detailed information about employees within the company. My task was to leverage SQL to explore and analyze the dataset, extracting valuable insights to aid in understanding the company’s workforce better.
And this report is a guide to explore my findings and proferred solutions.
Objectives
The primary objectives of this analysis are as follows
● Analyze employee data using SQL to uncover insights.
● Transform the insights into meaningful KPIs.
● Create an interactive dashboard to visualize the KPIs.
Work Done
- Data Importation: After a careful analysis on SQL, the data was imported to excel for further exploration process.
2. Data Summarization: After importation, all analysis done on SQL are then brought on excel for further display.
The metrices from the above pictures are
- Total employees
- Numbers of departments
- Total employees gone
- Average bonus
While the business questions answered are:
- Numbers of employees in each department
- Average age of employees in the Sales department
- Top 5 highest-paid employees in the company
- Distribution of employees across different genders and ethnicities
- Average salary trend over the years
- Department with the highest average bonus percentage
- Employees who exited the company within their first year.
- Total annual salary expenditure for each business unit.
- Average age of employees in each city
- Average salary for each job title.
- Average bonus percentage between different departments.
- Number of employees who left the company and their average tenure?
- Number of employees who have been with the company for more than 10 years.
- Average bonus percentage for employees under the age of 30.
- Distribution of bonus percentages across different ethnicities.
3. Data Visualization:
Insights & Recommendations
- Insight
IT Dominance: The IT department is the largest by a significant margin, comprising nearly 28% of the analyzed workforce and highlighting a heavy organizational reliance on technical infrastructure.
Get Adebamowo Ayomide’s stories in your inbox
Join Medium for free to get updates from this writer.
Recommendation
Sales Capacity Review: Evaluate if the Sales team is understaffed relative to the massive IT support structure to ensure technical capabilities are being fully converted into market growth.
2. Insight
Support Parity: Accounting, Marketing, and HR maintain nearly identical staffing levels, suggesting a highly balanced and standardized approach to administrative and back-office operations.
Recommendation
Automation Focus: Prioritize digital transformation in leaner departments like Finance and HR to maintain operational speed without the need for immediate headcount expansion.
3. Insight
Leadership Compensation Density: The Engineering and Sales departments command the highest salary tiers, with top earners consistently exceeding the $250,000 threshold across technical and revenue-generating roles.
Recommendation
Benchmarking Consistency: Implement a cross-departmental salary review to ensure high-value roles in Human Resources remain competitive with Engineering and Sales to prevent top-tier administrative talent churn.
4. Insight
Salary Volatility: Average salaries peaked in 2014 at $125.9k and hit a decade-low in 2020, showing significant fluctuation rather than a steady upward inflationary trend.
Recommendation
Retention Analysis: Investigate the 22.6% drop in average salary between 2014 and 2020 to determine if it was caused by high-earner turnover or a shift toward hiring more junior-level staff.
5. Insight
Incentive Leadership: Accounting leads the organization in performance incentives with an average bonus of 11.83%, indicating a departmental culture that heavily rewards fiscal accuracy and compliance.
Recommendation
Standardization Review: Compare the Accounting bonus structure against other departments to ensure that high performance is being incentivized equitably across all business units.
Thank you for reading through, you can contact me to know more about this project or if you want to know more about my services.
To see my portfolio, kindly click here
And for Linktree kindly click here
