SQL Data Warehouse and Analytics

Welcome to the SQL Data Warehouse & Analytics Project! 🚀

This repository showcases an end-to-end data warehousing and analytics solution, covering everything from data ingestion to delivering actionable insights.

---

🏗️ Data Architecture

This project follows the Medallion Architecture framework with Bronze, Silver, and Gold layers:

1. Bronze Layer: Contains raw ingested data as-is from source system.
2. Silver Layer: Handles data cleaning, standardization, and transformation for consistency.
3. Gold Layer: Stores curated, business-ready data modeled in a star schema for analytics and reporting.

---

📖 Project Overview

The project includes the following key components:

1. Data Architecture - Designing a modern data warehouse using Medallion layers.
2. ETL Pipelines - Extracting, transforming, and loading data into the warehouses.
3. Data Modelling - Building fact and dimension tables optimized for analytical queries.
4. Analytics & Reporting - Delivering insights through SQL queries and dashboards.

🛠️ Tools

• Datasets: Raw CSV datasets used in the project.
• SQL Server Express: Lightweight database server for hosting the warehouse.
• SQL Server Management Studio: GUI for database management and interaction.
• Github: Version control and collaboration platform.
• DrawIO: Tool for designing diagrams, models, and flows.
• Notion Project Steps: Access detailed project steps and tasks.

❤️ Closing Note

Made with ☕ for data engineering.