Designing Data Warehouse From Scratch: End to End Guide

سرفصل های دوره

Master the art of building a data warehouse from the ground up with this comprehensive end to end guide

1. Introduction

1. Prerequisites

2. Steps Involved in Creating a Data Warehouse

3. Discussing the business usecase

2. Creating Logical View of Datawarehouse

1. Creating the Logical Architecture View of the DW

3. Creating a Datawarehouse in the Cloud

1. Creating a Redshift Cluster on AWS

2. Finalising the creation Redshift Cluster on AWS

4. Data Loading into Datawarehouse

1. Data Warehouse Data Loading Strategies

5. Converting Logical View to Physical View

1. Creating Security Groups on AWS

2. Connecting and Managing your Redshift Cluster

3. Creating Glue crawler to create table from S3

4. Uploading data to s3 and crawling them with Glue crawler

5. Verifying the data loaded into Data Warehouse

6. Creating VPC, Subnets, Internet Gateways on AWS

7. Creating Subnet Groups on Redshift for VPC

6. Implementing Medallion Architecture in Redshift Datawarehouse

1. Creating DBT Project and Implementing Medallion Architecture

2. Finishing up on the Gold layer Facts

7. Data Quality and Testing

1. Writing Test Cases for Dimension Layers

2. Writing Test Cases for Gold Layer

3. Writing Data Quality Test Cases

8. DBT Analyses

1. Working with DBT Analyses

9. DBT Documentation

1. Writing DBT Documentation for the Project

10. Course Resources

1.1 4W1idASb30vZY6efjpyQ.zip

1. Full Code.html

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy