This repository presents a data warehousing and analytics project using SQL Server. It includes data architecture with a Medallion approach, ETL processes, and data modeling. The project aims to demonstrate best practices in data engineering and analytics.
From the README
Data Warehouse and Analytics Project Welcome to the Data Warehouse and Analytics Project repository! This project demonstrates a comprehensive data warehousing and analytics solution, from building a data warehouse to generating actionable insights. Designed as a portfolio project highlights industry best practices in data engineering and analytics. --- Project Overview This project involves: 1. Data Architechture: Designing a Modern Data Warehouse using Medallion Architecure (Bronze, Silver, and Gold layers). 2. ETL Pipelines: Extracting, transforming, and loading data from source systems into the warehouse. 3. Data Modeling: Developing fact and dimension tables optimized for analytical...
Skills
- TSQL
