The repository contains the SQL scripts for creating a dimensional model for the database BikeStores available at https://www.sqlservertutorial.net/sql-server-sample-database/.
The SQL scripts contained here are accompanying material for the article
Practical Introduction to Dimensional Data Design
published on medium.
-
Create a PostgreSQL database with the name bike_stores (or with a different name you choose).
-
Download and unzip the file dimensional-data-modelling-main.zip.
-
CD into directory with that file.
-
Unzip the file bikeStores.zip
-
Install the schema bike_stores
-
psql -f bikeStores/BikeStores/create_bike_stores_tables.sql -U postgres -d bike_stores
-
psql -f bikeStores/BikeStores/load_bike_stores_data.sql -U postgres -d bike_stores
-
-
Install the schema dwh
-
psql -f dwh/create_dimensions.sql -U postgres -d bike_stores
-
psql -f dwh/create_facts.sql -U postgres -d bike_stores
-