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
Not applicable
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
- Deiter, D. e Siegling, A. (2017). Web Intelligence. (Vol. 1). Alemanha: SAP Univertsity Alliances
- 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
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
Microsoft Power BI
