
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.
