Skip to content
This repository has been archived by the owner on Sep 1, 2022. It is now read-only.

manueltarouca/apad-datawarehouse-implementation

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

apad-datawarehouse-implementation

A datawarehouse implementation

ETL folder

Files regarding the ETL process (python scripts, an exmple csv workbook file, helper sql queries).

Model folder

Files regarding both the design of the operational database and the dataarehouse database (json files exported from ONDA, and images of both models).

OLAP folder

Contains the PowerBI project.

SQL folder

Contains the sql queries in which creates the operational and dimensional databases, their tables and the insertion of operational data.

About

A datawarehouse implementation

Resources

License

Stars

Watchers

Forks