Designing Data Warehouse From Scratch: End to End Guide

Focused View

Ganiyu Yusuf

5:12:50

239 View

1. Introduction

1. Prerequisites.mp4

07:18

2. Steps Involved in Creating a Data Warehouse.mp4

11:32

3. Discussing the business usecase.mp4

01:32

2. Creating Logical View of Datawarehouse

1. Creating the Logical Architecture View of the DW.mp4

33:30

3. Creating a Datawarehouse in the Cloud

1. Creating a Redshift Cluster on AWS.mp4

03:31

2. Finalising the creation Redshift Cluster on AWS.mp4

13:33

4. Data Loading into Datawarehouse

1. Data Warehouse Data Loading Strategies.mp4

50:16

5. Converting Logical View to Physical View

1. Creating Security Groups on AWS.mp4

01:27

2. Connecting and Managing your Redshift Cluster.mp4

05:02

3. Creating Glue crawler to create table from S3.mp4

08:30

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

08:57

5. Verifying the data loaded into Data Warehouse.mp4

09:46

6. Creating VPC, Subnets, Internet Gateways on AWS.mp4

02:26

7. Creating Subnet Groups on Redshift for VPC.mp4

00:53

6. Implementing Medallion Architecture in Redshift Datawarehouse

1. Creating DBT Project and Implementing Medallion Architecture.mp4

01:07:05

2. Finishing up on the Gold layer Facts.mp4

29:30

7. Data Quality and Testing

1. Writing Test Cases for Dimension Layers.mp4

13:00

2. Writing Test Cases for Gold Layer.mp4

17:43

3. Writing Data Quality Test Cases.mp4

06:50

8. DBT Analyses

1. Working with DBT Analyses.mp4

14:53

9. DBT Documentation

1. Writing DBT Documentation for the Project.mp4

05:36

10. Course Resources

1.1 4W1idASb30vZY6efjpyQ.zip

1. Full Code.html

Description

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

What You'll Learn?

Begin with the basics of data warehousing, understanding its significance, and exploring data modeling concepts to design the logical view of your DW
Get hands-on with Amazon Redshift, learning how to set up, manage, and optimize your data warehouse cluster for performance and cost-efficiency.
Translate your logical model into a robust physical model in Redshift, mastering the art of schema design, table creation, and query optimization.
Explore various data ingestion methods and learn how to transform raw data into insightful, analytical information using ETL and ELT processes.
Implement the cutting-edge medallion architecture in your data warehouse to streamline data processing and enhance analytical capabilities.

Who is this for?

Suitable to everyone interested in Big Data and Data Warehouse Modelling

What You Need to Know?

Basic Understanding of AWS Services

Basic SQL Technical Skills

Basic Understanding of Datawarehouse and Data Modelling

More details

Description
This is the ultimate course for aspiring and experienced data engineers alike. This comprehensive course is meticulously designed to take you through the entire process of creating a data warehouse, from conceptualization to implementation, using Amazon Redshift and the medallion architecture.
This course is designed for data professionals, analysts, and anyone interested in mastering data warehousing, this course will equip you with the skills and knowledge needed to create robust and scalable data warehouses from the ground up.
Through hands-on lessons and real-world examples, you'll learn how to:

Establish the logical architecture and design of a data warehouse, ensuring a solid foundation for your project.
Create and configure a data warehouse in the cloud using Amazon Redshift, leveraging the power and scalability of cloud computing.
Implement various data loading strategies to efficiently populate your data warehouse with relevant data from multiple sources.
Convert the logical design into a physical implementation, setting up the necessary infrastructure and configurations on AWS.
Implement the Medallion Architecture in your Redshift data warehouse, following industry best practices for data modeling and organization.
Write comprehensive test cases and implement data quality measures to ensure the integrity and reliability of your data warehouse.
Utilize DBT (Data Build Tool) for seamless data transformation, analysis, and documentation, streamlining the entire data warehousing process.
This course is suitable for all regardless of your job function; a data analyst, business intelligence professional, or simply someone passionate about data, this course will provide you with the skills and knowledge required to design and build a robust data warehouse from scratch, enabling you to unlock valuable insights and drive data-driven decision-making within your organisation.

Enroll now and embark on a journey to become a data warehousing expert with "Designing Data Warehouse From Scratch: End to End Guide".

Who this course is for:
Suitable to everyone interested in Big Data and Data Warehouse Modelling

User Reviews

Rating

average 0

Total votes0

Focused display

Data Warehouse

Ganiyu Yusuf

Instructor's Courses

I'm Yusuf Ganiyu, a dedicated and experienced Big Data Engineer at AstraZeneca UK, where I specialize in transforming complex data into actionable insights. My work, often operating behind the scenes, plays a pivotal role in the data-driven decisions you see in the industry today.With a passion for sharing knowledge, I have established myself as a prominent figure in the realms of Data Engineering and Cloud Computing. If you've sought out educational content in these fields, there's a good chance you've encountered my instructional videos or insightful articles.In my courses, I aim to demystify the complexities of data engineering and cloud technologies, making them accessible and engaging. Whether you're a beginner eager to dive into the world of data or a professional seeking to enhance your skills, my courses are designed to guide you every step of the way.Join me on this journey to unlock the power of data and cloud computing. Together, we'll explore cutting-edge technologies and practical applications that can propel your career to new heights.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.