📊 Data Science Salary Analysis Project

📁 Overview

This project analyzes data science job salary data and builds an interactive dashboard using Microsoft Excel.

It covers the complete workflow from:

• Data cleaning
• Data transformation
• Data modeling
• Data analysis
• Dashboard visualization

---

🎯 Objective

The goal of this project is to:

• Understand salary trends in data jobs
• Identify high-paying roles and regions
• Discover in-demand and high-value skills
• Present insights through an interactive dashboard

---

🔄 Project Workflow

1. Data Cleaning (Power Query)

   • Cleaned and prepared raw dataset
   • Created new columns and handled missing values

2. Data Transformation

   • Processed job skills data
   • Converted unstructured data into structured format

3. Data Modeling (Power Pivot)

   • Built relationships using job_id
   • Connected salary and skills data

4. Data Analysis

   • Answered key business questions
   • Performed salary and skill analysis

5. Dashboard Creation

   • Built interactive Excel dashboard
   • Added filters, charts, and KPIs

---

📊 Key Highlights

• Used Median Salary to handle outliers
• Built interactive filters (Job Title, Country, Type)
• Analyzed skills vs salary relationship
• Identified top-paying and in-demand skills

---

📸 Dashboard Preview

---

🙏 Acknowledgement

This project is inspired by the tutorials of Luke Barousse.

I implemented this project as part of my learning to understand:

• Excel data analysis
• Power Query and Power Pivot
• Dashboard creation

Special thanks to Luke Barousse for his clear and practical teaching.