Understanding the Career Aspirations of Gen-Z

Project Overview

This project uses prescriptive analysis to explore the career aspirations of Generation Z. It combines SQL for detailed data querying and Power BI for creating interactive visualizations. By analyzing data from surveys, social media, and industry reports, we identify trends and provide actionable recommendations for educators and employers to better support Gen-Z in their career development.

Objectives

• Analyze career goals and aspirations of Gen-Z.
• Identify key trends in preferred industries and job roles.
• Utilize SQL to answer specific business questions and derive detailed insights.
• Create interactive visualizations using Power BI to communicate findings effectively.
• Provide actionable recommendations to enhance support for Gen-Z career development.

Data Collection

• Surveys and Questionnaires: Data collected on career preferences and goals from Gen-Z individuals.
• Social Media Analysis: Insights gathered from platforms such as LinkedIn and Twitter.
• Industry Reports: Data from reports and research on job market trends and Gen-Z preferences.

Methodology

1. Data Cleaning and Preparation: Ensure data accuracy and consistency.
2. SQL Analysis: Use SQL queries to extract and analyze relevant data, answering specific business questions.
3. Exploratory Data Analysis (EDA): Uncover trends and patterns in the data.
4. Power BI Visualization: Develop interactive dashboards and visualizations to present findings.
5. Prescriptive Analysis: Generate actionable insights and recommendations.

Dashboard and Visualizations

Interactive dashboards and visualizations are available to view key findings and recommendations

Results

• Preferred Industries: Breakdown of the most desired industries by Gen-Z.
• Top Job Roles: Analysis of the most sought-after roles.
• Career Trends: Emerging trends in Gen-Z career aspirations.
• Support Strategies: Recommendations for educators and employers to support Gen-Z career development.

How to Use

1. Access the interactive dashboard via the link above.
2. Review the findings and recommendations detailed in the project documentation.
3. Implement the recommendations to enhance career support strategies for Gen-Z.