A dynamic and interactive Excel dashboard designed to analyze salary data across various job titles, countries, and platforms. This tool provides insights into salary distributions, median salaries, and job market trends by comparing data from popular platforms like LinkedIn, Indeed, and others.
- Salary Analysis by Job Title & Country: Easily compare salary data for different job roles across multiple countries.
- Median Salary Calculation: View the median salary for each job title, helping you understand industry standards.
- Platform Comparison: Identify which job platforms (LinkedIn, Indeed, etc.) have the most job listings for each role.
- Interactive Charts & Metrics: Visualize key data points with dynamic charts and summary metrics.
- Trends & Insights: Track salary trends over time and get insights into the job market for each job title.
- HR Professionals: Quickly assess salary trends and compare compensation packages across different regions and job platforms.
- Job Seekers: Understand salary expectations based on location and role, helping you make informed career decisions.
- Data Analysts: Leverage the dashboard for salary data analysis and trend forecasting.
- Microsoft Excel (preferably Excel 2016 or later) for full functionality.
- Basic understanding of Excel charts and data analysis.
- Download the Excel file from this repository.
- Open the file in Excel.
- Explore the various sheets and charts:
- Salary Overview: Displays overall salary data and key metrics.
- Job Platform Comparison: Shows the number of job listings by platform.
- Salary Distribution: Visualizes salary ranges and medians by job title and country.
- Use the filters to select different job titles, countries, or platforms to tailor the analysis to your needs.
- Charts: Interactive charts allow you to see trends, salary distributions, and comparisons.
- Filters: Use Excel's built-in filters to focus on specific job roles, countries, or platforms.
- Data Updates: The dashboard can be updated with new salary data by importing new datasets into the relevant sheets.
For any questions or feedback, feel free to reach out via GitHub Issues or email.