项目作者: asyaparfenova

项目描述 :
Building a dashboard summarizing the Northwind Database with PostgreSQL Database and with Metabase Visualisation uploaded to AWS cloud and Power Bi Dashboard
高级语言:
项目地址: git://github.com/asyaparfenova/dashboard_NorthWind_Database.git
创建时间: 2020-11-08T21:45:20Z
项目社区:https://github.com/asyaparfenova/dashboard_NorthWind_Database

开源协议:MIT License

下载


dashboard_NorthWind_Database

Building a dashboard summarizing the Northwind Database

Dashboard

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).

Metabase preview

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

PowerBI

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.