dashboard_NorthWind_Database

Building a dashboard summarizing the Northwind Database

SQL and Metabase

In this project, I built a dashboard using open source service Metabase summarizing the Northwind Database. It is a sample database that is shipped along with Microsoft Access. 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. Data was prepared by SPICED Academy Instructor Paul Wlodkowski and available in his repository.

For this project data was apploaded into PostgreSQL Database in Amazon RDS instance. Then Metabase was installed on an AWS EC2 Machine and used for creating a publically available Metabase dashboard (is not available anymore: EC2 stopped and RDS deleted).

Power BI

I also created a dashboard for this dataset in Power BI, following instructions from this lesson in YouTube Channel PK: An Excel Expert

Here you can see the Dashboard in more details.

Repo content:

• In directory SQL_queries you can find the command line code for creating postgres-database from csv files and data-requesting queries:
  • In file database_creation.sql there is sql-code for creating tables and copying data from csv-files (check the path!) to database. It works only from command line!
  • In file dashboard_queries.sql there are some examples of sql-queries that I used to create a dashboard in metabase.
• In directory PowerBI you can find the markdown file with some Power BI Dashboard details
• "images" directory is storing images, used in this repository.