2nd Module of Business Performance Analysis (Analisi delle prestazioni aziendali)

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

• [02-01-2018] The results of the second midterm are online: Results 2nd midterm. Note that in the file you can find the date of the oral exam.
• [22-11-2017] Exam Rules: a) Students may do the second mid-term even if they did have the first mid-term. b) Students having at least one mid-term exam may do only one part of the written exam in the exam sessions.
• [13-11-2017] 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).
• [24-10-2017] Instructions for using the Microsoft Software in the Computers of the LAB:
  • Activate the Internet connection
  • Start the Microsoft Software
  • Signin with your login of Alice: [email protected] and password
• [09-10-2017] In the java program XMLSample.java please substitute the two URL of the files in the main function with :

“http://kdd.isti.cnr.it/sites/kdd.isti.cnr.it/files/census_elements.xml” “http://kdd.isti.cnr.it/sites/kdd.isti.cnr.it/files/census_row_0.xml” otherwise you will get an error.

• [09-10-2017] This week the office hours will be on Friday 13, October at 9-11. Please, send an email within Thursday 12th if you want to come to my office on Friday.

Classes

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

Office hours

Prof. Anna Monreale: by appointment, 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.

• Eclipse IDE for Java developers and Java
• 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

• 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.

BUSINESS INTELLIGENCE LAB (2017/2018)