Welcome to my Data Warehouse and Analytics Project repository! 🚀
This portfolio project demonstrates a complete data warehousing and analytics solution, from raw data ingestion to business-ready insights. It reflects industry best practices in data engineering, SQL development, and analytics.
The project follows the Medallion Architecture (Bronze → Silver → Gold):
- Bronze Layer: Raw data ingestion from ERP and CRM CSV files into SQL Server.
- Silver Layer: Data cleansing, normalization, and transformation for consistency.
- Gold Layer: Business-ready Star Schema with fact and dimension tables designed for reporting and analytics.
This project showcases:
- Data Architecture → Designing a modern warehouse with Medallion layers.
- ETL Pipelines → Building SQL-based pipelines to extract, transform, and load data.
- Data Modeling → Implementing star schema with fact & dimension tables.
- Analytics & Reporting → Creating SQL queries and dashboards for actionable insights.
This project highlights practical skills in:
✅ SQL Development
✅ Data Architecture & Modeling
✅ ETL Pipeline Design
✅ Data Engineering (SQL Server + SSMS)
✅ Data Analytics & Reporting
- Datasets → ERP & CRM CSV files
- SQL Server Express → Lightweight database engine
- SQL Server Management Studio (SSMS) → Database management & querying
Objective
Build a modern SQL Server Data Warehouse to consolidate sales data, enabling analytics and reporting for informed decision-making.
Specifications
- Data Sources: Import CSV data from ERP & CRM systems
- Data Quality: Clean and standardize raw datasets
- Integration: Merge sources into a unified star schema
- Scope: Focus on latest dataset (no historization)
- Documentation: Clear model documentation for stakeholders & analysts
- Modern Data Warehouse (Bronze, Silver, Gold)
- Star Schema with fact and dimension tables
- SQL-based ETL scripts
✨ This project is a hands-on demonstration of my Data Engineering journey, showcasing how raw data can be transformed into meaningful insights using modern data warehouse design.