IPT Logotipo do IPT

Ano Letivo: 2020/21

Sistemas de Gestão Empresarial - SAP

<< back to Curriculum Plan

5 ECTS; 1º Ano, 2º Semestre, 24,0 TP , Cód. 20188.

Lecturer
- Vasco Renato Marques Gestosa da Silva (1)

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

Prerequisites

Objectives
The student should understand the concepts related to Business Intelligence (BI): BI, Data Warehouse, Dimensions, Facts (Measures) (1), know the phases of a BI process: Data sources, ETL process, Data Warehousing, procedures (2), acquire knowledge about the SAP Business Objects / BI platform: BI process in the SAP BO / BI system (3), obtain competencies in the use of BI solutions: performing exercises in SAP Lumira and Microsoft Power BI (4), manipulate and relate data for analysis: Data modeling, table creation, table relationship, obtaining data from various sources (5), creating reports and dashboards for data analysis: use of visual objects to create graphs, tables, maps and data visualization on mobile devices (6).

Program
A. Business Intelligence (BI) Concepts:
a. BI
b. Data Warehouse
c. Dimension
d. Fact (Measure)
B. Phases of a BI process:
a. Data Sources
b. ETL Process: Extract, Transform and Load
c. Data Warehouse
d. Analysis and reporting procedures, tables and dashboards
C. SAP Business Objects / BI:
a. Data Source
b. InfoObjects (IOBJ)
c. Advanced Data Store (ADSO)
d. Composite Provider
e. Query
f. BI Clients
D. BI Solutions:
a. SAP Lumira
b. Microsoft Power BI
E. Data Modeling:
a. Creating Tables
b. Relationship of tables
c. Obtaining data from various sources
d. Data types
e. Data correction
F. Creating reports and dashboards:
a. Graphics
b. Tables
c. Maps
d. Viewing data on mobile devices

Evaluation Methodology
Evaluation Exercise - 100%

Bibliography
- Freyburger, K. e Hagen, T. (2017). Data Warehouse Arquitecture. (Vol. 1). Alemanha: SAP Univertsity Alliances
- Siegling, A. e Deiter, D. (2017). SAP Business Objects BI. (Vol. 1). Alemanha: SAP UCC
- Siegling, A. e Deiter, D. (2017). SAP Lumira. (Vol. 1). Alemanha: SAP Univertsity Alliances
- Siegling, A. e Deiter, D. (2017). Web Intelligence. (Vol. 1). Alemanha: SAP Univertsity Alliances

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

Software used in class
SAP Lumira Desktop
SAP Lumira Discovery
SAP Dashboards
Web Intelligence
Microsoft Power BI

 

 

 


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