This project involves a comprehensive cleaning and analysis of a dataset, using Microsoft Power BI to identify trends, key performance indicators (KPIs), and demographic insights. The primary focus was to preprocess the data for analysis and create various visualizations to uncover insights about career switching, salary distribution, preferred programming languages, and other aspects of the dataset.
The project starts with cleaning and preparing data in Power BI, followed by creating various visualizations to uncover meaningful patterns. The goal was to make data-driven insights accessible and understandable, focusing on user demographics, job satisfaction, and key career metrics.
The initial step involved examining each column to decide whether any data needed removal or correction. This helped streamline the dataset and ensure only relevant information was retained.
Each column's data type was checked for consistency to prevent issues during visualization and analysis.
To simplify and make data more usable, certain fields were split using delimiters.
Blank values were filled with approximate values to ensure completeness and continuity in analysis.
A new column was created to indicate whether a respondent had switched careers. A value of 1 represents "Yes" for career switching, and 0 represents "No." The average value was measured to calculate the percentage of career switchers.
KPI cards were generated to display average values and other essential metrics, providing an at-a-glance view of important figures.
A stacked bar chart was used to illustrate salary ranges across various job titles, revealing insights into compensation across roles.
To understand the respondents' preferred programming languages, a stacked column chart was used to highlight popularity by language.
Gauge charts were implemented to show satisfaction levels related to work-life balance and salary, allowing for a quick view of overall job satisfaction.
The distribution of survey respondents by country was visualized using a tree map, making it easier to see the regional representation in the dataset.
A donut chart was created to analyze the perceived difficulty levels within the dataset, helping to understand user experiences in the field.
The final step involved polishing the dashboard to ensure clarity and readability. Headers were added for structure, and chart designs were refined.
In this analysis:
- Career Switching: A significant portion of respondents are switching to data-related careers, often reporting moderate job satisfaction.
- Programming Language Preferences: Python stands out as the most popular language, possibly due to its ease of use.
- Age Demographics: The majority of respondents are in their late 20s.
- Difficulty Perception: Respondents generally found data-related jobs to be moderately challenging.
- Popular Job Roles: Data Analyst roles were the most common among survey participants.
This project highlights trends and preferences in the data field, providing valuable insights for anyone interested in understanding the current landscape of data-related careers.