Gen-Z-project-using-Excel

The "Career Aspirations of Gen Z" project is an insightful exploration into the career preferences, goals, and expectations of Generation Z.

In this project, we use 3 Functional Dashboard which is Learing Aspiration,Manager Aspiration and Mission Aspiration Dashboard which is serves as analyzing, and visualizing data using various chart ,kpi and so on.

Manager Aspirations Dashboard

This dashboard aims to analyze the respondents' preferences and willingness to work under certain conditions, such as abusive managers, remote work, and daily work hours.

Columns to Consider:

• Working Under an Abusive Manager • Remote Working • Daily Work Hours Willingness • Minimum Expected Salary (First 3 Years) • Minimum Expected Salary (After 5 Years)

Mission Aspirations Dashboard

This dashboard is designed to evaluate the respondents' clarity and alignment with their company's mission, as well as their preferences for socially impactful companies.

Columns to Consider:

• Mission Clarity in Company Evaluation • Alignment of Company Mission and Actions • Employee Preferences for Socially Impactful Companies • If you believe there are other relevant columns for this dashboard, feel free to incorporate them into your design.

The primary objectives are:

To identify the key factors influencing career choices among Gen Z.

To analyze trends in their career aspirations, such as preferred industries, work environments, and skill priorities.

To present actionable insights through clear and concise data visualizations.

Features of the Project

Data Collection: Aggregated from surveys, questionnaires, and reliable studies.

Data Analysis: Use of Excel functions like Pivot Tables, Charts, and Statistical Tools.

Visualization: Graphs, charts, and dashboards highlighting trends and key findings.

This project provides valuable insights for employers, educators, and industry aiming to better understand and engage with the emerging workforce of Gen Z.