Data Market | Notion

<aside> 🎯 This project provides an analysis of the European job market using a dataset of job offers.

</aside>

Dataset

The dataset has been provided by Luke Barrousse inside his SQL course.

Each job offer is a unique entry, focusing on key aspects such as top skills, top companies, top countries from both remuneration and demand perspectives, and the monthly fluctuation of job offers for remote and office positions.

The dataset contains information about job postings, including the columns listed below:

Column	Description
Job ID	Unique identifier for each job offer
Job Title	Title of the job being offered
Company Details	Information about the company offering the job
Country	Country where the job is located
Salary Information	Salary details for the job, including currency conversion to €
Skills Required	List of skills needed for the job
Posting Date	Date when the job was posted
Work Location	Specifies if the job is remote or office-based

Objectives

Filtering the dataset on European countries
Identifying top European countries with the most job offers.
Determining the most in-demand skills for Data Analysts in Europe.
Finding the optimal skills to learn for high demand and high pay.
Examining the monthly distribution of job postings.

Deliverables & Queries

<aside> 💡 Key Takeaway:

In 2023, UK, France, Germany, Spain and The Netherlands were the European countries offering the most Data Analyst job offer on the market.
As expected, SQL, Python, are the most in demand skills on the European Job Market, followed by Excel, Power BI and R.
Niche software brings more revenue but fewer demands. Among them, the one focusing on AI/ML learning are providing the highest salary.
There is a monthly job posting fluctuation, with peak demand typically in January and dips in April/May. </aside>

To conclude: Data Analyst roles in Europe offer diverse growth opportunities. While essential skills are crucial, focusing on technical expertise or business analysis can shape career advancement effectively.