This project explores the career aspirations of Generation Z and was assigned me to complete this during my internship with KultureHire, analyzing a comprehensive survey dataset to understand their preferences, goals, and challenges in the workforce. The insights gained aim to inform educational institutions, employers, and policymakers about the expectations and needs of this emerging workforce.
The dataset consists of 100,580 rows and 29 columns, including attributes such as:
- Age: Age of the respondents
- Education Level: Highest level of education attained
- Field of Interest: Preferred career fields
- Salary Expectations: Expected salary in their chosen field
- Work Preferences: Preferences for remote work, work-life balance, etc.
- Skills Assessment: Self-assessed skills relevant to their career choices
- Top Career Fields: Technology, Healthcare, and Creative Arts are the most sought-after fields.
- Salary Expectations: Over 60% of respondents expect a salary of $50,000+ annually.
- Work Preferences: 75% prefer flexible working arrangements to traditional office settings.
- Data Collection & Cleaning: Analyzed the survey dataset focusing on data collection, cleaning, and standardization using Excel and SQL.
- Exploratory Data Analysis (EDA): Examined trends and patterns to extract meaningful insights.
- Dashboard Development: Developed both executive and functional dashboards using Power BI to present findings effectively.
The Learning Aspirations Dashboard offers insights into the personal development goals of individuals within the organization. It visualizes data related to preferred learning methods and areas of interest. 📈
The Manager Aspirations Dashboard highlights the development goals and mentorship interests of managers within the organization. 🌱
The Mission Aspirations Dashboard showcases how individual and team goals align with the organization’s mission and vision. 🌍
- Excel: For data cleaning and initial analysis
- SQL: For data manipulation and analysis
- Power BI: For creating interactive dashboards
- MySQL: For advanced data analysis
- Google Forms: For data collection
- MS Office Suite: For documentation and presentations
This project provides comprehensive dashboards to help the organization track and analyze various aspirations. The interactive nature of these dashboards enables users to gain actionable insights and support strategic decision-making. 🏆
For any inquiries or support, please reach out to:
Name: Mayank Yadav
Email: mayanky075@gmail.com
LinkedIn: LinkedIn Profile
Feel free to connect for discussions, collaboration opportunities, or feedback!