A fictional data warehouse project for testing and experimenting with ETL/DW data lifecycle. The project is built with SQL Server, including ETL processes, data modeling, and analytics.
The project demonstrates a comprehensive data warehouysing and analytics solution, from building a data warehouse to generating actionable insights. Designed as a protfolio project it highlights industry best practices in data engineering and analytics.
The project will cover:
- Data Sources: csv files
- Data Quality: Clensing and resolving data quality issues prior to analysis
- Integration: Combining sources into a single, user-friendly model.
- Scope: Only the latest data, historization is out of scope for this project.
- Documentation: Clear documentation of the model to support both business stake holders and analytics teams.