This is an Oracle DB Data Warehouse and manual ETL demo on a specially formatted Water Quality dataset from DEFRA, UK. It is a personal academic-grade exercise to explore the basic concepts of data warehousing and manual ETL process from an academic perspective.
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
Mar 19, 2025 - Jupyter Notebook