HANDS ON

1. Multidimensional DB design and Relational DW design: star or snowflake schemata, to be or not to be [PDF] [Colab instructions] [GIST]
2. 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
3. First steps into the population of a Snowflake Data Warehouse [GIST] – Homework
4. 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
5. Data cleaning and preparation
   • Experience cleaning tabular data using Python [PDF] version
   • Experience cleaning tabular data using Talend – Homework [PDF] version
6. Wong exercises towards CaptStone Project specification [PDF]
7. Data Cleaning Lab towards a Silver Data Lake [PDF]
8. Responsible Cloud–Fog–Edge Deployment for a Lakehouse Data Warehouse [PDF]
9. Project management considerations [PDF]