Welcome to my Data Warehouse and Analytics Portfolio Project! 🚀
This project showcases the end-to-end development of a modern data warehousing solution, using best practices in data engineering, data modeling, and analytics. It’s designed as a portfolio piece to demonstrate practical skills with real-world relevance.

This project walks through building a scalable data warehouse solution using the Medallion Architecture, focusing on:

• Data Ingestion (Bronze Layer): Loading raw data directly from CSV files into SQL Server.
• Data Transformation (Silver Layer): Cleaning, standardizing, and preparing data for analysis.
• Data Modeling (Gold Layer): Creating a business-friendly star schema for analytical queries and reporting.

• Modern Data Architecture based on the Medallion model.
• ETL Pipelines using SQL Server and structured scripting.
• Fact & Dimension Tables designed for efficient querying.
• SQL-based Dashboards and queries for insights on customer behavior, product performance, and sales trends.

• SQL Server Express + SSMS
• DrawIO for diagrams and architecture planning
• Git & GitHub for version control
• Notion for project planning
• CSV Datasets (ERP and CRM systems)

• Consolidate and transform data from multiple source systems.
• Build a structured, analytical data warehouse on SQL Server.

• Generate actionable business insights using SQL queries.
• Provide stakeholders with clear visibility into key business metrics.

• SQL Development
• Data Engineering
• ETL Design
• Star Schema Modeling
• Data Analytics & Reporting
• Documentation & Best Practices

data-warehouse-project/
│
├── datasets/                           # Raw datasets used for the project (ERP and CRM data)
│
├── docs/                               # Project documentation and architecture details
│   ├── DWH_Architecture.drawio.png     # Draw.io file shows the project's architecture
│   ├── data_catalog.md                 # Catalog of datasets, including field descriptions and metadata
│   ├── Data_Flow.drawio.png            # for the data flow diagram
│
├── scripts/                            # SQL scripts for ETL and transformations
│   ├── bronze/                         # Scripts for extracting and loading raw data
│   ├── silver/                         # Scripts for cleaning and transforming data
│   ├── gold/                           # Scripts for creating analytical models
│
├── tests/                              # Test scripts and quality files
│
├── README.md                           # Project overview and instructions