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.


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