{"id":7128,"date":"2023-09-27T18:03:01","date_gmt":"2023-09-27T16:03:01","guid":{"rendered":"https:\/\/dbdmg.polito.it\/dbdmg_web\/?p=7128"},"modified":"2024-02-19T12:28:12","modified_gmt":"2024-02-19T11:28:12","slug":"data-management-and-visualization","status":"publish","type":"post","link":"https:\/\/dbdmg.polito.it\/dbdmg_web\/2023\/data-management-and-visualization\/","title":{"rendered":"Data Management and Visualization (2023-24)"},"content":{"rendered":"\n<h1 class=\" wp-block-heading eplus-wrapper\" id=\"general-information\">General Information<\/h1>\n\n\n\n<p class=\" eplus-wrapper\"><strong>Lecturers<\/strong>: Daniele Apiletti, Diego Monti<\/p>\n\n\n\n<p class=\" eplus-wrapper\"><strong>Teaching staff<\/strong>: Alessandro Fiori, Simone Monaco<\/p>\n\n\n\n<p class=\" eplus-wrapper\"><strong>SSD<\/strong>: ING-INF\/05 &#8211; <strong>CFU<\/strong>: 8 &#8211; <a href=\"https:\/\/didattica.polito.it\/pls\/portal30\/gap.pkg_guide.viewGap?p_cod_ins=01TXASM&amp;p_a_acc=2024&amp;p_header=S&amp;p_lang=IT&amp;multi=N\" target=\"_blank\" rel=\"noreferrer noopener\">course details from the official student guide<\/a><\/p>\n\n\n\n<p class=\" eplus-wrapper\">Q&amp;A teaching <strong>assistance <\/strong>on Piazza: <a href=\"https:\/\/piazza.com\/polito.it\/fall2023\/01txasm\">piazza.com\/polito.it\/fall2023\/01txasm<\/a><\/p>\n\n\n\n\n\n<hr class=\" wp-block-separator has-css-opacity eplus-wrapper\"\/>\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"news\">\ud83d\udcf0 News<\/h2>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-04fc9a\">\n<li class=\" eplus-wrapper\">We are using Piazza for class discussion. We invite all students to <a href=\"https:\/\/piazza.com\/polito.it\/fall2023\/01txasm\">join the course Piazza<\/a>. Piazza is highly suggested to get help fast and efficiently from classmates and teachers. Rather than emailing questions to the teaching staff, students are invited to post their questions on Piazza.<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Seminar announcement &#8211; <strong>Data science and retail: how Data Management and Machine Learning can improve customer experience<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-fd69c7\">\n<li class=\" eplus-wrapper\">When: Monday, January 15th, 14:30-16:00, <a href=\"https:\/\/www.polito.it\/ateneo\/chi-siamo\/sedi-e-mappe?bl_id=TO_CIT22&amp;fl_id=XPTE&amp;rm_id=036&amp;lang=it\">classroom 1P<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\">Who: <a href=\"https:\/\/www.linkedin.com\/in\/marco-stella-9276258\">Marco Stella<\/a>, Data Science Manager, <a href=\"https:\/\/www.mirogliogroup.com\/\">Miroglio Group<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\">What: Miroglio Group ambition is to become a Data and Customer centric company. How to propose the best personalized product for each customer? Can new technologies facilitate this goal? In this seminar we will explain how we are implementing a Cloud Data Platform to know and understand better our customers. We will go through a use case where Machine Learning algorithms are applied to customer segmentation, hence facilitating, pushing and harmonizing marketing product campaigns.<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Material: <a href=\"https:\/\/drive.google.com\/file\/d\/1einjjK5u2oLMFmA2V36dlBJFrgRBTxSy\/view?usp=sharing\">slides<\/a><\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\">Seminar announcement &#8211; <strong>PowerBI: a free tool for Big Data Management and Advanced Visualization<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-14a3f1\">\n<li class=\" eplus-wrapper\">When: Tuesday, January 16th, 11:30-13:00, <a href=\"https:\/\/www.polito.it\/ateneo\/chi-siamo\/sedi-e-mappe?bl_id=TO_CIT06&amp;fl_id=XPTE&amp;rm_id=003\">classroom R3<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\">Who: <a href=\"https:\/\/www.linkedin.com\/in\/victormrivasc\/\">Victor Rivas<\/a>, <a href=\"https:\/\/evergrowbi.com\/\">Evergrow BI<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\">What: Unlock the full potential of Power BI, a premier, yet free tool for Windows users. The seminar will guide you through the strategic use of Power BI for managing and visualizing Big Data using innovative features like Composite Models and Direct Lake in Fabric. Glean insights into the comparative advantages of tabular versus multidimensional models, and learn to craft visual narratives that make data speak volumes.<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Material: <a href=\"https:\/\/www.youtube.com\/watch?v=Vqz2d7pTOV8&amp;list=PLv2BtOtLblH13vCbf99BptWWk-EWx7QQG&amp;ab_channel=GuyinaCube\">intro by Adam Saxon, Program Manager, Microsoft<\/a>.<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\">Seminar announcement &#8211; <strong>The power of Data Modeling in Business Analytics<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-2d8cd9\">\n<li class=\" eplus-wrapper\">When: Tuesday, January 16th, 13:00-14:30, <a href=\"https:\/\/www.polito.it\/ateneo\/chi-siamo\/sedi-e-mappe?bl_id=TO_CIT06&amp;fl_id=XPTE&amp;rm_id=003\">classroom R3<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\">Who: <a href=\"https:\/\/www.sqlbi.com\/author\/marco-russo\/\">Marco Russo<\/a>, <a href=\"https:\/\/www.linkedin.com\/in\/sqlbi\">SQLBI<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\">What: This seminar focuses on different data models used in business analytics. Using the example of \u201cTickit\u201d, a fictional website for buying and selling event tickets, we\u2019ll examine how data models work in real-world scenarios. We\u2019ll look at typical raw data (like denormalized files and OLTP data source, and then compare different analytical models like Inmon (data warehouse) and Kimball (dimensional modeling), and then introduce the additional features of semantic models to create reports in an interactive way and write shorter queries.<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Material: <a href=\"https:\/\/www.dropbox.com\/scl\/fi\/j9z4w6jcd00kw31iqjrkp\/Data-modeling-in-business-analytics-Demo-Slides.zip?rlkey=x8g6qcwm17wjd0pkeox9pgenf&amp;dl=0\">slides and demo<\/a><\/li>\n<\/ul><\/li>\n<\/ul>\n\n\n<hr class=\" wp-block-separator has-css-opacity eplus-wrapper\"\/>\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"teaching-material\">\ud83d\udcd2 Teaching material<\/h2>\n\n\n\n<p class=\" eplus-wrapper\"><strong>Course introduction <\/strong>(<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/10\/0-DMV-intro-23-24.pdf\">slides<\/a>)<\/p>\n\n\n\n<div class=\"wp-block-ep-tabs ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8\"><div class=\"ep_tabs_root ep_tabs_top\" data-autoplay=\"false\" data-delay=\"1000\"><div class=\"ep_tabs_header \"><a href=\"#ep_tab_wrapper__c3320f23-42dd-4777-ac71-27a4c5db79b3\" class=\"ep_label_main\"><span class=\"ep_label\">Data Warehouse<\/span><\/a><a href=\"#ep_tab_wrapper__8369e23b-5c72-4537-9f9c-d37e4bdfe598\" class=\"ep_label_main\"><span class=\"ep_label\">NoSQL<\/span><\/a><a href=\"#ep_tab_wrapper__490e69f4-43fc-4c5a-baae-8c1fb510edfa\" class=\"ep_label_main\"><span class=\"ep_label\">Data Visualization<\/span><\/a><\/div><div class=\"ep_tabs_wrapper undefined\">\n<div id=\"ep_tab_wrapper__c3320f23-42dd-4777-ac71-27a4c5db79b3\" class=\"ep_tab_item_wrapper ep_tab_wrapper__c3320f23-42dd-4777-ac71-27a4c5db79b3 undefined\"><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-3ede4b\">\n<li class=\" eplus-wrapper\">Introduction (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/09\/1-DWIntroduction-1per.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Conceptual and logical design (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/DSTBD_3-DWprogConcLog-EN.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data analysis, OLAP, extended SQL (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/4-DWquery-EN.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">ETL process (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/DMV_6-DW-ETL-1per.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Materialized view (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/DMV_3-DW-materializedview-1per.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data warehousing in Oracle (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/Oracle-extended-SQL-2021.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data warehousing: physical design (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/DMV_2-DW-physical-design-1per.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Conceptual schema: textual formalism (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/DW-Formalismo2023.pdf\">slides<\/a>)<\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__8369e23b-5c72-4537-9f9c-d37e4bdfe598\" class=\"ep_tab_item_wrapper ep_tab_wrapper__8369e23b-5c72-4537-9f9c-d37e4bdfe598 undefined\"><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-43563d\">\n<li class=\" eplus-wrapper\">Non-relational databases for data management &#8211; introduction (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/01-NoSQL-intro-and-document-DB.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Introduction to MongoDB, collections, create, delete, GUI (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/02-MongoDB-intro-GUI.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB, querying data, find operator, aggregation pipeline (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/03-MongoDB-operations-find.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB aggregation examples, indexes (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/04-MongoDB-aggregation-indexes.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Distributed Data Management, replication, and the CAP theorem (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/05-Distributed-Data-Management-Replication-CAP-Conflicts.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB replica set (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/06-MongoDB-replication.pdf\">slides<\/a>, updated Nov 18)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Distributed transactions (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/08a-Distributed-Transactions-2PC.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Distributed data processing and Map Reduce (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/10-MapReduce.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">NoSQL design recipe (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/11-NoSQL-Transaction-Design-Recipe.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB design patterns part 1 (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/12-MongoDB-design-patterns-part-1.pdf\">slide<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB design patterns part 2 (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/13-MongoDB-design-patterns-part-2.pdf\">slide<\/a>)<\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__490e69f4-43fc-4c5a-baae-8c1fb510edfa\" class=\"ep_tab_item_wrapper ep_tab_wrapper__490e69f4-43fc-4c5a-baae-8c1fb510edfa undefined\"><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-709f05\">\n<li class=\" eplus-wrapper\">What is visualization (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/DV01-DataVisualization.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Visual perception (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/DV02-VisualPerception.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Graph construction (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/DV03-GraphConstruction.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data quality (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/DV04-DataQuality.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Past exams (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/DV05-PastExams.pdf\">slides<\/a>)<\/li>\n<\/ul><\/div>\n<\/div><style>.eplus_styles .ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8 .ep_tabs_header {\n                \n                flex-basis: 15% ;\n            }.eplus_styles .ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8 .ep_tabs_root {\n                \n                gap: 0px ;\n            }.eplus_styles .ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8 .ep_label {\n                \n                color: #1e1e1e;\nfont-size: 17px ;\n            }\n            \n\n        \n\n         \n\n        \n        \n      .eplus_styles  .ep_label_main:hover .ep_label {\n        color: #ffffff;\n      }.eplus_styles .ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8 .ep_sub_label {\n                \n                color: #1e1e1e;\nfont-size: 15px ;\n            }\n            \n\n        \n\n         \n\n        \n        \n      .eplus_styles  .ep_label_main:hover .ep_sub_label {\n        color: #ffffff;\n      }.eplus_styles .ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8 .ep_active_tab .ep_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8 .ep_active_tab .ep_sub_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8 .ep_label_main {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }\n            \n\n        \n\n         \n\n        \n            .eplus_styles .ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8 .ep_label_main:hover {\n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8 .ep_active_tab {\n                \n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8 .ep_tab_item_wrapper {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }.eplus_styles .ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8 .ep_label_main {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8 .ep_tab_item_wrapper {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8 .ep_tabs_header {\n                \n                gap: 5px ;\n            }.eplus_styles .ep_tabs_wrapper__7d342c0c-6487-4d18-be52-86d5335205e8 .ep_tabs_header {\n                \n                justify-content: flex-start;\n            }<\/style><\/div><\/div>\n\n\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"exercises\">\ud83d\uddd2\ufe0f Exercises<\/h2>\n\n\n\n<div class=\"wp-block-ep-tabs ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2\"><div class=\"ep_tabs_root ep_tabs_top\" data-autoplay=\"false\" data-delay=\"1000\"><div class=\"ep_tabs_header \"><a href=\"#ep_tab_wrapper__24075555-8dda-42d9-ba4a-9472e89d0390\" class=\"ep_label_main\"><span class=\"ep_label\">Data Warehouse<\/span><\/a><a href=\"#ep_tab_wrapper__561f8fc5-fc41-4429-a35d-97c76581cb9d\" class=\"ep_label_main\"><span class=\"ep_label\">NoSQL<\/span><\/a><\/div><div class=\"ep_tabs_wrapper undefined\">\n<div id=\"ep_tab_wrapper__24075555-8dda-42d9-ba4a-9472e89d0390\" class=\"ep_tab_item_wrapper ep_tab_wrapper__24075555-8dda-42d9-ba4a-9472e89d0390 undefined\"><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-d91734\">\n<li class=\" eplus-wrapper\">Exercise extended SQL, customers (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/ExtendedSQL-Exercise-1-text-2021.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2017\/11\/ExtendedSQLDraftSolutionCustomer.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise extended SQL, rentals (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ExtendedSQL_ENG.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ExtendedSQL-draft_solution.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, hotels (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/12\/05-DW-project-hotel-text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-hotel_chain_draft_solution.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, storehouses (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/10\/03-DW-project-household-text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-Italian_household_draft-solution.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, rentals (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/10\/04-DW-project-HouseSearch-text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-SearchingYourHouse-draft_solution.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, parcels (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/12\/06-DW-project-parcels-text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/01\/DW_Parcels_Schema.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, computer (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/12\/07-DW-project-PC-text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/DW_PCStore_DraftSol.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, vehicle rental (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Vehicle_rental_DW_text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Vehicle_rental_DW_text_draft_sol-1.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, versioning services (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Versioning_services_DW_text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Versioning_services_DW_draft_sol.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, craft beer (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Craft_beer_DW_text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/12\/Craft_beer_DW_draft_sol_v2.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, tickets (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Tickets_DW_text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Tickets_DW_draft_sol.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, food delivery (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Food_delivery_DW_text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/12\/Food_delivery_DW_draft_sol.pdf\">solution<\/a>)<\/li>\n<\/ul>\n\n<\/div>\n\n\n\n<div id=\"ep_tab_wrapper__561f8fc5-fc41-4429-a35d-97c76581cb9d\" class=\"ep_tab_item_wrapper ep_tab_wrapper__561f8fc5-fc41-4429-a35d-97c76581cb9d undefined\"><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-daf464\">\n<li class=\" eplus-wrapper\">MongoDB query exercises (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/07-MongoDB-query-exercises.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB query exercises IMDB (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/09-MongoDB-exercises-IMDB-database-with-solutions.pdf\">slides<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/imdb.json.zip\">IMDB database<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB design pattern exercises 1 (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/14-MongoDB-design-patterns-exercises-part-1.pdf\">slide<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB design pattern exercises 2 (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/15-MongoDB-design-patterns-exercises-part-2.pdf\">slide<\/a>)<\/li>\n<\/ul><\/div>\n<\/div><style>.eplus_styles .ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2 .ep_tabs_header {\n                \n                flex-basis: 15% ;\n            }.eplus_styles .ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2 .ep_tabs_root {\n                \n                gap: 0px ;\n            }.eplus_styles .ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2 .ep_label {\n                \n                color: #1e1e1e;\nfont-size: 17px ;\n            }\n            \n\n        \n\n         \n\n        \n        \n      .eplus_styles  .ep_label_main:hover .ep_label {\n        color: #ffffff;\n      }.eplus_styles .ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2 .ep_sub_label {\n                \n                color: #1e1e1e;\nfont-size: 15px ;\n            }\n            \n\n        \n\n         \n\n        \n        \n      .eplus_styles  .ep_label_main:hover .ep_sub_label {\n        color: #ffffff;\n      }.eplus_styles .ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2 .ep_active_tab .ep_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2 .ep_active_tab .ep_sub_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2 .ep_label_main {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }\n            \n\n        \n\n         \n\n        \n            .eplus_styles .ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2 .ep_label_main:hover {\n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2 .ep_active_tab {\n                \n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2 .ep_tab_item_wrapper {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }.eplus_styles .ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2 .ep_label_main {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2 .ep_tab_item_wrapper {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2 .ep_tabs_header {\n                \n                gap: 5px ;\n            }.eplus_styles .ep_tabs_wrapper__b7a65abb-a0cc-4b88-a484-6ac7dc2226b2 .ep_tabs_header {\n                \n                justify-content: flex-start;\n            }<\/style><\/div><\/div>\n\n\n\n\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"laboratory-material\">\ud83d\udcbb Laboratory material<\/h2>\n\n\n\n<p class=\" eplus-wrapper\"><strong>The first lab is scheduled for Thursday, October 19<\/strong><\/p>\n\n\n\n<figure class=\" wp-block-table eplus-wrapper\"><table><tbody><tr><td><strong>Students group<\/strong><\/td><td><strong>Time<\/strong><\/td><td><strong>Room<\/strong><\/td><\/tr><tr><td>TEAM A (FROM A TO K)<\/td><td>Thursday, 16:00 &#8211; 17:30<\/td><td>LAIB2B<\/td><\/tr><tr><td>TEAM B (FROM L TO Z)<\/td><td>Thursday, 17:30 &#8211; 19:00<\/td><td>LAIB2B<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\" eplus-wrapper\">For Labs 1 and 2, you need to run <strong>Extended SQL<\/strong> on <strong>Oracle databases<\/strong>. SQL Developer is already available on the devices. If you want to practise at home (or on PoliTO devices as well), we suggest you configure its online version on <a href=\"https:\/\/livesql.oracle.com\/\">Oracle Live SQL<\/a>, in particular:<\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-20008b\">\n<li class=\" eplus-wrapper\">You can add tables using SQL scripts<\/li>\n\n\n\n<li class=\" eplus-wrapper\">A short guide on how to import SQL scripts and query the DB in Oracle Live SQL is available (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/Import_Oracle_Live_SQL.docx.pdf\">pdf<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 1: Extended SQL<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-d6905d\">\n<li class=\" eplus-wrapper\">Text (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/Lab1_ExtendedSQL.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data warehouse tables (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/DW_Phones_EN.zip\">zip (CSV)<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/DW_CELLS_sql.zip\">zip (SQL)<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/star_schema_callDW_Sol.pdf\">star schema<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/10\/Lab1_ExtendedSQL_Sol.pdf\">queries<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 2: Extended SQL<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-d96dd5\">\n<li class=\" eplus-wrapper\">Text \u2013 Additional queries\u00a0(<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/Lab2_ExtendedSQL.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab2_ExtendedSQL_sol.pdf\">pdf<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 3: Looker Studio<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-cfe99c\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/Lab3_DataStudio_v2024.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">pdf<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 4: MongoDB Compass<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-73526a\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/DataManagement_lab4_2023-24.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data (<a href=\"https:\/\/drive.google.com\/drive\/folders\/1FQl8HRbZDTXR4279ZEsfUEm1fIdpOs1E?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">link<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Draft solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/DataManagement_compass_sol_2023.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">pdf<\/a>) &#8211; updated 2023-11-20<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 5: MongoDB replica set<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-0860b3\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/DMV_Lab5_MongoDB_text.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">pdf)<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\">Script and Data (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/script_and_data.zip\" target=\"_blank\" rel=\"noreferrer noopener\">file<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Docker Compose (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/docker-compose.yml_.zip\" target=\"_blank\" rel=\"noreferrer noopener\">file<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Draft solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/DMV_Lab5_MongoDB_2023_solution.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">pdf<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 6: Visualization analysis<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-c206e1\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab6.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab6.xlsx\">xlsx<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-c84968\">\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab6_sol.xlsx\">xlsx<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 7: Redesign with Tableau<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-063c8e\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab7.pdf\">pdf<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-9cc002\">\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab7_sol.zip\">zip<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 8: Visualization of a dataset<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-ea2163\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab8.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/f1db_csv.zip\">zip<\/a>; <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/f1db_user_guide.txt\">txt<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-9f5a5c\">\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab8_sol.zip\">zip<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 9: Intervals and dashboards<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-8d3876\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab9-1.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Kickstarter.zip\">zip<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-47d6b4\">\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab9_sol.zip\">zip<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 10: Geographic roles and maps<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-e8d870\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab10-1.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab10.zip\">zip<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-c1bb34\">\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab10_sol.zip\">zip<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 11: Dataviz exam simulation<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-07db84\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/Lab11.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Visualization (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/BrandZ.jpg\">jpg<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-3c7046\">\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/Lab11_sol.pdf\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/Lab11_sol.zip\">zip<\/a>)<\/li>\n<\/ul>\n\n\n<hr class=\" wp-block-separator has-alpha-channel-opacity eplus-wrapper\"\/>\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"exam\">\ud83d\udcc4 Exam<\/h2>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-a703c1\">\n<li class=\" eplus-wrapper\"><strong>June 21th, 2023<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-fe81a0\">\n<li class=\" eplus-wrapper\">Text + DW and NoSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/12\/DMV-Exam-29-June-2022.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>February 22th, 2023<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-e3b8a9\">\n<li class=\" eplus-wrapper\">Text + DW and NoSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/DMV-Exam-22-February-2023.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/VizExamSheet_20230222.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Conceptual design (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/conceptual_230222.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>February 7th, 2023<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-7df0e9\">\n<li class=\" eplus-wrapper\">Text + DW and NoSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/02\/DMV-Exam-7-February-2023.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/02\/VizExamSheet_20230207.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Conceptual design (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/conceptual_230207.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>June 29th, 2022<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-43dd8e\">\n<li class=\" eplus-wrapper\">Text + DW and NoSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/12\/DMV-Exam-29-June-2022.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>February 17th, 2022<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-2775d6\">\n<li class=\" eplus-wrapper\">Text + DW and NoSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/12\/17feb_sol.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/02\/VizExamSheet_20220217.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Conceptual design (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/conceptual_230222.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>January 28th, 2022<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-f42e7f\">\n<li class=\" eplus-wrapper\">Text + DW and NoSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/02\/DMV-Exam-28-January-2022-textsolution.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/02\/VizExamSheet_20220128.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>September 1st, 2021<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-02cf29\">\n<li class=\" eplus-wrapper\">Text + DW and NoSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/09\/DMV-Exam-1-September-2021-text.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/09\/DMV-2021-09-01-VizExamSheet_sol.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>June 17th, 2021<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-037c2e\">\n<li class=\" eplus-wrapper\">Text + DW and NoSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/06\/DMV-Exam-17-June-2021-text-solutions-from-Exam.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data visualization solution (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/06\/DMV_2021-06-17_VizExamSheet_sol.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>Feb 15th, 2021<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-1b2fca\">\n<li class=\" eplus-wrapper\">Text + DW and NoSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/DMV-Exam-15-February-2021-text-and-solutions.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/VizExamSheet_sol-1.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-group eplus-wrapper\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-52bfcd\">\n<li class=\" eplus-wrapper\"><strong>Feb 1st, 2021<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-1dfee2\">\n<li class=\" eplus-wrapper\">Text + DW and NoSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/DMV_Exam2021_02_01_draft_sol.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/VizExamSheet_sol.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n<\/ul><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>General Information Lecturers: Daniele Apiletti, Diego Monti Teaching staff: Alessandro Fiori, Simone Monaco SSD: ING-INF\/05 &#8211; CFU: 8 &#8211; course details from the official student guide Q&amp;A teaching assistance on Piazza: piazza.com\/polito.it\/fall2023\/01txasm \ud83d\udcf0 News \ud83d\udcd2 Teaching material Course introduction (slides) \ud83d\uddd2\ufe0f Exercises \ud83d\udcbb Laboratory material The first lab is scheduled &hellip;<\/p>\n","protected":false},"author":11,"featured_media":1340,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"editor_plus_copied_stylings":"{}","footnotes":""},"categories":[37],"tags":[],"class_list":["post-7128","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-courses"],"_links":{"self":[{"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/7128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/comments?post=7128"}],"version-history":[{"count":79,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/7128\/revisions"}],"predecessor-version":[{"id":11005,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/7128\/revisions\/11005"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/media\/1340"}],"wp:attachment":[{"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/media?parent=7128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/categories?post=7128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/tags?post=7128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}