data warehouse project links https://www.youtube.com/watch?v=u0bTOXVSrQc&t=5790

data Warehouse Concepts

data Mart

data warehouse internal

ETL (transform ,load)

Data Warehouse Complete Tutorial - SQL + SSIS + SSAS + Power BI - { End to End }

reference:- https://www.youtube.com/watch?v=eNxbMwUGl1g&t=723s&ab_channel=AnalyticswithNags

Introduction-to-Data-Warehouse

Data-WareHouse-Architecture

Data-Warehouse-Terminologies

dimensional-model-Problem-Statement

Business-Case-Study

to-do

ssis

reference:- https://www.youtube.com/watch?v=G_wG-bzTCZY&t=554s&ab_channel=AnalyticswithNags

SSIS

Data-Flow-Tutorial-practical

Different-transformation-in-data-flow-task

ssis-uses

Project [Designing DataWarehouse From Scratch]

Reference:- https://www.youtube.com/watch?v=u0bTOXVSrQc&ab_channel=CodeWithYu

Steps-Involved-in-Designing-DW

Designing-Logical-Architecture

Creating-Dimension-And-Fact-Data

Data Modelling

Data Modeling - Cumulative Dimensions, Struct and Array

Cumulative-Dimensions,-Struct-and-Array-Lab

Slowly-Changing-Dimensions-and-Idempotency

Reference

• Big data core
• system design
• pipeline design
• Designing Data-Intensive Applications
• Data Modeling