Tool Used : Power BI
Datasource : Excel
Steps : Import from Excel -> Clean Data->Data Modelling using DAX
Key Insights:
1)Total Head Count Increased from 157 in 2018 to 239 in 2019 and 346 in 2020.
2)Total Employee Expense increase from 15M in 2018 to 24M in 2019 and 36M in 2020.
3)Company have more number of FTE as compared to contract employees in 2018,19 and 2020
4)New Hire count increased from 79 in 2017 to 82 in 2018 and 86 in 2019.
5) Major proporation of company heacount are female employees