If you're keen to delve deeper into the dataset, we recommend checking out the README file available here.
Here’s a glimpse of the dashboard:
To ensure that users do not unintentionally alter the dashboards, both the worksheet and workbook have been locked. Rest assured, this will not affect your user experience. However, if you wish to explore the underlying workings and need access to unlock them, please use the following password:
excel
This dashboard is designed to assist job seekers in data-related fields by providing a quick analysis of the job market. It highlights key metrics such as expected salaries and job benefits. The primary audience for this tool includes job seekers with specific goals, such as:
- The position they are applying for
- Desired work schedules
- Preferences for remote opportunities
For those who prefer a broader view, I recommend exploring the second dashboard, which offers a more comprehensive and up-to-date analysis of the job market without any filters.
To effectively utilize this dashboard, users should possess the following skills:
- Basic Excel Skills
- Formulas
- Charts
- Data Validation
- And more
For instance, if I am a Data Analyst seeking full-time remote roles in the United States, this dashboard will help me answer critical questions such as:
What salary can you expect based on different pay structures (hourly, yearly, and standardized yearly from hourly rates)?
Standardized Salary
Yearly Salary
Hourly Salary
How many jobs match your criteria (e.g., Data Analyst, full-time, remote), and which platform lists the highest number of relevant jobs?
Job Count & Best Job Platform
What is the distribution of available jobs across different pay schedules (hourly, monthly, yearly)?
Pay Schedules
What are the probabilities of receiving various benefits (e.g., paid time off, health insurance) based on your selected filters?
Benefits
Which months in 2024 had the highest number of job postings? Additionally, which days of the week saw the most job postings?
Monthly Trends
Weekly Trends
Here’s a glimpse of the dashboard:
To ensure that users do not unintentionally alter the dashboards, both the worksheet and workbook have been locked. Rest assured, this will not affect your user experience. However, if you wish to explore the underlying workings and need access to unlock them, please use the following password:
excel
This dashboard is a step up from a basic dashboard, designed with both job seekers and data explorers in mind.
- For Job Seekers: The dashboard offers enhanced flexibility through advanced filters powered by slicers, making it easy to customize and refine your search. For instance, if you're interested in both Data Analyst and Business Analyst roles, you can seamlessly explore both without the complexities posed by the previous tech stack.
- For Explorers: The versatility in filtering options allows for unrestricted exploration, empowering users to delve into any area of interest effortlessly.
To maximize the potential of this dashboard, users should be proficient in the following skills:
- Power Tables
- Pivot Tables
- Power Query
- DAX (Data Analysis Expressions)
- M-Language
- Pivot Charts
- And other advanced data analysis tools and techniques.
Assuming the same scenario as the basic dashboard—Remote, Full-Time Data Analyst Jobs in the U.S., this advanced dashboard addresses additional critical questions to provide deeper insights (for a more detailed understanding, it is recommended to download the dashboard). Here are some of the key questions answered:
This insight highlights the top skills based on factors like median salary and the percentage of jobs requiring these skills.
In-Demand Skills
This provides clarity on the breadth of skills expected for different roles, helping users understand hiring trends.
Skill Count