Skip to content

MoaviaMahmood/sql_data_warehouse_project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

50 Commits
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

Data Warehouse and Analytics Project

This project demonstrates a comprehensive data warehousing and analytics solution, from building a data warehouse to generating actionable insights. Designed as a portfolio project, it highlights industry best practices in data engineering and analytics.

Image

Project Overview

This project involves:

  1. Data Architecture: Designing a Modern Data Warehouse Using Medallion Architecture Bronze, Silver, and Gold layers.
  2. ETL Pipelines: Extracting, transforming, and loading data from source systems into the warehouse.
  3. Data Modeling: Developing fact and dimension tables optimized for analytical queries.
  4. Analytics & Reporting: Creating SQL-based reports and dashboards for actionable insights.

๐Ÿ›ก๏ธ License

This project is licensed under the MIT License. You are free to use, modify, and share this project with proper attribution.

๐Ÿ‘‹ About Me

Hi there! I'm Moavia Mahmood, a software engineering student passionate about AI and aspiring to become a Data Engineer. This project showcases my skills in building end-to-end data solutions.

๐Ÿ“ซ Let's Connect!

I'm actively looking for data engineering opportunities and collaborations:

About

Building a data warehouse with SQL Server, including ELT processes, Data modeling and analytics.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages