Teacher:

• Anna Monreale
  • KDD Laboratory, Università di Pisa ed ISTI - CNR, Pisa
  • http://kdd.isti.cnr.it/homes/monreale/
  • anna [dot] monreale [at] unipi [dot] it
  • Office hours by appointment, Room 374/DO, Dept. of Computer Science.
  • Telephone +39-050-2213119

Teaching assistant:

• Roberto Pellungrini
  • KDD Laboratory, Università di Pisa and ISTI - CNR, Pisa
  • roberto [dot] pellungrini [at] di [dot] unipi [dot] it
  • Office hours: Thursday 14:30-16:30, Room 384/DO, Dept. of Computer Science.
  • Telephone +39-050-2212728

• [11-02-2019]:Results of the written exam of 06/02/2019 Results and Oral dates
• [21-01-2019]:Results of the written exam of 16/01/2019 Results and Oral dates
• [27-12-2018]:Results of the second midterm Results and Oral dates
• [01/12/2018]: Text of Exercises in MDX and Analytical SQL: exercises_mdx.pdf
• [13-11-2018]:Results of the first midterm Results
• [07-11-2018]:Instructions for the SSAS project in the Lecture of today: to avoid conflicts in deployment/process follow this steps once the solution is opened: (1) rename the project as <your account>_foodmart; (2) from project properties select 'Deployment', then rename the database as <your account>_foodmart; (3) click on the button “show all files” just above “Solution explorer” right click on “view code” on the .database file that is visualized, and then change the ID from ruggieri_foodmart into <your account>_foodmart, and finally save the file; (4) change the credentials of connection to database on SQL Server. As an alternative solution you mayimport the project from the SSAS server and rename it as <your account>_foodmart (step 4 is still necessary).
• [20-10-2018]: Here you can find exercises simular to those you can find in the first mid-term. Please try to address them and on October 25, 2018 during the lesson we will discuss the solutions.
• [09-10-2018]: The lesson of Sept, 17 will be recovered on October 25, 2018 Room M
• [09-09-2018]: Lessons will start on Monday, 24th. Please, see details below.

Classes

Lessons will be held at: Polo Didattico “L. Fibonacci”, Via F. Buonarroti 4, Pisa.

Office hours by appointment, Room 374/DO, Dept. of Computer Science.

• The slides used in the course will be inserted in the calendar after each class.
• Registration of each lecture will be published in the calendar after each class

• 2016/17 text, 2015/16 text and 2015/16 solution, 2014/15 text and 2014/2015 solution, 2013/14 text, 2012/13 text and 2012/13 solution.

• Anaconda with Python 3.5
• SQL Server 2016 Developer Edition:
  1. Mandatory: SQL Server 2016 Management Studio and SQL Server 2016 Data Tools (no need to install Microsoft Visual Studio 2015! choose option 4 “Download SSDT as an ISO image”)
  2. Optional (not recommended on laptops): SQL Server 2016 Developer Edition can be downloaded from Microsoft or can be downloaded from MSDN-AA. During installation, set the following options as a minimum.
• Microsoft Excel
• Power BI Desktop
• WEKA: https://www.cs.waikato.ac.nz/ml/weka/
• WEKA API: Wrapper in Python - https://pypi.org/project/python-weka-wrapper/

• Connection to wi-fi
• F.A.Q.s about the labs

Rule: Students may do the second mid-term even if they did have the first mid-term.

Rule: Students having at least one mid-term exam may do only one part of the written exam in the exam sessions.

• LABORATORY OF DATA SCIENCE (2018/2019)
• BUSINESS INTELLIGENCE LAB (2017/2018)