📊 Excel-Powered Salary & Skills Intelligence Dashboard

"Turning thousands of raw job postings into four career-defining answers — powered entirely by Excel."

🎛️ KPI COMMAND CENTER

💼
TOP PAYING ROLE

🔥
BIGGEST US PREMIUM

🐘
#1 IN-DEMAND SKILL

🐍
HIGHEST-PAYING SKILL

🗂️ DASHBOARD NAVIGATION

🤝
Connect

🎯 Mission Briefing

As someone who's navigated the data job market firsthand, I noticed a gap: very little structured data exists to help job seekers know what skills to learn and what salary to realistically expect.

This dashboard closes that gap — turning thousands of raw 2023 job postings into four decision-ready answers using nothing but Excel's advanced analytics toolkit.

⚙️ ANALYTICS PIPELINE

flowchart LR
    A["📥 Raw Job Postings<br/>2023 Dataset"] --> B["🔍 Power Query<br/>Extract · Clean · Transform"]
    B --> C["💪 Power Pivot<br/>Data Model"]
    C --> D["🧮 DAX Measures<br/>Median Salary · US vs Non-US"]
    D --> E["📊 PivotTables<br/>& PivotCharts"]
    E --> F["💡 Insights<br/>& Takeaways"]

    style A fill:#1a1a2e,stroke:#e94560,stroke-width:2px,color:#fff
    style B fill:#16213e,stroke:#0f3460,stroke-width:2px,color:#fff
    style C fill:#0f3460,stroke:#e94560,stroke-width:2px,color:#fff
    style D fill:#16213e,stroke:#0f3460,stroke-width:2px,color:#fff
    style E fill:#1a1a2e,stroke:#e94560,stroke-width:2px,color:#fff
    style F fill:#e94560,stroke:#1a1a2e,stroke-width:2px,color:#fff

📂 ABOUT THE DATASET — click to expand

Real-world data science job postings from 2023, including:

	Field	Description
👨‍💼	Job Titles	Data Analyst, Data Scientist, ML Engineer, Senior Data Engineer, etc.
💰	Salaries	Annual average in USD
📍	Locations	US vs. international breakdown
🛠️	Skills	Required tools and technologies per role

❓ The Four Questions

#	Question	Jump To
1️⃣	Do more skills get you better pay?	`→ PANEL 01`
2️⃣	What's the salary for data jobs across regions?	`→ PANEL 02`
3️⃣	What are the top skills of data professionals?	`→ PANEL 03`
4️⃣	What's the pay for the top 10 skills?	`→ PANEL 04`

🛠️ Tech Stack & Pipeline

	Tool	Purpose
🔍	Power Query (ETL)	Extract, clean, and load job data from raw sources
💪	Power Pivot	Build a relational data model across multiple tables
🧮	DAX	Custom measures — median salary, US vs. Non-US splits
📊	PivotTables	Slice and dice data across roles, countries, and skills
📈	PivotCharts	Combo visualizations — salary vs. skills, dual-axis views

📊 PANEL 01 — Skills vs. Pay

🔍 EXTRACT → TRANSFORM → LOAD — view the ETL process

Two clean queries were built from the raw dataset:

data_jobs_all — job-level info (title, salary, country, schedule type)
data_job_skills — skill-level rows linked by job_id

Step	Action
📥 Extract	Pulled raw data from `data_salary_all.xlsx`
🔄 Transform	Removed unnecessary columns, fixed types, trimmed whitespace, cleaned text
🔗 Load	Loaded both tables as structured, analysis-ready tables

Applied Steps — `data_jobs_all`	Applied Steps — `data_job_skills`
Loaded Table — `data_jobs_all`	Loaded Table — `data_job_skills`

💡 INSIGHT

There's a clear positive correlation between the number of skills a posting requires and its median salary. Senior Data Engineers (~8.2 skills, ~$150K) and Data Engineers (~7 skills, ~$130K) top the chart, while Business Analysts (~3.3 skills, ~$85K) and Data Analysts (~3.7 skills, ~$90K) sit lower.

🎯 TAKEAWAY: Every additional relevant skill is a measurable lever for higher pay — especially on the Senior / Engineering track.

🌍 PANEL 02 — Regional Salary Radar

A PivotTable built on the Power Pivot data model, driven by custom DAX measures comparing US vs. Non-US medians:

-- Overall Median Salary
Median Salary := MEDIAN(data_jobs_all[salary_year_avg])

-- US-Only Median Salary
US Median Salary :=
CALCULATE(
    MEDIAN(data_jobs_all[salary_year_avg]),
    data_jobs_all[job_country] = "United States"
)

Role	🇺🇸 US Median	🌍 Non-US Median	US Premium
Senior Data Engineer	$150,000	$147,500	`+$2.5K`
Machine Learning Engineer	$150,000	$101,029	🔥 `+$48.9K`
Software Engineer	$125,000	$89,100	🔥 `+$35.9K`
Data Engineer	$125,000	$123,500	`+$1.5K`
Data Scientist	$130,000	$119,550	`+$10.5K`
Data Analyst	$90,000	$90,000	`—`
Business Analyst	$90,000	$75,000	`+$15K`

💡 INSIGHT

The US premium is largest for Software Engineers (+$35.9K) and ML Engineers (+$48.9K). Senior Data Engineer pay is globally competitive — a signal of strong international demand for that role.

🎯 TAKEAWAY: Geography materially affects compensation. Remote job seekers targeting US-based companies can unlock a major salary multiplier.

🏆 PANEL 03 — Skill Leaderboard

A data model links data_jobs_all and data_jobs_skill via the job_id foreign key — a one-to-many relationship enabling cross-table analysis without VLOOKUP.

🔗 VIEW DATA MODEL & LOADED TABLES

Data Model Relationship

Loaded Data in Power Pivot

🎖️ TOP 10 SKILL RANKINGS

Rank	Skill	Demand Meter	Likelihood
🥇	🐘 SQL	`██████████████░░░░░░`	~70%
🥈	🐍 Python	`█████████████░░░░░░░`	~65%
🥉	☁️ AWS	`█████████░░░░░░░░░░░`	~43%
4	⚡ Spark	`██████░░░░░░░░░░░░░░`	~32%
5	☁️ Azure	`██████░░░░░░░░░░░░░░`	~31%
6	❄️ Snowflake	`█████░░░░░░░░░░░░░░░`	~25%
7	☕ Java	`█████░░░░░░░░░░░░░░░`	~23%
8	🐘 Hadoop	`████░░░░░░░░░░░░░░░░`	~18%
9	📨 Kafka	`███░░░░░░░░░░░░░░░░░`	~17%
10	🗄️ NoSQL	`███░░░░░░░░░░░░░░░░░`	~16%

💡 INSIGHT

SQL + Python form the non-negotiable foundation. Cloud platforms (AWS, Azure) and big data tools (Spark, Kafka) are the next layer separating competitive candidates.

🎯 TAKEAWAY: Master SQL and Python first — then layer in one cloud platform and one big-data tool to stand out.

💰 PANEL 04 — Pay vs. Demand Matrix

A combo PivotChart plotting two signals on one canvas:

Axis	Metric	Chart Type
🟦 Primary	Median Salary	Clustered Column
💠 Secondary	Skill Likelihood %	Line + Diamond Markers

This dual-axis view separates how much a skill pays from how often it's requested — two very different signals.

Skill	Median Salary	Likelihood	Verdict
🐍 Python	~$98K	~30%	💎 Best Pay
🗄️ Oracle	~$95K	~7%	🎯 Niche
📊 Tableau	~$95K	~29%	⭐ Strong
📈 R	~$93K	~17%	⭐ Strong
🐘 SQL	~$93K	~53%	👑 Best Overall
📊 Power BI	~$90K	~18%	⭐ Strong
📉 SAS	~$90K	~19%	⭐ Strong
📽️ PowerPoint	~$85K	~9%	⬇️ Weak
📗 Excel	~$85K	~41%	✅ Common
📝 Word	~$82K	~9%	⬇️ Weak

💡 INSIGHT

SQL is unique — highest likelihood (~~53%) and strong salary (~~$93K), making it the single best investment. Python pays the most while staying highly in demand. PowerPoint and Word trail on both fronts.

🎯 TAKEAWAY: SQL and Python offer the best pay-to-demand ratio. Niche tools like Oracle pay well but appear less often — good for specialization after the core stack.

📋 Workbook Structure

	Sheet	Contents
📉	`Salary_Vs_Skills`	Scatter plot — skills count vs. median salary by role
📊	`Salary_Analysis`	PivotTable — US vs. Non-US salary comparison with DAX
📈	`Skill_Job_Analysis`	Bar chart — top 10 skills by job posting likelihood
💹	`Skill_Salary_Analysis`	Combo chart — median salary + likelihood for top 10 skills

💡 KEY TAKEAWAYS BOARD

📈 MORE SKILLS = MORE PAY _{Senior Data Engineer tops both axes — most skills, highest salary}	🌍 US ROLES PAY A PREMIUM _{Especially ML Engineers (+$49K) & Software Engineers (+$36K)}	👑 SQL IS KING _{~70% demand with a strong ~$93K median}
🐍 PYTHON PAYS THE MOST _{~$98K median — highest among top 10 skills}	☁️ CLOUD IS RISING _{AWS, Azure & Spark appear in 30–43% of postings}	📉 OFFICE TOOLS DON'T PAY _{PowerPoint & Word rank last in both salary and demand}

🚀 How to Use

Step	Action
1️⃣	Download `1_Project_Analysis.xlsx`
2️⃣	Open in Microsoft Excel 2019+ (required for Power Query & Power Pivot)
3️⃣	Navigate the 4 analysis sheets via the bottom tabs
4️⃣	Use PivotTable filters (country slicer, role dropdown) to explore live

🤝 Connect With Me

Arun Pandian

AI & Data Science Graduate · Aspiring Data Analyst 📍 Coimbatore, Tamil Nadu, India

📄 License

Open for educational and portfolio reference. Dataset sourced from real-world 2023 data science job postings.

⭐ If this dashboard helped you understand the data job market, consider giving it a star! ⭐

Name		Name	Last commit message	Last commit date
Latest commit History 9 Commits
1_Project_Analysis.xlsx		1_Project_Analysis.xlsx
README.md		README.md

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

📊 Excel-Powered Salary & Skills Intelligence Dashboard

"Turning thousands of raw job postings into four career-defining answers — powered entirely by Excel."

🎛️ KPI COMMAND CENTER

🗂️ DASHBOARD NAVIGATION