SQL DATA WAREHOUSE PROJECT

Welcome to the Data Warehouse and Analytics Project! 🚀 This project demonstrates a data warehousing and analytics solution using Medallion Architecture (Bronze, Silver, Gold layers) and SQL-based ETL pipelines. Designed as a portfolio project, it highlights best practices in data engineering and analytics.

📖 Overview

This project involves:

Data Architecture: Designing a modern data warehouse using Medallion Architecture.

ETL Pipelines: Extracting, transforming, and loading data from ERP and CRM systems.

Data Modeling: Building a star schema for optimized analytics.

Analytics: Generating SQL-based insights into customer behavior, product performance, and sales trends.

🚀 Requirements

Data Engineering Objective: Build a data warehouse in SQL Server to consolidate sales data.

Data Sources: ERP and CRM data provided as CSV files.

Tasks:

• Clean and integrate data from both sources.

• Create a user-friendly data model for analytics.

• Document the data model for stakeholders.

Data Analytics

Objective: Develop SQL-based reports for:

• Customer behavior

• Product performance

• Sales trends

🏗️ Architecture

The project follows Medallion Architecture:

Bronze Layer: Raw data ingestion from CSV files.

Silver Layer: Data cleansing and standardization.

Gold Layer: Business-ready data modeled in a star schema.

🛠️ Technologies

Database: SQL Server

ETL: SQL-based pipelines

Data Modeling: Star schema

📄 License

This project is licensed under the MIT License.

📧 Contact For questions, reach out:

Email: onoriodeemosairue@gmail.com

LinkedIn:www.linkedin.com/in/onoriodeemosairue/

Thank you for visiting! Happy coding! 🎉