Abdulhakim A. Qahtan
Data Wrangling and Data Analysis
This webpage contains all materials required for the Applied Data Science course INFOMDWR.
The materials on this website are CC-BY-4.0 licensed.
Syllabus
You can find the course syllabus as a web page here or as a pdf here. The course schedule with required reading materials is in the syllabus as well, specifically here.
Lectures
| Week | Date | Topic |
|---|---|---|
| 1 | 2025-09-04 | Introduction to the course |
| 1 | 2025-09-05 | Data models |
| 2 | 2025-09-09 | Data extraction with SQL |
| 2 | 2025-09-11 | Data extraction with SQL + Python |
| 2 | 2025-09-12 | Integrity constraints in databases |
| 3 | 2025-09-16 | Functional dependency |
| 3 | 2025-09-18 | Indexing & data integration |
| 3 | 2025-09-19 | Hetero. data analysis & string similarity |
| 4 | 2025-09-23 | Data preparation 1 |
| 4 | 2025-09-25 | Data preparation 2 |
| 4 | 2025-09-26 | Data visualization |
| 5 | 2025-09-30 | Exploratory data analysis |
| 5 | 2025-10-02 | Supervised learning: Regression |
| 5 | 2025-10-03 | Q&A |
| 6 | 2025-10-07 | Supervised learning: model evaluation |
| 6 | 2025-10-09 | Supervised learning: classification |
| 6 | 2025-10-10 | Deep learning |
| 7 | 2025-10-14 | Missing data 1: Mechanisms |
| 7 | 2025-10-16 | Missing data 2: Solutions |
| 7 | 2025-10-17 | Clustering |
| 8 | 2025-10-21 | Model-based clustering |
| 8 | 2025-10-23 | Text mining 1 |
| 8 | 2025-10-24 | Text mining 2 |
| 9 | 2025-10-28 | Time series |
| 9 | 2025-10-30 | Data streams |
| 9 | 2025-10-31 | Algorithmic fairness |
| 10 | 2025-11-04 | Q&A (11:00 - 12:45) |
Labs
Deadlines
| Week | Date | Topic |
|---|---|---|
| 4 | 2025-09-23 | 9:00AM assignment 1 |
| 5 | 2025-10-06 | Midterm exam (10:00 - 13:00) |
| 6 | 2025-10-07 | 9:00AM assignment 2 |
| 8 | 2025-10-21 | 9:00AM assignment 3 |
| 10 | 2025-11-04 | 9:00AM assignment 4 |
| 10 | 2025-11-07 | Final exam (13:30 - 16:30) |
| NA | 2026-01-05 | Resit exam |
Social Events
| Week | Date | Topic |
|---|---|---|
| 3 | 2025-09-16 | Social Event (Playground) |