Analyzing Employee Database Part 2: Connect and visualize data with Python

Project Overview and Purpose

• To build a database using PostgreSQL and create queries to discover insights about the employees.
• Connect the SQL database to Pandas to create graphs and visualize the data.

Results

Create an ERD

Create Tables in Postgres SQL

Queries Examples for Analyzing the Database

Create a connection between Postgres and Python

Create Graphs Salary Count

Create Histogram

 

Create queries

Create an Average Salaries Graph