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

Created by: Ganiyu Yusuf
Big Data Engineer | Solutions Architect

What Will I 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.

Requirements

• Basic Understanding of AWS Services
• Basic SQL Technical Skills
• Basic Understanding of Datawarehouse and Data Modelling

Target audience

• Suitable to everyone interested in Big Data and Data Warehouse Modelling