What Does Gen Z Want From Work?

An end-to-end analytics project from my internship at KultureHire, from survey design to SQL analysis to interactive Power BI dashboards.

SQLMySQLPower BIGoogle FormsSurvey ResearchDashboards

Year

2023

Context

Data Analyst Internship · KultureHire (industry experience)

My role

End-to-end: promoted the survey, cleaned data in MySQL, wrote the SQL analysis, built the dashboards, presented the findings

The Problem

Companies keep guessing what young employees want, and keep losing them. At KultureHire, the brief was to replace guesses with data: understand Gen Z's career aspirations well enough to advise real employers.

The Approach

1
Collect the data
Promoted the survey through my own LinkedIn network and Instagram as part of the intern outreach drive; the campaign gathered 3,100 completed forms from across India.
2
Load and clean it in MySQL
Imported the raw CSV/Excel exports into a database and fixed duplicates, formatting errors, and incomplete records before any analysis.
3
Answer business questions in SQL
Wrote queries for 22 specific questions, joining survey tables to break results down by gender, region, salary expectations, and work preferences.
4
Build the dashboards
One executive dashboard for the headline picture, plus three focused Power BI dashboards (learning, mission, manager aspirations) with filters by gender, country, and postal code.
5
Turn data into advice
Used the findings to analyse a real employer (TCS): connected their low compensation ratings to our survey's salary-expectation data and proposed seven concrete recommendations.