This project was completed in week 6 of the Data Science Bootcamp at SPICED Academy in Berlin. The goal is to build a dashboard on top of a Postgres database that runs in the AWS cloud.
The Northwind database is a sample database created by Microsoft for tutorials and testing purposes. It contains information about the business of Northwind Trades, a fictional company that sells various food products internationally. It includes information about orders, inventory, purchasing, suppliers, shipping, and employees.
For this project, I got the data in the form of several .csv files from here. Additionally, I got a .csv file from here containing country names and their ISO_A2 codes, in order to plot data on a world map. The data was imported into a local Postgres database, then hosted on AWS RDS and EC2, which is connected to Metabase to run continuously.
You can read more about the project workflow in this blog post.
The dashboard was created in Metabase and represents KPIs on the Sales and Team of Northwind Trades.
- The SALES part includes data from the Orders and Products tables.
- The TEAM part includes data from the Employees, Customers, and Orders tables.
northwind_database.sql: code dump for PostgreSQL to create the tables.northwind_queries.sql: queries used for creating the dashboard KPIsnorthwind_queries.py: same queries, but integrated with SQLAlchemy and pandas.dashboard_demo.gif: recorded dashboard interaction.