Designing DataWarehouse from Scratch | End to End Data Engineering

FULL END TO END COURSE AVAILABLE AT https://www.datamasterylab.com/home/course/designing-datawarehouse-from-scratch-end-to-end-guide/27 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: https://www.youtube.com/@CodeWithYu/join 👦🏻 My Linkedin: https://www.linkedin.com/in/yusuf-ganiyu-b90140107/ 🚀 X(Twitter): https://x.com/YusufOGaniyu 📝 Medium: https://medium.com/@yusuf.ganiyu 🌟 Please LIKE ❤️ and SUBSCRIBE for more AMAZING content! 🌟 🔗 Useful Links and Resources: ✅ Video source code: https://www.buymeacoffee.com/yusuf.ganiyu/source-code-designing-data-warehouse-scratch ✅ S3 Documentation: https://docs.aws.amazon.com/s3/ ✅ AWS IAM Documentation: https://docs.aws.amazon.com/IAM/latest/UserGuide/introduction.html #DataEngineering #DataWarehousing #DataEngineer #TechTutorial #DataScience #BigData #CloudComputing #AWSRedshift #DatabaseDesign #DataArchitecture #MedallionArchitecture #LearnCoding #TechEducation #DataAnalytics #DWDesign #PhysicalDataModel #LogicalDataModel #DataLoading #DataWarehouseProject #CodeWithYu