Publication in the Diário da República: Despacho n.º 11262/2016 - 19/09/2016
8 ECTS; 1º Ano, Anual, 20,0 T + 12,0 PL + 20,0 TP + 4,0 S + 32,0 OT + 10,0 O , Cód. 39323.
Lecturer
(1) Docente Responsável
(2) Docente que lecciona
Prerequisites
Not applicable
Objectives
The student must know applications for search information (1); know what is Cloud Computing (2); manipulate web analytics tools (3); competitive intelligence (4); use BI tools in the organizational context (5); see the evolution of relational data models for dimensional data models (6).
Program
1. Introduction to Information Retrieval and Search Engines;
- What is IR?
- IR Services;
- Databases vs IR;
- IR Applications;
- IR Task;
- IR Architecture;
- Ethichs and Data Privacy;
2. Cloud Computing:
- Historical context;
- Features;
- Services;
- Models;
- Implementation.
3. Web Analytics:
- Concept;
- Tools;
- Implementation.
4. Competitive Intelligence (Competitive Intelligence):
- Concept;
- Tools;
- Implementation.
5. Business Intelligence in social networks:
- Business Intelligence and social media;
- Crisis management in social networks;
- Business Intelligence 2.0.
6. Components of an analytical system (BI):
- Sources;
- Process ETL;
- Data Warehouse:
- Reports;
7. Relational model and multidimensional data model;
- Normalization;
- Denormalisation;
8. SQL - Structured Query Language:
- DDL commands;
- DML commands;
9. BI Tools:
- Microsoft SQL Server;
- Cognos Insight.
Evaluation Methodology
Realization of 3 projects and its public discussion.
Project I: 30%
Project II: 40%
Design III: 30%
Each project mentioned above with must have a minimum score of 7 in 20, to dispense exam.
Bibliography
- Beasley, M. (2013). Practical Web Analytics for User Experience: How Analytics Can Help You Understand Your Users. Waltham: Morgan Kaufmann
- Burke, C. (2014). Competitive Intelligence the Internet Way. s.l.: SB2 Group
- Croft, B. e Metzler, D. e Strohman, T. (0). Search Engines: Information Retrieval in Practice. Acedido em 11 de janeiro de 2016 em http://ciir.cs.umass.edu/irbook/
- Mahmood, Z. e Puttini, R. e Erl , T. (2013). Cloud Computing: Concepts, Technology & Architecture. s.l.: Prentice Hall
Teaching Method
Exposure of the syllabus to students using the lecture and demonstration method. Analysis and resolution of practical cases.
Software used in class
Tools related to social media, web analytics and competitive intelligence;
Moodle.
Microsoft SQL Server;
Cognos Insight.
