ICT: Business intelligence and CRM

Teacher

Anna Monreale

KDD Laboratory, Università di Pisa ed ISTI - CNR, Pisa
http://www-kdd.isti.cnr.it
anna [dot] monreale [at] unipi [dot] it

EXAM

Project to be delivered by email within 15 May 2020:exam-mains-2020-final.pdf
Note that in the last page of the project description the student can find the instructions to be followed for the delivery.

Learning Material

Slides
Databases essentials - Antonio Albano PDF File
A First Course in Database Systems, JefferyD. Ullman and Jennifer Widom
Decision Support Databases Essentials - Antonio Albano PDF File

Software

SQL Server 2016 Developer Edition:
1. Mandatory: SQL Server 2017 Management Studio
For students with Mac OSX or Linux: Valentina Studio
Reporting Software: we will use an online tool: https://www.qlik.com/us/trial/qlik-sense-business: please before Monday 27, you need to do the registration.

Data

Class Calendar 2020

	Day	Topic	Learning material	Book
1.	17.02.2020 14:00-18:00	Introduction – Relational Model Conceptual modeling	a.introduction.pdf b.modellorelazionale.pdf c.conceptualmodel.pdf Model of University DB Exercises Conceptual Modelling	DB Essentials
2.	24.02.2020 14:00-18:00	Logical Modeling - Exercises on Conceptual & Logical Modeling	c.logicalmodel.pdf conceptual_logicalmodel-companies.jpeg logicalmodel-university.jpeg	DB Essentials
3.	10.03.2020 14:00-18:00	Exercises on Conceptual & Logical Modeling. SQL	exmodelling-10march.pdf e.sql-concettibase.pdf	DB Essentials
4.	23.03.2020 14:00-18:00	Exercises on SQL + Advances SQL & Exercises	text-ex-sql.pdf assignment-23-03.pdf sol-exsql.zip	DB Essentials
5.	27.03.2020 09:00-13:00	Exercises on SQL + Decision Support Systems + Data Warehouses Conceptual Modeling	3-sol-market-queries.sql.zip f.dwconcept.pdf Do Exercises in Appendix A of this book	BOOK: Decision Support Databases Essentials
6.	30.03.2020 14:00-18:00	Data Warehouses Logical Modeling - Exercises on DW models	dwlogical.pdf Ex-Hospital Ex-FlightSeats
7.	02.04.2020 14:00-16:00	Exercises on DW models
8.	06.04.2020 14:00-16:00	olap - sql reporting	h.olap.pdf ex-inventory-hotels.pdf inventory-metrics.pdf
9.	07.04.2020 14:00-16:00	Querying DW	sqlan.sql.zip Text of Exercises
10.	16.04.2020 09:00-11:00	Querying DW Exercises	l-analytics-sqlreporting.pdf sol-assignment-aq.zip assignment-aq-2.pdf
11.	21.04.2020 14:00-16:00	Final Exam Presentaion + Exercises	assignment-aq-3.pdf sol-assignment2-aq.zip
12.	27.04.2020 09:00-11:00	Reporting + Exercises	Reporting Software: we will use an online tool: https://www.qlik.com/us/trial/qlik-sense-business: please before Monday 27, you need to do the registration. – https://meet.google.com/dcy-dqvb-eub sol-assignment3-aq.sql.zip