{"repo":"jsrl/sql-data-warehouse","free":true,"listed":false,"github":"https://github.com/jsrl/sql-data-warehouse","clone":"git clone https://github.com/jsrl/sql-data-warehouse.git","description":"Building a modern data warehouse with SQL server, including ETL processes, data modeling, and analytics.","language":"TSQL","stars":27,"topics":["data-warehouse","etl","medallion-architecture","sql"],"license":"MIT","category":"data-pipelines","readme_excerpt":"Data Warehouse and Analytics 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. --- 📅 Project Planning You can find the detailed project planning on Notion: SQL Data Warehouse Project --- 🏗️ Data Architecture The data architecture for this project follows Medallion Architecture Bronze , Silver , and Gold layers: 1. Bronze Layer : Stores raw data as-is from the source systems. Data is ingested from CSV Files into SQL Server Database. 2. Silver Layer : This layer includes data cleansing, standardization, and normalization processes to prepare data for analysis. 3. Gold Layer : Houses business-ready data modeled into a star schema required for reporting and analytics. 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. --- 🚀 Project Requirements Building the Data Warehouse (Data Engineering) Objective Develop a modern data warehouse using SQL Server to consolidate sales data, enabling analytical reporting and informed decision-making. ","default_branch":null,"files":null,"tree":[],"storefront":"/r/jsrl","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/jsrl/sql-data-warehouse/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}