Designing DataWarehouse from Scratch | End to End Data Engineering

FULL END TO END COURSE AVAILABLE AT https://www.datamasterylab.com/home/c...

Accelerate your Data Mastery by signing up on datamasterylab.com.

This video is divided into 5 parts:
1. Designing the logical view of the DW
2. Creating a Redshift DW cluster
3. Converting the logical view to physical view
4. Loading the DW with Data
5. Implementing the medallion architecture on DW

Timestamps:
0:00 Introduction
2:00 System Prerequisites
9:22 Steps Involved in Designing a Data Warehouse
21:00 The Business Usecase
22:42 Designing the Logical Architecture
56:10 Creating a VPC on AWS
58:21 Creating Redshift Data Warehouse Cluster
1:00:00 Creating Subnet Group on AWS
1:03:11 Creating Security Group and allowing external connections on AWS
1:05:22 Connecting to Redshift Cluster with DBeaver
1:05:40 Connecting to Redshift Cluster with Redshift Query Editor
1:09:20 Creating Dimensions and Fact data
1:16:57 Loading data into Data Warehouse
1:25:44 Creating AWS Data Catalog DB and Tables
1:32:05 Connecting to Redshift to AWS Glue Data Catalog
1:36:30 Creating DBT project
1:41:30 Configuration connections to Redshift from DBT
1:47:12 DBT Project configuration with Variables and Schema
1:49:05 Creating Silver Dimension models
2:05:34 Creating Silver Fact models
2:20:12 Creating Gold Dimension and Fact Models
2:38:17 Other course information

Like this video? Support us:    / @codewithyu  

👦🏻 My Linkedin:   / yusuf-ganiyu-b90140107  
🚀 X(Twitter): https://x.com/YusufOGaniyu
📝 Medium:   / yusuf.ganiyu  

🌟 Please LIKE ❤️ and SUBSCRIBE for more AMAZING content! 🌟

🔗 Useful Links and Resources:
✅ Video source code: https://www.buymeacoffee.com/yusuf.ga...
✅ S3 Documentation: https://docs.aws.amazon.com/s3/
✅ AWS IAM Documentation: https://docs.aws.amazon.com/IAM/lates...

#DataEngineering #DataWarehousing #DataEngineer #TechTutorial #DataScience #BigData #CloudComputing #AWSRedshift #DatabaseDesign #DataArchitecture #MedallionArchitecture #LearnCoding #TechEducation #DataAnalytics #DWDesign #PhysicalDataModel #LogicalDataModel #DataLoading #DataWarehouseProject #CodeWithYu