Employee Database (SQL-Tableau)

This project is based on SQL query and Tableau data visualisation.

Database Schema

Tools

• MySQL Workbench
• Tableau
• PowerPoint

Key Points

• Sales Team has the max male employees count (1990-2002).
• Customer Service Team has the max female employees count (1990-2002).
• There is almost 60%-40% ratio of Male and Female members (1990-2002).
• The salary for both Male and Female employees are nearly equal.
• Sales Team offers maximum salary for both male and female employees. This is condition based where salaries are in between 60000-75000 range.
• Finance, Production and Sales Team shows the max difference between male and female employees.

Tableau Dashboard

Link: Click Here!

Image

Other Details

• Check the PPT for questions and answers with query output.
• All the SQL queries are attached.
• SQL Database is attached.