📊 Data Analyst Job Market Analysis & Salary Prediction

A complete end-to-end Data Analytics + Machine Learning + Dashboarding project that analyzes the global Data Analyst job market, salary trends, skills demand, and predicts future salary growth.

This project includes: • Exploratory Data Analysis
• Salary Prediction ML Model
• Tableau Interactive Dashboard
• Python Streamlit Dashboard

---

🚀 Project Overview

The goal of this project is to analyze real-world Data Analyst job listings to uncover:

✔ Salary trends across experience levels
✔ Most demanded skills in the market
✔ Remote vs On-site job trends
✔ Job demand by location
✔ Salary prediction using Machine Learning
✔ Interactive dashboards for business insights

---

📁 Project Structure

Data-Analyst-Job-Analysis/ │ ├── app/ ├── data/ ├── images/ ├── notebook/ ├── tableau_dashboard/ │ ├── requirements.txt ├── salary_prediction_model.pkl └── README.md

---

📊 Dataset

Dataset contains job listings with:

• Job Title
• Location / State
• Experience Level
• Salary Estimate
• Required Skills (Python, SQL, Excel, Tableau)
• Company Rating
• Remote / On-site

---

🔍 Exploratory Data Analysis

Performed in Jupyter Notebook.

Key analysis includes:

• Missing Values Check • Job Distribution • Demanded Skills • Salary vs Experience Level • Salary market concentration • Salary by State

---

🤖 Machine Learning — Salary Prediction

A regression model was trained to predict salary based on:

• Experience level
• Skills
• Location
• Industry
• Company rating

Model saved as:

salary_prediction_model.pkl

Key ML includes:

• Actual vs Predicted • Residual Plot • Feature Importance

---

📈 Tableau Dashboard

Interactive recruiter-style dashboard with 3 pages:

1️⃣ Overview Dashboard

• KPI Cards (Jobs, Salary, Growth)
• Top Job Titles
• Skill demand
• Company ratings
• Remote vs On-site analysis

2️⃣ Salary Growth & Prediction

• Salary growth trend
• Career salary jump
• Experience vs salary
• Forecast style prediction

3️⃣ Job Location Map

• Global job demand bubble map
• Salary heatmap by location

---

🐍 Python Streamlit Dashboard

A fully interactive dashboard built using Streamlit.

According to the uploaded app file, the dashboard includes:
• Sidebar filters (State, Experience Level, Salary Range)
• KPI Metrics (Listings, Avg Salary, Remote %)
• Salary distribution histogram
• Rating vs Salary scatter plot
• US Salary heatmap map
• Top Skills analysis
• Industry treemap
• Download filtered dataset feature
:contentReference[oaicite:0]{index=0}

---

⚙️ Installation & Setup

1️⃣ Clone Repository

git clone https://github.com/yourusername/Data-Analyst-Job-Analysis.git

cd Data-Analyst-Job-Analysis

2️⃣ Create Virtual Environment

python -m venv venv source venv/bin/activate (Mac/Linux) venv\Scripts\activate (Windows)

3️⃣ Install Dependencies

pip install -r requirements.txt

---

▶️ Run Jupyter Notebook

cd notebook jupyter notebook

Open:

Data_Analyst_Job_Analysis.ipynb

---

🚀 Run Streamlit Dashboard

cd app streamlit run app.py

Dashboard opens at:

http://localhost:8501

---

🧠 Skills Demonstrated

✔ Python
✔ Pandas & NumPy
✔ Data Cleaning
✔ EDA & Visualization
✔ Machine Learning
✔ Streamlit App Development
✔ Tableau Dashboarding
✔ Business Storytelling

---

💼 Business Insights

• Senior Data Analysts earn the highest salaries
• Python & SQL dominate skill demand
• Remote jobs represent a large portion of listings
• Salary strongly increases with experience level
• Certain regions show higher job concentration

---

📌 Future Improvements

• Deploy Streamlit app on cloud
• Add live job API data
• Improve ML model accuracy
• Add NLP for job description analysis

---

👩‍💻 Author

Aparna Patel