transactionalDataWarehouseModel

This project showcases a Dimensional Data Warehouse model, utilizing random data from Public APIs to populate the DW. The fact table is transactional based.Data endpoints are available through an Flask based API: https://transactionaldw.herokuapp.com/api

Schema

Analytical Queries

Some questions and answers using the Datawarehouse's data:

• Which is my best day of the week?
• 
• Which country buys the most?
• 
• Which purchase_profile buys the most?
• 
• What are my most sold products?
• 
• Which store sells the least?
• 

Fact Table Example

Product Dimension

Costumer Dimension