Skip to content

Latest commit

 

History

History
12 lines (6 loc) · 1.05 KB

File metadata and controls

12 lines (6 loc) · 1.05 KB

Dashboard- PostgresSQL, Metabase and AWS

This dashboard summarize the sample Northwind Database; the data is about “Northwind Traders”, a fictional company. The database contains all sales transactions between the company and its customers as well as purchases from Northwinds suppliers.

A Postgres database was created in order to create tables inside and write SQL queries that retrieves data. SQLAlchemy library was also used ior accessing a database from Python. Ultimately, AWS was used to upload everything into a cloud server and, in this way, building a dashboard with metabase that stayed up and running 24/7.

Untitled_2.mov

Screenshot 2023-03-06 at 22 29 35

Screenshot 2023-03-06 at 22 30 03