Data Analysis For Employee

1. Upload a employee sheet to chatgpt

2. Query below prompts

3. Crate table or charts for reporting

Beginner

1. Show all employees in the IT department.

2. Find employees with a salary greater than 80,000.

3. List employees who were hired after 2020.

4. Retrieve first name, last name, and job title only.

5. Show all employees with a last name starting with "S".

Intermediate

1. Count how many employees work in each department.

2. Find the average salary by department.

3. Show the highest salary in each department.

4. Find the earliest hire date in the company.

5. List the top 5 highest-paid employees.

Advanced

11. Find employees who earn above the company’s average salary.

12. Rank employees by salary within each department.

13. Find the second highest salary in the company.

14. Calculate the percentage of employees in each department.

15. Show employees who were hired in the same year as the earliest hire.

Real-world Business Analysis

1. Which department spends the most on salaries?

2. What is the average tenure (years worked) of employees?

3. Which job title has the highest average salary?

4. Identify departments with salaries above company average.

5. Find the most recently hired employee in each department.