Business Intelligence - Datawarehousing
The main objective of this course is to take students to understand the capabilities of decision support processes enhanced by the use of Business Intelligence and Data Warehouse.
Weekly - Available soon
Total - Available soon
Portuguese. If there are Erasmus students, classes will be taught in English
Databases (SQL Server)
Turban E.; Sharda R.; Dursun D. and King D. (2011). Business Intelligence: a managerial approach. Second Edition. Prentice Hall, ISBN: 013610066X. ; Inmon, William H. (2005). Building the Data Warehouse (4th Ed edition). Hungry Minds Inc,U.S., ISBN-10: 0764599445.; Kimball, R. and Ross, M. (2002). The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition). Wiley, ISBN-10: 0471200247.; Davenport, Thomas H. and Harris, Jeanne G. (2007). Competing on Analytics: The New Science of Winning. Harvard Business School Press, ISBN-10: 1422103323.; 0
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.
The evalution of the course includes:
a) Project (50%)
b) Final Exam (50%)
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
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
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
Fact Tables and Dimensions
Design and Implementation of Dimensional Schemes - Data Warehousing
Programs where the course is taught: