Author: Sahil Lodhi
🔗 LinkedIn • 🔗 GitHub
DataBucks is a data visualization project built using Microsoft Excel, designed to help job seekers, data professionals, and HR analysts explore salary trends across the data job landscape.
It brings together salary insights, job types, and geography-based trends into an interactive dashboard to support career decisions.
This dashboard was created as part of my Excel learning journey and emphasizes real-world, visual-first storytelling using foundational Excel skills.
This short walkthrough shows how users interact with the dashboard, filter data, and extract salary insights based on job title, country, and work type.
| Area | Key Work | Excel Techniques |
|---|---|---|
| 📊 Salary Analysis | Explore median salaries by job title & geography | Bar charts, map charts |
| 🧠 Skill Trends | Understand the influence of job types and locations | Data validation, formulas |
| 🎯 Interactivity | User-driven dashboard filtering | Dropdowns, dynamic tables |
| 🧮 Calculations | Derive insights using logic-based formulas | MEDIAN(), IF(), SEARCH(), FILTER() |
- 📈 Charts – Bar chart for job titles & map chart for countries
- 🧮 Formulas – Array formulas to calculate filtered median salaries
- ❎ Data Validation – Dropdown filters for clean, interactive selections
- Senior Roles and Data Engineers tend to have the highest median salaries.
- Geographic trends show wide variation — with some countries offering notably higher compensation for similar roles.
- Job schedule type (full-time, contract, etc.) plays a role in salary variation.
- Microsoft Excel
- Bar Charts, Map Charts
- Array Formulas (
MEDIAN,IF,SEARCH,FILTER) - Named Ranges & Data Validation
- Data Source: 2023 real-world dataset (provided via Excel course)
- How to create interactive dashboards using core Excel features
- Translating raw job data into actionable salary insights
- Implementing clean UX design in Excel with dropdowns and layout techniques
- Making data visualizations that support career-related decision-making
✅ Project Complete
🎯 Ready for portfolio, demo, or showcasing Excel visualization skills
📂 Clean structure and working file included (Salary Dashboard for Data Jobs.xlsx)
Sahil Lodhi
Aspiring Data Analyst | Excel • Tableau • Python • SQL
🔗 LinkedIn
🔗 GitHub