SQL Project

Overview

This project demonstrates the end-to-end process of building a modern Data Warehouse using SQL Server. It follows the Medallion Architecture (Bronze, Silver, and Gold layers) to integrate, cleanse, and model data from multiple source systems (ERP and CRM). The primary goal is to design a scalable and analytics-ready data platform that supports ETL processing, data modeling, and business intelligence reporting for data-driven decision-making.

Key Features

• Data Integration:
• Extracts and consolidates data from multiple CSV-based source systems (ERP & CRM).
• ETL Pipelines:
• Implements Extract, Transform, and Load processes using SQL scripts, ensuring data accuracy and quality.
• Data Cleansing & Standardization:
• Resolves data inconsistencies, missing values, and format mismatches to create a unified dataset.
• Star Schema Modeling:
• Designs fact and dimension tables optimized for analytics and business reporting.
• Analytics & Insights:
• Enables SQL-based analysis to uncover sales trends, customer segmentation, and product performance.
• Modular Design:
• Organized scripts and documentation for each data layer — Bronze, Silver, and Gold — ensuring maintainability and reusability.
• Visualization Ready:
• Provides a clean, business-ready data model suitable for dashboards or BI tools.

Screenshots