GitHub / vaxdata22 / Water-Quality-DW-on-SQL-Server
This is an MSSQL 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.
JSON API: http://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/vaxdata22%2FWater-Quality-DW-on-SQL-Server
Stars: 1
Forks: 1
Open issues: 0
License: None
Language: Jupyter Notebook
Size: 394 KB
Dependencies parsed at: Pending
Created at: over 1 year ago
Updated at: about 1 month ago
Pushed at: about 1 month ago
Last synced at: about 1 month ago
Topics: advanced-sql, data-cleaning, data-transformation, data-warehousing, database-schema, dimension-tables, etl, extract-transform-load, fact-table, jupyter-notebook, microsoft-sql-server, pandas-dataframe, pyodbc, python, sql-server-management-studio, staging-area, t-sql