Employee Dataset for HR Analytics and Practice

• employees.department_id →references departments.department_idmany to one: each Employees row points to one Departments row
• salaries.employee_id →references employees.employee_idmany to one: each Salaries row points to one Employees row

1. Write a SQL query to find the average salary for each department, joining the employees and departments tables.

   tables: employees, departments, salaries

2. Using Power BI, create a bar chart showing the number of employees per department. What is the distribution of employees across different departments?

   tables: employees, departments

3. How does salary vary based on job title? Identify the department with the highest average employee age (calculate age from hire_date).

   tables: employees, salaries, departments

4. Create a pivot table in Excel to analyze salary trends by department and job title.

   tables: employees, departments, salaries

Table names match the SQLite file and the SQL script.

SELECT d.department_name, AVG(s.salary) AS average_salary
FROM departments d
JOIN employees e ON d.department_id = e.department_id
JOIN salaries s ON e.employee_id = s.employee_id
GROUP BY d.department_name
LIMIT 20;

SELECT d.department_name, COUNT(e.employee_id) AS employee_count
FROM departments d
JOIN employees e ON d.department_id = e.department_id
GROUP BY d.department_name
LIMIT 20;

SELECT job_title, MIN(salary) AS min_salary, MAX(salary) AS max_salary
FROM salaries s
JOIN employees e ON s.employee_id = e.employee_id
GROUP BY job_title
LIMIT 20;

Excel

Load each table into a separate sheet. Use XLOOKUP or Power Query to join tables. Create a PivotTable with department and job title on rows and average salary as values.

Power BI

Create relationships between employees and departments (on department_id) and between employees and salaries (on employee_id). Build a bar chart for employees per department. Create measures for average salary and employee count.

SQL

Load the SQLite or SQL dump. Use foreign keys to join tables: employees.department_id to departments.department_id, and salaries.employee_id to employees.employee_id. Example join path: departments -> employees -> salaries.

• CSV (zip)One CSV file per table, zipped
• Excel workbookOne worksheet per table
• SQLite databaseA ready-to-query database file with every table
• Parquet (zip)One Parquet file per table, zipped
• SQL scriptCREATE TABLE with primary and foreign keys, then INSERTs
• CSVA single CSV file
• JSONA single JSON file