A personal Data Engineering project that simulates a small e-commerce system and implements an ETL pipeline from an OLTP database to a Data Warehouse using Python, Pandas, SQL Server, SQLAlchemy, and ...
Install Python requirements (pyodbc is included). Run sql/setup_sqlserver.sql in SSMS as an administrator to create the database, telemetry table, indexes and application permissions. The Python app ...