DDrona4U
Sign inCreate account
My learningRideShareAnalyticsLesson 03
Technical Prerequisites

Lesson 03

Technical Prerequisites

Basic knowledge of SQL Understanding of Data Warehousing concepts Familiarity with ETL/ELT processes Knowledge of Cloud Data Platforms Basic Python programming Understanding of data modeling (Star Schema, Snowflake Schema) Git and version control fundamentals

Get the full lesson

Sign in to unlock everything beyond the preview — it's free.

  • Take timestamped notes as you watch
  • Read the full transcript and download resources
  • Join the discussion and track your progress
Sign inCreate free account

Curriculum

18 lessons · 25m

0/18 lessons done25m left
  1. 0101:22

    Project Introduction

    01:22

  2. 0201:45

    Project Execution Plan

    01:45

  3. 01:04

    Technical Prerequisites

    01:04

  4. 0400:57

    Snowflake Account Setup

    00:57

  5. 0501:25

    Local Stack – Apache Airflow Setup

    01:25

  6. 0601:21

    Snowflake DDL- Warehouse

    01:21

  7. 0700:59

    Snowflake DDL-Databases

    00:59

  8. 0801:53

    Snowflake Roles and Grants Setup

    01:53

  9. 0901:27

    Snowflake Resource Monitors and Raw Tables Creation

    01:27

  10. 1001:53

    Snowflake Streams and Dynamic Tables Setup

    01:53

  11. 1101:13

    Meta Table Creation

    01:13

  12. 1201:23

    Synthetic Data Generation

    01:23

  13. 1301:16

    Loading Synthetic Data into Snowflake

    01:16

  14. 1401:40

    dbt Build

    01:40

  15. 1500:47

    Dynamic Tables Implementation

    00:47

  16. 1601:23

    Run the Experiment

    01:23

  17. 1700:47

    Statistics

    00:47

  18. 1802:17

    Charts

    02:17