This is an Oracle DB Data Warehouse and ETL implementation on specially formatted Water Quality dataset from DEFRA, UK
python etl pandas-dataframe jupyter-notebook data-transformation data-warehouse database-schema oracle-database pyodbc extract-transform-load pl-sql oracle-sql-developer dimension-tables staging-area data-cleansing fact-table advanced-sql oracle-21c pl-sql-cursors
-
Updated
Dec 14, 2023 - Jupyter Notebook