Data management and visualization

Table of content

General information


Data Warehousing


Exercise  Text Draft solution
Extended SQL (Customers) text
Extended SQL (Rentals) – updated 10-10-2019 text
Data warehouse design (storehouses) text
Data warehouse design (SearchingYourHouse) text
Data warehouse design (Hotel chain) text
Data warehouse design (Parcels service) text
Data warehouse design (PC store) text

Non-relational Databases

Data Visualization


Laboratory practice

Practice in Lab starts on Wednesday, October 23rd, 2019. There will be NO practice before.

Since Oct 23rd, all Wednesdays from 13:00 to 14:30 at Labinf there will be a new practice with assistant lecturers.

Students must own an active account to access the Labinf (see registration instructions on Labinf website).

Lab 1: Extended SQL

Lab 2: Extended SQL

Lab 3: Data-warehouse analytics and reporting with Google Data Studio

Lab 4: NoSQL in MongoDB Compass

Lab 5: NoSQL in MongoDB

Lab 6: Visualization analysis

Lab 7: Redesign with Tableau

Lab 7: Visualization of a dataset


 Parent page 


 © 2019 - DataBase and Data Mining Group