Business Intelligence
Objectives
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, namely Business Analytics and Performance Management.
General characterization
Code
200011
Credits
6.0
Responsible teacher
Miguel de Castro Simões Ferreira Neto
Hours
Weekly - Available soon
Total - Available soon
Teaching language
Portuguese. If there are Erasmus students, classes will be taught in English
Prerequisites
Data Warehousing
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; 0
Teaching method
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.
Evaluation method
The assessment includes:
a) Project
b) Final Exam
Final grade calculated based on the following formula:
a) 50%
b) 50%
Subject matter
T.1 - Business Analytics and Data Visualization
1.1 Introduction to the field of Business Analytics ( BA )
1.2 Online Analytical Processing ( OLAP )
1.3 Reports and Queries
1.4 Multidimensionality
1.5 Advanced Business Analytics
1.6 Data Visualization
1.7 Geographic Information Systems
1.8 Business Intelligence real-time decision support and automated Competitive Intelligence
1.9 and Web Analytics : Web Intelligence and Web Analytics
1.10 Use , Benefits and Results of Business Analytics
T.2 - Data, Text and Web Mining
2.1 Concepts and Applications of Data Mining
2.2 Concepts and Applications of Text Mining
2.3 Concepts and Applications of Web Mining
T.3 - Business Performance Management
3.1 Introduction to Business Performance Management ( BPM )
3.2 Strategy
3.3 Planning
3.4 Monitoring
3.5 Acting and adjusting
3.6 Performance Measurement
3.7 BPM Methodologies
3.8 Architecture and applications of BPM
3.9 Performance Dashboards
3.10 Business Activity Monitoring ( BAM )
T.4 - Information Dashboard Design
4.1 Introduction to the design of dashboards
4.2 Scope of Use of Dashboards
Programs
Programs where the course is taught:
- Major in Business Analytics
- Major in Data Science
- PostGraduate in Information Management and Business Intelligence in Healthcare
- PostGraduate in Enterprise Information Systems
- Postgraduate Program in Statistical Systems with a specialization in Central Banks
- Postgraduate Program in Statistical Systems with a specialization in Official Statistics