Questa è una vecchia versione del documento!
Instructors:
Classes
Lessons will be held onilne by Teams Platform
Day of Week | Hour | Room |
---|---|---|
Tuesday | 11:00 - 12:45 | Teams |
Thursday | 11:00 - 12:45 | Teams |
Link to Teams module: https://teams.microsoft.com/l/team/19%3ad3bfc8ae4ed04ea99ccd7857a43e101e%40thread.tacv2/conversations?groupId=eb724cb5-3ac7-4b8e-9280-05e191cf8477&tenantId=c7456b31-a220-47f5-be52-473828670aa1
Day | Topic | Slides | Data/Software | References | Teacher | |
---|---|---|---|---|---|---|
1. | 15.09 11:00-12:45 | Introduction. File data access. Representation formats: CSV, FLV, ARFF, XML | 2020-lds.01.introduction.pptx.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 - File Formats: Introduction to data technologies(Chps. 5, 6), Weka ARFF Format, XRFF Format | Monreale | |
2. | 17.09 11:00-13:00 | Python Recap | 2020-lds.04.python.pptx.pdf | Free Python book: http://www.spronck.net/pythonbook/ | Pellungrini | |
3. | 22.09 11:00-13:00 | File Access in Python | 2020-lds.05.fileaccess-python.pptx.pdf | census.csv.zip csv2arrf.py.zip Collection of files | Pellungrini | |
4. | 24.09 11:00-13:00 | Lab practice: XML2CSV/CSV2JSON file format conversion | lds.file.format.zip | Pellungrini | ||
5. | 29.09 11:00-13:00 | Python Exercises | ex-customers.pdf | data-customers.zip ex-customers_solution.zip | Pellungrini | |
6. | 01.10 11:00-13:00 | RDBMS access protocols: ODBC, OLE DB, JDBC. ODBC Programming. | lbi.06.relational_data_access-complete.pdf | Monreale | ||
7. | 06.10 11:00-13:00 | RDBMS access protocols: ODBC, OLE DB, JDBC. ODBC Programming. | lbi.06.relational_data_access-complete.pdf | code-db-samples.zip | Monreale | |
8. | 08.10 11:00-13:00 | Stratified Sampling Ex, SQL Management Studio Demo, Project Explaination | lds.07.sqlserver.pdf | stratifiedsampling.zip | Monreale, Pellungrini | |
9. | 13.10 11:00-13:00 | ETL, Sequel Server Data Tools Demo | lds.08.etlandssis.pdf | lds_first_project.zip | Pellungrini | |
10. | 15.10 11:00-13:00 | SSIS exercises | ex-midterm.pdf | Pellungrini | ||
11. | 20.10 11:00-13:00 | stratified sampling with SSIS + SSIS practice | 2015midterm1text.pdflds_first_project.zip | Monreale/Pellungrini | ||
12. | 22.10 11:00-13:00 | SSIS practice + Project support | 2015midterm1text.pdf | Monreale/Pellungrini | ||
13. | 27.10 11:00-13:00 | SSIS: Surrogate Keys | Monreale/Pellungrini | |||
14. | 29.10 11:00-13:00 | SSIS: slowly changing dimensions | 2016ssis.zip | Monreale/Pellungrini | ||
15. | 03.11 11:00-13:00 | Datawarehousing and OLAP recap. Data cubes, analytic SQL, and materialized views in SQL Server. | lds.09.dwandolap.pdf | Monreale/Pellungrini | ||
16. | 05.11 11:00-13:00 | OLAP with SQL Server Analysis Services (SSAS): data source views, dimensions, | lds.09.dwandolap.pdf lds.10.ssas.pdf | 1) SSAS (olap): documentation; 2) S. Harinath et al. Professional Microsoft SQL Server Analysis Services 2012 with MDX and DAX, Wrox publisher, 2012. Chps. 4-6. | Monreale/Pellungrini | |
17. | 10.11 11:00-13:00 | OLAP with SQL Server Analysis Services (SSAS): dimensions, hierarchies. Data cubes, Parent-child hierarchies. OLAP explorative data analysis with Pivot Tables in Excel. | lds.10.ssas.pdf | monreale_foodmart.zip Notice: Please read the instructions in the Section NEWS! | Pivot Tables in Excel: G. Harvey. Excel 2013 All-in-One For Dummies, 2013. Chp. VII-2. | Monreale/Pellungrini |
18. | 12.11 11:00-13:00 | OLAP explorative data analysis with Pivot Tables in Excel. | foodmartexplorative.xlsx | Monreale/Pellungrini | ||
19. | 17.11 11:00-13:00 | Introduction to MDX | Monreale/Pellungrini | |||
20. | 19.11 11:00-13:00 | Introduction to MDX | mdx-practice-2020.txt.zip mdx-ex.pdf | Monreale |
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).
Session | Date | Time | Room | Notes | Marks |
---|
Date | Time | Room | Notes | Results |
---|---|---|---|---|