Skip to content

Building a modern data warehouse with SQL Server, including ETL process, data modeling and analytics

License

Notifications You must be signed in to change notification settings

Hiba-B/sql-data-warehouse-project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

sql-data-warehouse-project

Welcome to the Data Warehouse and Analytics Project repository! 🚀 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.

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.

Licsense This project is licensed under the MIT license feel free to use, modify and share it with proper attribution.

About me Salam! I'm Hiba Baali. I'm a Data sceince graduate, I work as state engineer at CERIST, I'm passionate about learning and sharing knowledge.

About

Building a modern data warehouse with SQL Server, including ETL process, data modeling and analytics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages