IPT Logotipo do IPT

Ano Letivo: 2020/21

Informática e Tecnologias Multimédia

Organisational Information Systems

<< back to Curriculum Plan

Publication in the Diário da República: Despacho n.º 12419/2016 - 14/10/2016

6 ECTS; 2º Ano, 2º Semestre, 45,0 PL + 30,0 TP + 5,0 OT , Cód. 814317.

Lecturer
- Vasco Renato Marques Gestosa da Silva (1)(2)

(1) Docente Responsável
(2) Docente que lecciona

Prerequisites
Not applicable

Objectives
The student should understand the differences between OLTP information systems and OLAP systems (1), understand the concepts related to Business Intelligence (BI) (2), know the steps of a BI process, regarding the data model, storage (Data Warehouse) and operations (production of reports and dashboards) (3), obtain skills in the use of BI solutions (4), manipulate and relate data for analysis (5) create reports and dashboards for data analysis (6), use the information system - SAP (7).

Program
A. OLTP (Online Transaction Processing) information systems and OLAP (Online Analytical Processing) systems
B. Business Intelligence (BI) concepts:
a. BI
b. Data Warehouse
ç. Dimension
d. Fact (Measure)
C. Stages of a BI process:
a. Data sources
b. ETL process: Extract, Transform and Load
ç. Data Warehouse
d. Analysis procedures and creation of reports, tables and dashboards
D. BI solutions:
a. Microsoft Power BI
b. IBM Cognos Insight
ç. SAP Lumira Desktop
d. SAP Discovery
E. Data modeling:
a. Creating tables
b. Table relationship
ç. Obtaining data from various sources
d. Types of data
e. Data correction
F. Creation of reports and dashboards:
a. Graphics
b. Tables
ç. Maps
d. Viewing data on mobile devices
G. SAP GUI system - Modules:
a. Sales and Distribution
b. Accounting Systems
ç. Materials and Purchasing
d. Human Resources

Evaluation Methodology
Evaluation exercises - 30%
Evaluation project - 70%

Bibliography
- Seigling, A. e Deiter, D. (2017). SAP Lumira. (Vol. 1). Alemanha: SAP Univertsity Alliances
- Seigling, A. e Deiter, D. (2017). Web Intelligence. (Vol. 1). Alemanha: SAP Univertsity Alliances
- Siegling, A. e Deiter, D. (2017). SAP Business Objects BI. (Vol. 1). Alemanha: SAP Univertsity Alliances

Teaching Method
The curricular unit is organized in practical laboratory sessions in which the programmatic contents are taught, supported by presentations, as well as practical exercises to apply the acquired concepts.

Software used in class
Microsoft Power BI
IBM Cognos Insight
SAP Lumira Desktop
SAP GUI
Modle

 

 

 


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