Data Management: Human Resources

Data: Six csv files containing employee information includiing: departments data, department manager data, employee data, salary data, titles data, and department employee data.

Step 1:

Data was opened as a text file to see columns and the types of data contained in the fields in order to create an entity relationship diagram (ERD) and table schema to import into PostgreSQL.

Step 2:

An ERD was created along with table schema.

Step 4:

Imported 6 csv files into PostgreSQL utilizing the table schema created and began to query. Queries looked at: employee salary, employees off of hire date, and employees within the sales and development departments.

Step 5:

Utilized Jupyter Notebook to query same information with SQLAlchemy to create visualizations of employee salary and a bar chart off of salary by title.