Welcome to my Power BI portfolio project! This interactive dashboard provides a comprehensive analysis of a dataset containing survey responses from data professionals worldwide. It highlights trends in salary, demographics, job satisfaction, career motivations, and more — all brought to life through insightful and user-friendly Power BI dashboards.
The dataset used in this project was publicly available and downloaded from the GitHub repository of Alex the Analyst. The dataset simulates survey responses from over 600+ individuals working or aspiring to work in data-related roles such as Data Analysts, Data Scientists, and Data Engineers.
This project was created to showcase my capabilities in data modeling, visualization, and business intelligence using Power BI. The dashboard serves as an exploratory tool to understand the work and satisfaction patterns of professionals in the data industry.
Project Objectives:
- Explore compensation patterns by age, education, and geography.
- Analyze demographics including gender, ethnicity, and role distribution.
- Understand factors influencing job changes among employees.
- Present all findings in an interactive, professional-grade Power BI dashboard.
This is a solo project that covers the entire lifecycle of a BI dashboard, including:
| Phase | Responsibility |
|---|---|
| 📂 Data Acquisition | Sourced dataset from GitHub (Alex The Analyst) |
| 🧹 Data Cleaning | Used Power Query to remove nulls, clean text, and transform columns |
| 🧱 Data Modeling | Designed relationships between tables; followed star schema principles |
| 📐 DAX Calculations | Created custom measures (averages, percentages, filters, aggregations) |
| 📊 Dashboard Design | Developed interactive visuals, slicers, tooltips, and dynamic titles |
| 🧠 Data Analysis | Derived key insights and presented user-friendly narratives |
- Power BI Desktop
- Power Query (M Language)
- DAX (Data Analysis Expressions)
- Star Schema Modeling
- Custom Visualizations & UX Design
- Gender distribution (Male vs Female)
- Age distribution and its impact on salary
- Ethnic representation of respondents
- Average salary by country (e.g., USA, UK, India)
- Salary trends across different age brackets
- Salary based on education level
- Highest level of education attained
- Popular programming languages (e.g., C/C++, Python, SQL)
- Are employees happy with their current salary?
- What factors drive them to consider switching jobs? (Better salary, culture, work-life balance, remote work)
- Role-based job count (Data Analyst, Engineer, Student, etc.)
- Time spent on flights (related to remote work preferences)
- Cross-tab analysis of salary vs demographics
- Custom visuals for storytelling
- United States respondents reported the highest average salaries.
- A significant portion of respondents were unhappy with their current salaries, highlighting career mobility.
- Better salary, remote work, and work-life balance are the top three reasons people consider job changes.
- The majority of respondents hold a Bachelor’s or Master’s degree.
- C/C++ and similar languages are still in demand, though other languages like Python may also be popular.
- Total Records: 630
- Key Columns: Age, Gender, Country, Salary, Education, Programming Languages, Current Role, Motivation to Switch, Ethnicity, Job Satisfaction
- Missing/Empty Rows: Cleaned via Power Query during data preparation
| File | Description |
|---|---|
Power BI Data Survey Analysis Dashboard.pbix |
Fully interactive Power BI file |
Power BI Data Survey Analysis Dashboard.pdf |
Static PDF version of dashboard views |
README.md |
Detailed project documentation |
To interact with the full dashboard:
- Download the
.pbixfile from this repository. - Open it in Power BI Desktop.
- Use the slicers and filters to explore insights by country, age, role, gender, and more.
✅ No data gateway or credentials required — data is embedded and cleaned within the file.
- Building a complete end-to-end BI solution using Power BI.
- Applying DAX to create powerful measures and KPIs.
- Designing visually appealing and user-friendly dashboards.
- Structuring data models using best practices for performance and scalability.
- Enhancing analytical thinking by translating raw data into actionable insights.
I chose this project for my portfolio because:
- It reflects real-world survey data scenarios relevant to my field.
- It highlights essential business questions that data professionals face.
- It allows me to demonstrate multiple skills across data wrangling, modeling, and visualization.
I'm a passionate data analyst with experience in business intelligence, data storytelling, and dashboard development. I enjoy turning data into decisions and creating tools that help others discover insights with ease.
📧 Email: lochansinghal.dba@gmail.com
If you have suggestions or feedback on the dashboard, feel free to open an issue or connect with me. I'm always open to learning and growing in this space!
🧑💻 Created with curiosity and care — by [Analyst - Lochan]