Salary dashboard using Excel

533204041-1dafde73-dc5d-4235-a5b8-4f90ea3b0f87.mp4

Introduction: This data-jobs salary dashboard was created to help job seekers investigate salaries for their desired jobs and ensure they are being adequately compensated.

Dataset: I got the dataset from Luke Barousse's Excel for data analysis course, which gave me a foundation in analyzing data using Excel.

This dataset contains the following:

  1. Job titles
  2. yearly and hourly salaries
  3. Job location
  4. Skills, etc

Excel skills used:

  1. Charts
  2. Formulas & Functions
  3. Data Validations Excel Features: Utilized the bar chart feature and optimized the layout for clarity.

Design Choice: Horizontal bar charts for visual comparison of median salaries.

Data Organization: Sorted job titles by descending salaries for improved readability.

Insights Gained: Enables quick identification of salary trends.

Map Chart Excel Features: Utilized the map chart feature to plot median salaries globally.

Design Choice: Color-coded map to visually differentiate salary levels across regions.

Data Representation: Plotted median salary for each country with available data.

Visual Enhancement: Improved readability and understanding of geographic salary trends.

Insights Gained: Enables quick grasp of global salaries and highlights high and low salary regions.

Data validation: Data validation helps with implementing the filtered list as a data validation under Job Title, Country, and Type in the Data Tab

  1. User inputs are predefined, validated schedule types
  2. Incorrect or inconsistent entries are prevented
  3. Overall usability of the dashboard is enhanced.  `` 🔍 Project Conclusion This Salary Dashboard project strengthened my ability to transform raw data into actionable insights using Excel. By combining structured datasets, dynamic charts, and advanced formulas, I built an interactive dashboard that allows users to explore salary trends by job title, country, and work type with ease. Through this project, I demonstrated how Excel can go beyond basic spreadsheets and serve as a powerful analytical and decision-support tool. The use of data validation improved usability, map and bar charts enhanced storytelling, and multi-criteria median calculations delivered meaningful, real-world insights. Most importantly, this project reinforced a key principle of data analytics: 👉 clarity, accuracy, and usability matter as much as the analysis itself. I’m excited to continue building dashboards that help professionals make informed career and business decisions—and to keep sharpening my skills in data analysis, visualization, and storytelling.