MyPhatshala

Data Warehousing and ETL

Organise company data for reporting and analytics.

Intermediate3 modules10 lessonsFree · no sign-up
0 of 10 lessons published
View syllabus

Syllabus

01 ConceptsWarehouse basics. 3 lessons
  1. 1.1What is a data warehouse?Coming soon
  2. 1.2OLTP vs OLAPComing soon
  3. 1.3ETL vs ELTComing soon
02 ModellingDesigning the warehouse. 3 lessons
  1. 2.1Facts and dimensionsComing soon
  2. 2.2Star and snowflake schemaComing soon
  3. 2.3Slowly changing dimensionsComing soon
03 Modern PlatformsCloud warehouses. 4 lessons
  1. 3.1Snowflake overviewComing soon
  2. 3.2BigQuery and Redshift overviewComing soon
  3. 3.3Data lakehouse and Delta LakeComing soon
  4. 3.4dbt basicsComing soon