bdd-infuma:start
Indice
ICT: Business intelligence and CRM
Teacher
Anna Monreale
- KDD Laboratory, Università di Pisa ed ISTI - CNR, Pisa
EXAM
- Project to be delivered by email within 15 May 2020:exam-mains-2020-final.pdf
- Note that in the last page of the project description the student can find the instructions to be followed for the delivery.
Learning Material
Software
- SQL Server 2016 Developer Edition:
- Mandatory: SQL Server 2017 Management Studio
- For students with Mac OSX or Linux: Valentina Studio
- Reporting Software: we will use an online tool: https://www.qlik.com/us/trial/qlik-sense-business: please before Monday 27, you need to do the registration.
Data
Class Calendar 2020
Day | Topic | Learning material | Book | |
---|---|---|---|---|
1. | 17.02.2020 14:00-18:00 | Introduction – Relational Model Conceptual modeling | a.introduction.pdf b.modellorelazionale.pdf c.conceptualmodel.pdf Model of University DBExercises Conceptual Modelling | DB Essentials |
2. | 24.02.2020 14:00-18:00 | Logical Modeling - Exercises on Conceptual & Logical Modeling | c.logicalmodel.pdf conceptual_logicalmodel-companies.jpeg logicalmodel-university.jpeg | DB Essentials |
3. | 10.03.2020 14:00-18:00 | Exercises on Conceptual & Logical Modeling. SQL | exmodelling-10march.pdfe.sql-concettibase.pdf | DB Essentials |
4. | 23.03.2020 14:00-18:00 | Exercises on SQL + Advances SQL & Exercises | text-ex-sql.pdf assignment-23-03.pdf sol-exsql.zip | DB Essentials |
5. | 27.03.2020 09:00-13:00 | Exercises on SQL + Decision Support Systems + Data Warehouses Conceptual Modeling | 3-sol-market-queries.sql.zip f.dwconcept.pdf Do Exercises in Appendix A of this book | BOOK: Decision Support Databases Essentials |
6. | 30.03.2020 14:00-18:00 | Data Warehouses Logical Modeling - Exercises on DW models | dwlogical.pdf Ex-Hospital Ex-FlightSeats | |
7. | 02.04.2020 14:00-16:00 | Exercises on DW models | ||
8. | 06.04.2020 14:00-16:00 | olap - sql reporting | h.olap.pdf ex-inventory-hotels.pdf inventory-metrics.pdf | |
9. | 07.04.2020 14:00-16:00 | Querying DW | sqlan.sql.zip Text of Exercises | |
10. | 16.04.2020 09:00-11:00 | Querying DW Exercises | l-analytics-sqlreporting.pdf sol-assignment-aq.zip assignment-aq-2.pdf | |
11. | 21.04.2020 14:00-16:00 | Final Exam Presentaion + Exercises | assignment-aq-3.pdf sol-assignment2-aq.zip | |
12. | 27.04.2020 09:00-11:00 | Reporting + Exercises | Reporting Software: we will use an online tool: https://www.qlik.com/us/trial/qlik-sense-business: please before Monday 27, you need to do the registration. – https://meet.google.com/dcy-dqvb-eub sol-assignment3-aq.sql.zip |
bdd-infuma/start.txt · Ultima modifica: 03/05/2020 alle 14:25 (4 anni fa) da Anna Monreale