/Glassdoor-Data-Science-Job-Posts-Analysis-Using-Excel

🔍 Analyze data science job posts from Glassdoor! Cleaned using Excel, explore common job titles, salary trends, and required skills. Uncover insights to ace your job search! 📊💼 #DataScience #JobMarket #GlassdoorAnalysis

Glassdoor Data Science Job Posts Analysis

About the Dataset

This dataset contains information about data science job postings scraped from Glassdoor. The original data was uncleaned and then cleaned using Power Query in Excel. Various transformations and cleaning processes were applied to make the data suitable for analysis.

Guiding Questions

  1. Can you make the salary column into integers?
  2. What information can you extract out of job descriptions?
  3. How can you remove the numbers from the company name?
  4. How can you create some new features? (e.g., state column from the location column)

Columns in the Cleaned Version

  • Job Title: Title of the job posting
  • Salary Estimate: Salary range for that particular job
  • Salary Estimate Min: Minimum Salary for that particular job
  • Salary Estimate Max: Maximum Salary for that particular job
  • Job Description: Full description of the job
  • Rating: Rating of the post
  • Company: Name of the company
  • State: State location of the company
  • Location: Location of the company
  • Headquarter: Location of the headquarters
  • Size: Total employees in that company
  • Founded: Date when the company was founded
  • Type of ownership: Describes the company type (non-profit/public/private farm, etc.)
  • Industry, Sector: Field the applicant will work in
  • Revenue: Total revenue of the company
  • Skills (Python, SQL, Stats & Probability, Excel, ML, DL, Tableau, Power BI, Hadoop, Spark, Hive, AWS, GCP, Azure): Boolean columns indicating the presence of specific skills
  • Simple Job Title: Job type
  • Avg Salary: Average Salary offered for that particular job

Analytical Questions

  1. What are the most common job titles among the listed positions?
  2. What is the distribution of average salary estimates across different job titles?
  3. What are the primary locations for job opportunities?
  4. What are the most common skills required for the data science field?
  5. What is the distribution of Minimum Average salary and Maximum Average salary estimates across different job titles?
  6. Which are the most common cloud platforms?
  7. Which are the most common Data Visualization tools?

Usage

These questions can serve as a starting point for exploring the dataset and extracting meaningful insights to inform decision-making processes in the job market.

Feel free to explore the dataset further and derive additional insights!

Dashboard SS