- Knowledge of data warehouse architecture and of the methodology for conceptual, logical, and physical design of a data warehouse. - Ability to design a data warehouse. - Knowledge of the SQL statements for OLAP queries in a data warehouse. - Ability to write OLAP queries by means of the SQL language. - Knowledge of the main technological characteristics of NoSQL databases. - Ability to design the conceptual model and define the physical data structures for NoSQL databases. - Knowledge for querying NoSQL databases. - Ability to design dashboards and KPIs - Knowledge of the basic principles of cognitive and perceptive aspects related to visualization, and knowledge of the main visualization techniques. - Ability to design and develop simple systems for visualizing quantitative information.

- Knowledge of the relational model and SQL language and basic programming skills. - Basic knowledge of the JSON data format.

• Data cleaning and data integration (0.6 cr.) • Data warehouses: architecture, methodology for conceptual, logical, and physical design, SQL statements for OLAP queries (3 cr.) • NoSQL databases: conceptual modeling, technological characteristics, data management issues in distributed (non-relational) databases and query languages (2.4 cr.) • Cognitive aspects of visualization and visual integrity principles (1 cr.) • Data visualization tools (1 cr.)

The course includes practices on the lecture topics, and in particular conceptual, logical, and physical data warehouse design, extended SQL language, and NoSQL database design and query (6 cr.), and data visualization (2 cr.). The course includes many laboratory sessions for hands-on experience on data warehouse design, extended SQL language, NoSQL database design and query, and different data visualization aspects. Laboratory practices allow experimental activities on the most widespread commercial and open-source products, and they will be interleaved with lectures.

Copies of the slides used during the lectures, examples of written exams and exercises, and manuals for the activities in the laboratory will be made available. All teaching material is downloadable from the course website or the teaching Portal. Reference books: - Matteo Golfarelli, Stefano Rizzi. Data Warehouse Design: Modern Principles and Methodologies, McGraw-Hill Education, 2009 - Dan Sullivan, NoSQL for Mere Mortals, Addison-Wesley Professional, 2015 - Kristina Chodorow, Shannon Bradshaw. MongoDB: The Definitive Guide (Powerful and Scalable Data Storage), 3 ed. O'Reilly Media, 2018 - Stephen Few. Show Me the Numbers: Designing Tables and Graphs to Enlighten, 2nd Edition. Analytics Press, 2012 - Edward R. Tufte. The Visual Display of Quantitative Information. Graphics Press, 1983.

Exam: Computer-based written test using the PoliTo platform;

The exam lasts 90 minutes and consists of theoretical questions and written exercises, as described in the following: - [max 5 points] 3 multiple-choice questions on theoretical topics of the course, such as conceptual, logical, and physical data warehouse design, extended SQL language, technological characteristics of NoSQL databases and their usage, data management issues in distributed (non-relational) databases, data visualization techniques - [max 12 points] exercises on data warehousing, including 2 open and/or multiple-choice questions on data warehouse design, and 2 queries for data access in extended SQL (open questions with answers to be provided in a text box) - [max 9 points] 1 exercise on NoSQL database design and 1 query for data access (open questions with answers to be provided in a text box) - [max 5 points] 1 exercise on visualization analysis and design with open questions (answers to be provided in a text box) Students are not allowed to use textbooks, notes, or additional electronic devices (besides the PC with Respondus) during the exam. Exercises are evaluated according to the correctness of the proposed solution and to the appropriateness of the adopted resolution methodologies. Specific points for each exercise are indicated in the exam text. Multiple-choice questions have a penalty for wrong answers, whereas no-penalty no-points in case no answer is provided.

Exam: Computer lab-based test; Computer-based written test using the PoliTo platform;

The exam lasts 90 minutes and consists of theoretical questions and written exercises, as described in the following: - [max 5 points] 3 multiple-choice questions on theoretical topics of the course, such as conceptual, logical, and physical data warehouse design, extended SQL language, technological characteristics of NoSQL databases and their usage, data management issues in distributed (non-relational) databases, data visualization techniques - [max 12 points] exercises on data warehousing, including 2 open and/or multiple-choice questions on data warehouse design, and 2 queries for data access in extended SQL (open questions with answers to be provided in a text box) - [max 9 points] 1 exercise on NoSQL database design and 1 query for data access (open questions with answers to be provided in a text box) - [max 5 points] 1 exercise on visualization analysis and design with open questions (answers to be provided in a text box) Students are not allowed to use textbooks, notes, or additional electronic devices (besides the PC with Respondus) during the exam. Exercises are evaluated according to the correctness of the proposed solution and to the appropriateness of the adopted resolution methodologies. Specific points for each exercise are indicated in the exam text. Multiple-choice questions have a penalty for wrong answers, whereas no-penalty no-points in case no answer is provided.