Business Intelligence I

Objetivos

O principal objetivo do curso de Business Intelligence é dar aos alunos os conhecimentos e competências relacionados com as capacidades de apoio à decisão fornecidas pelos processos de Business Intelligence e os Data Warehouses de suporte, incluindo as metodologias de desenvolvimento e as tecnologias de informação hoje disponíveis na área de Business Analytics e Business Performance Management.

Caracterização geral

Código

200012

Créditos

7.5

Professor responsável

Duarte Nuno Antunes Caracol Barros Rodrigues

Horas

Semanais - A disponibilizar brevemente

Totais - A disponibilizar brevemente

Idioma de ensino

Português. No caso de existirem alunos de Erasmus, as aulas serão leccionadas em Inglês

Pré-requisitos

Databases (SQL Server)

Bibliografia

Método de ensino

This course will include lectures and labs.
In the lectures will consist of theoretical concepts, case studies and presentations from leading BI vendors.
The applied component of the course will include several computer labs where students will apply the concepts and theories presented in lectures leveraging the Microsoft Business Intelligence Platform (SQL Server, SQL Business Intelligence Development Studio).
In this context the students will have to develop a project.

Método de avaliação

The assessment includes:
a) Project (50%)
b) Final exam (50%)
To successfully complete the course students must obtain a minimum score of 9.5 in the final examination, irrespective of marks obtained in a) or b).

Conteúdo

T.1 - Business Intelligence
T1.1 Business Intelligence Framework
T1.2 Architecture and Components of Business Intelligence ( BI )
T1.3 Creation and use of intelligence and governance of BI
T1.4 Key theories and features of Business Intelligence
T1.5 Competitive Intelligence
T1.6 Implementation of Business Intelligence
T1.7 The future of Business Intelligence
T.2 - Data Warehousing
T2.1 Definitions and concepts of Data Warehousing
T2.2 The process of Data Warehousing
T2.3 Data Warehousing Architectures
T2.4 Data Integration and ETL processes - Extraction , Transformation and Loading
T2.5 Development of Data Warehouses
T2.6 Data Warehousing in real time
T2.7 Administration and Security of Data Warehouses
laboratories
L.1 SQL Server Management Studio
         Introduction to Relational Databases
         Implementation of a Relational Database
L.2 SQL Business Intelligence Development Studio
         Introduction to Data Warehouse Systems .
         OLTP vs OLAP
         metadata
         Microsoft Data Warehousing Tools - Getting Started
L.3 SQL Server Integration Services
         Process ETL Process - Basic Mode
         Microsoft SQL Server Integration Services - Basic Mode
L.4 SQL Server Integration Services
         Process ETL Process - Advanced Mode
         Microsoft SQL Server Integration Services - Advanced Mode
L.5 SQL Server Management Studio
         Multidimensional models
         Fact Tables and Dimensions
         Design and Implementation of Dimensional Schemes - Data Warehousing

Cursos

Cursos onde a unidade curricular é leccionada: