General Information

Lecturers: Daniele Apiletti, Silvia Chiusano, Diego Monti

Teaching staff: Alessandro Fiori, Simone Monaco

SSD: ING-INF/05 – CFU: 8 – course details from the official student guide

Q&A teaching assistance on Piazza: piazza.com/polito.it/fall2022/01txasm/

---

News

• 5 December 2022: the Lab practice originally scheduled for December 16th is canceled. It will be held on December 20th in classroom 2P (please bring your laptop): team A from 10:00 to 11:30, team B from 11:30 to 13:00.
• 10 October 2022: the lecture on Tuesday, October 11, 2022 will be held only online (not in presence) via virtual classroom. The lecture will be recorded.
• 9 October 2022: the lesson on Monday, October 10, 2022 will be held only online (not in presence) via virtual classroom. The lesson will be recorded.
• 27 September 2023: the 22-23 edition of the course begins! See the official timetable.
• We are using Piazza for class discussion, we invite all students to join the course Piazza. Piazza is highly catered to getting help fast and efficiently from both classmates and teachers. Rather than emailing questions to the teaching staff, students are invited to post their questions on Piazza.

---

Teaching material

Course introduction (slides) – errata corrige on October 21, 2022: the Rector has informed us that teaching activities will be regularly provided on Friday, December 9th, 2022, hence please note that our Lab practice will be held on that day from 8:30 to 11:30, as in the standard weekly timetable of the course

Data Warehousing

• Introduction (slides)
• Conceptual and logical design (slides)
• Data analysis, OLAP, extended SQL (slides)
• ETL process (slides)
• Materialized view (slides)
• Data warehousing in Oracle (slides)
• Data warehousing: physical design (slides)

• ESERCIZI CON SOLUZIONI
• Exercise extended SQL, customers (text, draft solution)
• Exercise extended SQL, rentals (text, draft solution)
• Exercise DW design, hotels (text, draft solution)
• Exercise DW design, storehouses (text, draft solution)
• Exercise DW design, rentals (text, draft solution)
• Exercise DW design, parcels (text, draft solution)
• Exercise DW design, computer (text, draft solution)
• Vehicle rental (text, draft solution)
• Versioning services (text, draft solution)
• Craft beer (text, draft solution)
• Tickets (text, draft solution)
• Food delivery (text, draft solution)

• Additional exercises:
  • MongoDB design pattern exercises (text)
  • MongoDB query exercises (text)

Data Visualization

• What is visualization (slides)
• Visual perception (slides)
• Graph construction (slides)
• Data quality (slides)
• Past exams (slides)

---

Laboratory material

Lab practices start on Friday, October 14th, 2022.

Students group	Time	Room
TEAM A (FROM A TO K)	Friday, 8:30 – 10:00 am	LAIB4
TEAM B (FROM L TO Z)	Friday, 10:00 – 11:30 am	LAIB4

For Lab 1 and 2 you need to run Extended SQL on Oracle databases. SQL Developer is already available at LABINF. If you want to practise at home, you can follow one of these options:

Online version [SUGGESTED METHOD]	Installing Oracle Database 18c and SQL Developer [NOT RECOMMENDED]
Instead of installing Oracle Database and SQL Developer (not always straightforward to configure), you can consider Oracle Live SQL. You can add tables using SQL scripts A short guide on how to import SQL scripts and query the DB in Oracle Live SQL is available (pdf)	To download and install Oracle Express Edition: home page To download and install SQL Developer: home page TutorialInstallation Guide for Windows Installation Guide for Ubuntu Installation Guide for Mac OS Import Database and Tables: Tutorial

Lab 1: Extended SQL

• Text (pdf)
• Data warehouse tables (zip (CSV), zip (SQL))

• Solution (star schema, queries)

Lab 2: Extended SQL

• Text – Additional queries (pdf)
• Solution (pdf)

Lab 3: Looker Studio

• Text (pdf)

Lab 4: MongoDB Compass

• Text (pdf)
• Data (link)

• Draft solution (pdf)

Lab 5: MongoDB replica set

• Text (pdf)
• Data (file)
• Docker Compose (file)

• Draft solution (pdf)

Lab 6: Visualization analysis

• Text (pdf)
• Data (xlsx)

• Solution (xlsx)

Lab 7: Redesign with Tableau

• Text (pdf)

• Solution (zip)

Lab 8: Visualization of a dataset

• Text (pdf)
• Data (zip; txt)

• Solution (zip)

Lab 9: Intervals and dashboards

• Text (pdf)
• Data (zip)

• Solution (zip)

Lab 10: Geographic roles and maps

• Text (pdf)
• Data (zip)

• Solution (zip)

Lab 11: Dataviz exam simulation

• Text (pdf)
• Visualization (jpg)

• Solution (pdf, zip)

---

Exam