Mekki MOURADI

Data Analyst

Rabat, Maroc

Mekki MOURADI
mekkimouradi@gmail.com

À Propos

Data Analyst Junior avec une solide expérience en marketing numérique et des compétences approfondies dans l’utilisation de Microsoft Excel, SQL, Tableau Software et Python.

SQL Projects

Data Job Categories Analysis with SQL

Compétences & Outils

SQL
Data Wrangling

Description du projet

Utiliser SQL pour récupérer, modifier, extraire, et trier les données

Objectifs de l'analyse

Utilisez SQL pour analyser les données et répondre aux questions commerciales (nombre de postes par niveau d’expérience, top 5 des postes les plus fréquents par titre, salaire total par catégorie de poste, etc..)

Extrait du Dataset

job_titlejob_categorysalary_currencysalarysalary_in_usdemployee_residenceexperience_levelemployment_typework_settingcompany_locationcompany_sizework_year
Data DevOps EngineerData EngineeringEUR8800095012GermanyMid-levelFull-timeHybridGermanyL2023
Data ArchitectData Architecture and ModelingUSD186000186000United StatesSeniorFull-timeIn-personUnited StatesM2023
Data ArchitectData Architecture and ModelingUSD8180081800United StatesSeniorFull-timeIn-personUnited StatesM2023
Data ScientistData Science and ResearchUSD212000212000United StatesSeniorFull-timeIn-personUnited StatesM2023
Data ScientistData Science and ResearchUSD9330093300United StatesSeniorFull-timeIn-personUnited StatesM2023
Data ScientistData Science and ResearchUSD130000130000United StatesSeniorFull-timeRemoteUnited StatesM2023
Data ScientistData Science and ResearchUSD100000100000United StatesSeniorFull-timeRemoteUnited StatesM2023
Machine Learning ResearcherMachine Learning and AIUSD224400224400United StatesMid-levelFull-timeIn-personUnited StatesM2023
Machine Learning ResearcherMachine Learning and AIUSD138700138700United StatesMid-levelFull-timeIn-personUnited StatesM2023
Data EngineerData EngineeringUSD210000210000United StatesExecutiveFull-timeRemoteUnited StatesM2023

(9355×12)

  1. Number of Positions
				
					SELECT COUNT(*) AS number_of_positions
FROM jobs;
number_of_positions
9355
  1. Total Salary
				
					SELECT SUM(salary_in_usd) AS total_salary
FROM jobs;
total_salary
1406051781
  1. Number of Positions by Employment Type
				
					SELECT employment_type, COUNT(*) AS number_of_positions
FROM jobs
GROUP BY employment_type
ORDER BY COUNT(*) DESC;
employment_typenumber_of_positions
Full-time9310
Contract19
Part-time15
Freelance11
  1. Number of Positions by Experience Level
				
					SELECT experience_level, COUNT(*) AS number_of_positions
FROM jobs
GROUP BY experience_level
ORDER BY COUNT(*) DESC;
experience_levelnumber_of_positions
Senior6709
Mid-level1869
Entry-level496
Executive281
  1. Top 5 Number of Positions by Job Title
				
					SELECT job_title, COUNT(*) AS number_of_positions
FROM jobs
GROUP BY job_title
ORDER BY COUNT(*) DESC
LIMIT 5;
job_titlenumber_of_positions
Data Engineer2195
Data Scientist1989
Data Analyst1388
Machine Learning Engineer991
Applied Scientist272
  1. Total Salary by Year
				
					SELECT work_year, SUM(salary_in_usd) AS total_salary
FROM jobs
GROUP BY work_year
ORDER BY work_year;
work_yeartotal_salary
20207517399
202120977278
2022221353898
20231156203206
  1. Number of Positions by Year
				
					SELECT work_year, COUNT(*) AS number_of_positions
FROM jobs
GROUP BY work_year
ORDER BY work_year;
work_yearnumber_of_positions
202071
2021197
20221634
20237453
  1. Total Salary by Job Category
				
					SELECT job_category, SUM(salary) AS total_salary
FROM jobs
GROUP BY job_category
ORDER BY SUM(salary) DESC;
job_categorytotal_salary
Data Science and Research492493432
Data Engineering329029715
Machine Learning and AI256095957
Data Analysis157066744
Leadership and Management72514698
BI and Visualization42547918
Data Architecture and Modeling40234068
Data Management and Strategy6288243
Data Quality and Operations5530490
Cloud and Database775000
  1. Number of Positions by Job Category
				
					SELECT job_category, COUNT(*) AS number_of_positions
FROM jobs
GROUP BY job_category
ORDER BY COUNT(*) DESC;
job_categorynumber_of_positions
Data Science and Research3014
Data Engineering2260
Data Analysis1457
Machine Learning and AI1428
Leadership and Management503
BI and Visualization313
Data Architecture and Modeling259
Data Management and Strategy61
Data Quality and Operations55
Cloud and Database5
  1. Number of Positions by Work Setting
				
					SELECT work_setting, COUNT(*) AS number_of_positions
FROM jobs
GROUP BY work_setting
ORDER BY COUNT(*) DESC;
work_settingnumber_of_positions
In-person5730
Remote3434
Hybrid191
  1. Number of Positions by Company Size
				
					SELECT company_size, COUNT(*) AS number_of_positions
FROM jobs
GROUP BY company_size
ORDER BY COUNT(*) DESC;
company_sizenumber_of_positions
M8448
L748
S159
Visualisation et Dashboard Interactif des Résultats
SQL Projects