Data Professional Survey Dashboard

Objective

By extracting insights from the survey data, the objective of understanding the landscape of the data profession and identifying key trends and patterns has been achieved. The analysis provides valuable insights into the demographics, salary trends, job satisfaction levels, and industry preferences of data professionals.

Dataset

The dataset used for this analysis is sourced from Kaggle Data Professional Survey dataset, comprising responses from data professionals regarding various aspects of their roles, including salary, job satisfaction, industry, and tools usage.

Steps Undertaken

1. Setting Objectives:

   • Clarified the scope and objectives of the dashboard to analyze survey responses from data professionals.

2. Data Collection and Exploration:

   • Obtained the survey dataset from Kaggle, encompassing responses related to salary, job satisfaction, industry, and tool usage.
   • Conducted exploratory data analysis (EDA) to understand the distribution of responses and uncover insights into trends and patterns.

3. Data Cleaning:

   • Imputing missing values using mean, median, mode, and correlation techniques.
   • Handling outliers by either removing them or applying appropriate transformations.
   • Deleting null values.
   • Changing formats as necessary.
   • Encoding categorical variables.

4. Metric Development:

   • Utilized Power BI Desktop and Data Analysis Expressions (DAX) to create key performance indicators (KPIs) such as average salary, job satisfaction scores, etc.

5. Dashboard Creation:

   • Developed an interactive dashboard using PowerBI to present insights into survey responses. The dashboard includes visualizations, filters, and slicers for enhanced exploration and understanding.

Installation/Usage

To access the Data Professional Survey Dashboard:

1. Install Power BI Desktop: Download and install Power BI Desktop from the official Power BI Download Site.
2. Download Dataset: Download the dataset from the link provided in the Dataset section.
3. Clone or Download this Repository: Clone or download this repository to your local machine.
4. Open Dashboard: Open the dashboard report file (Data-Professional-Survey-Dashboard.pbix) in Power BI Desktop to access & explore the interactive dashboard's features.

Questions

1. What is the gender distribution among the respondents?
2. What is the average salary of data professionals?
3. What is the average age of the respondents?
4. Which job role commands the highest average salary?
5. Which education level correlates with the highest average salary?
6. What is the most commonly used data tool among respondents?
7. Which industry offers the highest average salary for data professionals?
8. What is the average job satisfaction rating for salary among respondents?
9. What is the perceived difficulty of entry into the data field according to the respondents?
10. What percentage of respondents find the work-life balance satisfactory?

Dashboard

Conclusion

In conclusion, the Data Professional Survey Dashboard offers valuable insights into the experiences and perspectives of data professionals. By analyzing survey responses, this project explores various aspects such as salary trends, job satisfaction levels, industry dynamics, and the most commonly used tools among professionals in the field. These findings help paint a clearer picture of the data profession's landscape, contributing to a better understanding of the challenges, opportunities, and patterns that shape this growing and evolving field.