HANDS ON

1. ETL Lab — Heterogeneous Data Sources to a Snowflake Data Warehouse [PDF] [GIST]
   • Design workshop: towards the definition of snowflaking guidelines
   • ETL unbranched workshop through use cases
2. First steps into the population of a Snowflake Data Warehouse [GIST] – Homework
3. Initial and mastery activities for addressing OLAP queries
   • SQL Madness getting ready for big challenges [PDF] version
   • First touch into OLAP [PDF] version
   • Mastering OLAP – Homework [PDF] version
4. Data cleaning and preparation
   • Experience cleaning tabular data using Python [PDF] version
   • Experience cleaning tabular data using Talend – Homework [PDF] version
5. Wong exercises towards CaptStone Project specification [PDF]
6. Data Cleaning Lab towards a Silver Data Lake [PDF]
7. Responsible Cloud–Fog–Edge Deployment for a Lakehouse Data Warehouse [PDF]
8. Project management considerations [PDF]