Project information
- Project Name: Employee Survey Insights
- Tools: Python, Excel, SQl, Power Bi
- Techniques Used: Python Pandas, XLOOKUP, Conditional Formatting, Visualization
- Project URL: : GitHub Link
Project Details
• Leveraged Python's Pandas library, SQL queries, and Excel functions to meticulously clean and prepare a complex employee dataset. This included handling missing values, removing outliers, and ensuring data consistency.
• Constructed a compelling Power BI dashboard showcasing key employee metrics, including average salary by job title and gender, work-life and salary satisfaction, popular programming languages, and employee location.
• Demonstrated proficiency in using data analytics tools to diagnose and solve data quality issues. This ensured the creation of a reliable and insightful Power BI dashboard for better workforce understanding.