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 II

Code

42326

Academic unit

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

Credits

7,5

Teacher in charge

Miguel de Castro Neto

Weekly hours

2

Teaching language

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

Objectives

The main objective of the Business Intelligence II course is to give students the knowledge related to the capabilities of decision support processes enhanced by the use of Business Intelligence and Data Warehouse support in the field of Business Analytics and Performance Management.At the end of the course students should be able to:& ; Understand the role of analytical applications and techniques of information visualization& ; Master models for monitoring the performance of organizations& ; Understand the analysis techniques used in analytical applications& ; Develop ergonomic visualization tools

Subject matter

LECTUREST.1  – Business Analytics and Data Visualization1.1  Introduction to Business Analytics (BA)1.2 Online Analytical Processing (OLAP)1.3 Querying and Reporting1.4 Multidimensionality1.5 Advanced1.6 Data visualization1.7 Geographic Information Systems1.8 Real time Business Intelligence, automated decision support and Competitive Intelligence1.9 Business Analytics and the Web: Web Intelligence and Web Analytics1.10 Business Analytics usage, benefits and results
T.2  – Data, Text and Web Mining2.1 Concepts and applications of Data Mining2.2 Concepts and applications of Text Mining2.3 Concepts and applications of Web Mining
T.3 – Business Performance Management3.1 Business Performance Management (BPM) Overview3.2 Strategize: Where do we want to go?3.3 Plan: How do we get there?3.4 Monitor: How are we doing? 3.5 Act and adjust: What do we need to do differently?3.6 Performance Measurement3.7 BPM Methodologies3.8 BPM Technologies and applications3.9 Performance dashboards and scorecards T.4 - Information Dashboard Design4.1 Introduction to dashboard design4.2 Using dashboards4.3 Most common mistakes in dashboard design4.4 The power of visual perception4.5 Eloquence trough simplicity4.6 Efective information presentation with dashboards4.7 Designing user friendly dashboards
LABORATÓRIOS L.1 SQL Server Management Studio  1.1 BI II Labs presentation 1.2 Projects ananlysis and preparation 1.3 Business Intelligence I content revisionL.2 Building OLAP Cubes with SSAS – Basic 2.1 Introduction to SQL Server Analysis Services SSAS 2.2 Dimensions creation 2.3 Unbalanced relations  2.4 Metrics creation in SSAS 2.5 OLAP Cubes creation in SSASL.3 Building OLAP Cubes with SSAS – Advanced 3.1 Advanced mode parametrization and configuration 3.2 OLAP perspectives 3.3 OLAP partitions 3.4 Multiple OLAP cubes integrationL.4 Using Data Mining in SSASL.5 Report Development 4.1 PowerPivot  - Excel as a reporting toolL.6 Report Development – Basic 6.1 Introduction to SQL Server Reporting Services SSRS 6.2 Analysis of SSRS components and funcionalities 6.3 Building reports6.4 Data Sources Tool L.7 Report Development – Advanced 7.1 Building reports 7.2 Design Tool  7.3 Layout Tool L.8 Sharepoint as a reporting tool

Bibliography

Turban E.; Sharda R.; Dursun D. and King D. (2011). Business Intelligence: a managerial approach. Second Edition. Prentice Hall, ISBN: 013610066X.
Howson, C. (2008). Successful business intelligence : secrets to making BI a killer app. McGraw Hill. ISBN 978-0-07-149851-7
Few, Stephen (2006). Information Dashboard Design: The Effective Visual Communication of Data. Sebastopol, CA: O’Reilly Media. ISBN 0596100167
Eckerson, Wayne W. (2006). Performance Dashboards: Measuring, Monitoring, and Managing Your Business. Hoboken, NJ: John Wiley & Sons. ISBN 0750661747

Courses