Categories: Data Analytics / Power BI
Tags:

Power BI Dashboard Tutorial: Data Professionals Survey Analysis Report

Dataset Link : https://www.kaggle.com/datasets/samruddhi4040/online-sales-data?select=Details.csv

This Power BI dashboard presents a detailed analysis of responses from data professionals. It’s a great example of data storytelling using visuals to derive insights from survey data.

🔧 Dashboard Components and Layout

This dashboard is composed of nine main visual panels and filtering options on the right-hand side. Here’s a breakdown of each section:

1. Count of Employees by Job Roles

Type: Column Chart
Insight:

  • The majority of respondents are Data Analysts (381).
  • Followed by Students/Interns (90) and Others (88).
  • Less representation from roles like Data Architect, Data Scientist, etc.

✅ Use Case in Power BI: Use a Clustered Column Chart and group by Job Role.

2. Switched Careers?

Type: Donut Chart
Insight:

  • 59.05% of respondents switched careers to get into data roles.
  • 40.95% did not.

✅ Use Case in Power BI: Create a Donut Chart from a Yes/No field.

3. Distribution of Salary

Type: Bar Chart (Horizontal)
Insight:

  • Most salaries are concentrated around the $50,000 to $75,000 range (275 responses).
  • Few people report very low or very high salaries.

✅ Use Case in Power BI: Format binning or group numeric salary data into ranges.

4. Industrywise Count

Type: Column Chart
Insight:

  • Tech (205) and Other (150) industries dominate the respondent base.
  • Healthcare, Telecom, and other sectors follow.

✅ Use Case in Power BI: Use a bar chart grouped by industry.

5. Favourite Programming Language

Type: Pie Chart
Insight:

  • Python dominates (66.67%), followed by R (16.03%).
  • Other languages form a smaller chunk.

✅ Use Case in Power BI: Ideal for categorical data—use pie for proportion views.

6. Gender-wise Job Satisfaction Ratings

Type: Clustered Bar Chart
Insight:

  • Ratings on different parameters (Coworkers, Learning, Management, Salary).
  • Males and Females have very similar satisfaction levels.

✅ Use Case in Power BI: Use a bar chart with “Legend” as Gender and “Axis” as the parameter.

7. Break Into Data – Easy or Difficult?

Type: Donut Chart
Insight:

  • Responses are split:
    • 42.7% say it’s “Neither easy nor difficult”.
    • 24.76% found it “Difficult”, 21.27% “Easy”.

✅ Use Case in Power BI: Donut chart with categories like Easy, Difficult, etc.

8. Most Important for New Job?

Type: Treemap
Insight:

  • Better Salary (297 responses) is the top priority.
  • Followed by Remote Work, Work-Life Balance, and others.

✅ Use Case in Power BI: Treemap to represent priority-wise frequency.

9. Worklife Balance by Gender and Age

Type: Clustered Column Chart
Insight:

  • Visualizes how work-life balance sentiment varies by age and gender.
  • Women in the 30s and 40s report better balance than men in the same age groups.

✅ Use Case in Power BI: Clustered column chart using Age bins and Gender.

🎛️ Filters Panel

Slicers Available:

  • Ethnicity
  • Gender
  • Country
  • Education Level

✅ Use Case in Power BI: Add slicers for demographic fields to make visuals interactive.

📌 Summary: Key Learnings from This Dashboard

  • Combines multiple chart types (bar, pie, donut, treemap) for variety and clarity.
  • Provides insight at a glance with clean labels and color coding.
  • Interactive filters make the dashboard dynamic for user-specific analysis.
  • A great use of layout, with each visual answering a different business question.