Universidade Nova de Lisboa

Courses Catalogue

We welcome you to explore NOVA’s academic offerings.
Our catalogue provides a description of the courses offered at NOVA as well as useful information about our Schools.

more info Courses Catalogue

Instituto Superior de Estatística e Gestão de Informação

Business Intelligence I

Code

42325

Academic unit

Instituto Superior de Estatística e Gestão de Informação

Credits

7,5

Teacher in charge

João Pedro Salgueiro Lourenço

Weekly hours

2

Teaching language

Portuguese. In case there are any Erasmus students the class will be in English

Objectives

The main purpose of Business Intelligence I course is to make students understand the capabilities of decision support processes enhanced by the use of Business Intelligence and Data Warehouse Support, and get to know the current information technologies and methodologies to develop solutions Business Intelligence at our disposal.At the end of the course, students should be able to:

  • Understanding the process of BI and the factors that contribute to maximize the business value
  • Know the main business applications of Business Intelligence / Data Warehouse
  • Identify the key indicators of analytical applications in the enterprise context
  • Know the main approaches to building data warehouses
  • Understanding the relationship between Business Intelligence and Data Warehousing
  • Understanding the role of analytical applications, monitoring the performance of organizations and visualization tools
  • Knowing the components of the infrastructure of the Business Intelligence - people, processes and technologies

Subject matter

T.1 – Business IntelligenceT1.1 Introduction to Business IntelligenceT1.2 A Framework for Business Intelligence (BI)T1.3 Intelligence Creation and Use and BI GovernanceT1.4 The Major Theories and Characteristics of Business IntelligenceT1.5 Toward Competitive Intelligence and AdvantageT1.6 Successful Business Intelligence Implementation T1.7 Business Intelligence Today and Tomorrow T.2 – Data WarehousingT2.1 Data Warehousing Definitions and ConceptsT2.2 Data Warehousing Process Overview T2.3 Data Warehousing ArchitecturesT2.4 Data Integration and the Extraction, Transformation and Loading (ETL) ProcessesT2.5 Data Warehouses DevelopmentT2.6 Real-Time Data WarehousingT2.7 Data Warehouses Administration and Security Issues Labs*L.1 Business Intelligence Labs Presentation               Microsoft BI Platform PresentationL.2 SQL Server Management Studio                Relational Data Bases Overview                Relational Data base Development L.3 SQL Business Intelligence Development Studio                Introduction to Data Warehouse Systems.                 OLTP versus OLAP                Metadata.                Microsoft Data Warehousing Tools – First Steps L.4 SQL Server Integration Services                ETL Process – Basic                Microsoft SQL Server Integration Services – BasicL.5 SQL Server Management Studio                Multidimensional Models.                 Fact Tables and Dimensions                Design and Development of Dimensional Schemas – Data WarehousingL.5 SQL Server Integration Services                ETL Process – Advanced                Microsoft SQL Server Integration Services – Advanced 

Bibliography

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.

Courses