Data Analysis Job Openings Analysis Project

Introduction:

• Purpose: Analyze job openings data from online platforms.
• Scope: Focus on trends, in-demand skills, and salary insights.

Project Structure:

• dataset: Contains datasets in CSV format.
• project_sql: SQL queries for analysis.
• db_setup: Setting the database and the tables.

Data Description:

• company_dim.csv: Company dimension details.
• job_postings_fact.csv: Facts about job postings.
• skills_dim.csv: Skills dimension data.
• skills_job_dim.csv: Mapping of skills to job postings.

Database Diagram:

created using this tool!.

SQL Queries:

• Q1_top_paying_jobs: Identifies highest paying jobs.
• Q2_in_demand_skills: Analyzes skills in high demand.
• Q3_top_paying_skills: Examines top paying skills.
• Q4_optimal_skills: Finds the optimal skills high pay and high demand.

Aknowledgment:

• The dataset is scraped and cleaned by Luke Barousse related to his SQL course.
• Resources used to study SQL:
  • Luke Barousse SQL course.
  • Freecodecamp's Intuitive SQL for analytics.
  • PostgresSQL documentation.
  • Various other resource.