BUILD A DATAWAREHOUSE END TO END USING THE MODERN DATA STACK

Dive into a practical, expert-led masterclass designed to build your analytics and data science expertise.

BUILD A DATAWAREHOUSE END TO END USING THE MODERN DATA STACK

BUILD A DATAWAREHOUSE END TO END USING THE MODERN DATA STACK

  • Dates: November 10, 2025 – November 27, 2025
  • Time: 6pm-8.30pm
  • Fee: KES 2,500
This masterclass is closed.
Share this Masterclass
Facebook Twitter LinkedIn WhatsApp
About the Event
  • BUILD A DATAWAREHOUSE END TO END USING THE MODERN DATA STACK
  • Objective: In this workshop, we will build a data warehouse in the cloud (Snowflake) from scratch using the Medallion Architecture. We’ll cover the evolution of data architectures from traditional data normalization and data modeling to the modern data stack and learn how organizations today
  • leverage cloud technologies for scalable, reliable, and efficient analytics.

By the end of this course, you’ll have hands-on experience setting up a Snowflake project, implementing Bronze–Silver–Gold models, ensuring data quality with dbt and Great Expectations, and orchestrating workflows with Airflow or Dagster.

Why This Workshop Matters

Shift to the cloud: Most industries have moved away from on-premise servers to the cloud for scalability, cost efficiency, and performance.


Industry adoption of Medallion Architecture: The Medallion approach (Bronze, Silver, Gold) is the de facto standard in modern analytics engineering.


Practical application: The principles and workflows you’ll implement here mirror what’s used by data teams in real organizations today.


Prerequisites

  Vs code, python installed

ideal for data analysts who want to pivot to analytics engineers, data engineers, analytics engineers and BI developers


What you will gain

  • Understand the evolution of data architectures from on-prem to the cloud.


  • Learn data normalization and modeling principles as the foundation of any data warehouse.


  • Explore the modern data stack and how the Medallion Architecture (Bronze, Silver, Gold) is applied in the industry.


  • Gain practical experience in Snowflake setup, ETL/ELT, dbt modeling, and data quality testing.


  • Learn to orchestrate workflows using Airflow or Dagster and connect to BI tools like Power BI for analytics.


  • Work on a capstone project to simulate a real-world data warehousing use case.


Building a data warehouse course outline


Day

Date

Objective

Delivery 6:00 -8:30




Monday




10/11/25

  • Course Intoduction
  • data nomalization theory ( end to end)
  • Evolution of data architectures → modern data stack
  • Data maturity model
  • Data modeling basics



Online session



Tuesday



11/11/25

  • Modern data stack architectures
  •   Slowly Changing Dimensions (SCDs
  • Snowflake account setup and project architecture


Online session


Wednesday


12/11/25

Understand our data , define our data model and draw it(sketch at draw.io) , we will also define relationships


Online session



Monday



17/11/25

  • Building Bronze, Silver and gold layers Working with dbt materializations


Online session


Tuesday


18/11/25

  • Data quality tests with dbt + Great Expectations
  • Setting up dbt macros
  • Packages

Online session




Wednesday




19/11/25

  • Data warehouse documentation

  • Orchestration with Dagster
  • Connecting to Power BI for BI reporting



Online session

Monday

24/11/25

  • Project assessment walkthrough.

  • Define Project assignment

Online session



Tuesday



25/11/25

  • Personal project implementation end to end
  • Build an end-to-end Medallion pipeline in Snowflake
  • Submit project to github and send

it for review



offline session



wednesda y


26/11/25

Final presentation and course wrap-up


online session



Meet Our Trainer

Simon Ngugi is a passionate Data Engineer with extensive experience in both data engineering and analytics engineering. Over the years, he has built strong expertise in modern data technologies that are widely adopted across industries, enabling organizations to design scalable, ecient, and reliable data solutions. 

Beyond his engineering work, Simon is an enthusiastic trainer who has led numerous technical workshops and sessions. His teaching style is beginner-friendly yet comprehensive, making complex concepts in the modern data stack accessible to learners at all levels. 

Driven by his commitment to mentorship and community building, Simon founded the DATECH COMMUNITY YouTube channel, where he shares hands-on data engineering projects, practical tutorials, and guidance for aspiring data professionals.