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: Monday 9:00-11:00 or 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: Wednesday 14:30-16:30, Room 384/DO, Dept. of Computer Science.
  • Telephone +39-050-2212728

• [27-12-2019]: Results second midterm test and proposal for oral exam: results-second-midtermtest.pdf. If the proposed date and/or time is not fine for you please write me an email.
• [26-11-2019]: Additional Lectures: Friday, Nov 29, 14-16 room L1 and Friday, Dec 06, 14-16 room M.
• [23-11-2019]: Exam of the first mid-term test: Results
• [21-11-2019]: 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).
• [18-11-2019]: The lesson of Tuesday 19/11/2019 will be canceled.
• [02-11-2019]: Since we will do the mid-term on 5 Nov the next week the lesson of Thursday will be canceled
• [31-10-2019]: On November 4, 11-13, in Room C I'm organising an additional lesson dedicated to practice for the written exam.
• [02-10-2019]: Instructions for Microsoft tools installation are available in the Software section.
• [09-09-2019]: Lessons will start on Tuesday, 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: SQL Server 2016 Management Studio or SQL Server 2017 Management Studio and SQL Server 2016 Data Tools. For Data Tools my suggestion is to install the version SSDT for VS2015 17.4 which is the same version installed in the laboratory computer. Note: It is mandatory to install Integration Services and Analysis Services . So, during the installation you must select these two elements.
• Instruction for SQL Server will be available soon
  1. Optional (not recommended on laptops): SQL Server 2016 Developer Edition can be downloaded from Microsoft or can be downloaded from MSDN-AA.
• 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 (2019/2020)
• LABORATORY OF DATA SCIENCE (2018/2019)
• BUSINESS INTELLIGENCE LAB (2017/2018)