Strumenti Utente

Strumenti Sito


mds:lbi:start

LABORATORY OF DATA SCIENCE (2021/2022)

Instructors:

News

Hours and Rooms

Classes

Lessons will be held onilne by Teams Platform

Day of Week Hour Room
Monday 11:00 - 12:45 Teams
Thursday 09:00 - 10:45 Teams

Link to Teams module: https://teams.microsoft.com/l/team/19%3amm3HFMqMSvpUrGY2sMYlpzxQ-atdxhfXreRUHhvrODs1%40thread.tacv2/conversations?groupId=c196ac40-93a2-4436-adfe-a81af3d06eef&tenantId=c7456b31-a220-47f5-be52-473828670aa1

Learning Material

Slides & Registration of the classes

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

Past Exams

Software

F.A.Q.

Class calendar - (2021-2022)

Day Topic Slides Data/Software References Video Lectures Teacher
13.09 11:00-12:45 Lecture canceled
1. 16.09 09:00-10:45 Introduction. File data access. 2021-lds.01.introduction.pdf 2020-lds.02.bi_architectures.pptx.pdf 2020-lds.03.file_data_access.pptx.pdf - BI technology: An Overview of Business Intelligence Technology - File access: File System Interface Video1 Video2 Monreale
2. 20.09 11:00-12:45 Representation formats: CSV, FLV, ARFF, XML. Python Recap 2020-lds.04.python.pptx.pdf - File Formats: Introduction to data technologies(Chps. 5, 6), Weka ARFF Format, XRFF Format - Python reference: Free python book with exercises Video1 Video2 Pellungrini
3. 23.09 11:00-12:45 File Access in Python lds.05.fileaccess-python2021.pdf census.csv.zip Collection of files Partial Solutions to Python Exercises Video1 Video2 Pellungrini
4. 27.09 9:00-10:45 File Access in Python Practice lds.05.fileaccess-python2021.pdf census.csv.zip Collection of files Partial Solutions to Python Exercises csv to Arff conversion solution Video Pellungrini
5. 30.09 9:00-10:45 Python Exercises ex-customers.pdf ex-customers_solution.zip data-customers.zip lds.file.format.zip Video1 Video2 Video3 Pellungrini
04.10 11:00-12:45 Lecture canceled
6. 07.10 9:00-10:45 RDBMS access protocols: ODBC, OLE DB, JDBC. ODBC Programming. lds.06.relational_data_access-2021.pdf Monreale
7. 11.10 11:00-12:45 RDBMS access protocols: ODBC, OLE DB, JDBC. ODBC Programming. lds.06.relational_data_access-2021.pdf 2021-code-db-samples.zip Monreale
8. 14.10 9:00-10:45 Stratified sampling lds.07.sqlserver.pdf stratifiedsampling.zip Video Pellungrini

Exams

PROJECT

A project consists in a set of assignements corresponding to a BI process: data integration, construction of an OLAP cube, qurying of a OPLAP cube and reporting.

The project has to be performed by a team of 2 students (at most 3 after asking authorization for that to the teachers).

Project to be delivered within 31 December 2021

  • First part of the project consists in the assignments described here: lds_project_2021_part_1.pdf
  • Second part of the project cosist in the assignments described here:
  • Third part of the project cosist in the assignments described here:
  • Remember to re-submit all three parts of the project with your third part, as specified in the document above.
  • Dataset: data2021.zip
  • Deadline:

Project to be delivered during the exam sessions Students who did not deliver the above project within 31 December 2021 need to ask by email a new project to the teachers. The project that will be assigned will require about 2 weeks of work and after the delivery it will be discussed during the oral exam. For those students, the oral exams will also cover some practical parts that could not be included in the project.

Exam sessions

Session Date Time Room Notes Marks

Past Editions

mds/lbi/start.txt · Ultima modifica: 15/10/2021 alle 13:15 (10 ore fa) da Anna Monreale