IPT Logotipo do IPT

Ano Letivo: 2016/17

Analítica e Inteligência Organizacional

Analytical System Architecture

<< back to Curriculum Plan

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
- Ricardo Nuno Taborda Campos (2)
- Vasco Renato Marques Gestosa da Silva (2)
- Célio Gonçalo Cardoso Marques (2)

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

 

 

 


<< back to Curriculum Plan
NP4552
Financiamento
KreativEu
erasmus
catedra
b-on
portugal2020
centro2020
compete2020
crusoe
fct
feder
fse
poch
portugal2030
poseur
prr
santander
republica
UE next generation
Centro 2030
Lisboa 2020
co-financiado