Business Intelligence II
Objectives
The main goal of the Business Intelligence course covered in these two semester units is to give students the knowledge and competency related with decision support capacities provided by Business Intelligence processes, along with supporting Data Warehouse structures. These skills include an awareness of the market forces advocating Digital Transformation initiatives, development methodologies underlying modern Business Intelligence strategies and architectures, along with current information technological development in the fields of Business Analytics, Advanced Data Analysis, and Business Performance Management.
General characterization
Code
200013
Credits
7.5
Responsible teacher
Luís Pedro Lopes Batista
Hours
Weekly - Available soon
Total - Available soon
Teaching language
Portuguese. If there are Erasmus students, classes will be taught in English
Prerequisites
Basic knowledge in relational databases (SQL). An introductory-level SQL Crash course is offered at the start of the semester, to all students lacking a basic level of knowledge and experience in this subject area.
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 both lectures and labs.
In the lectures we will present the theoretical concepts, case studies and, possibly, some presentations from leading BI vendors. The applied component of the course will take place in the Labs, where students will be shown how to apply the concepts and theories presented in lectures, by leveraging the use of the Microsoft Business Intelligence Platform (SQL Server, SQL Server Management Studio, Visual Studio, along with limited use of Microsoft Azure cloud-based tools) as the teachers demonstrate and provide practical guidance on the joint development of a class project.
In addition, and so as to further reinforce the applied skills and methodologies that the students are learning, they will be required to implement group-based practical projects of their own choosing, as part of the assessment.
Evaluation method
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 exam (both seasons), irrespective of marks obtained in a) or b).
Subject matter
LECTURES
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 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 Dashboards
4.2 Dashboard Design Challenges
4.3 Dashboard Design Best Practices
4.4 Information Design
4.5 Bad Practices in Dashboard Design
4.6 Categorizing Dashboards
4.7 Typical Dashboard Data
4.8 Data Visualization Tips
LABS:
LAB 01: Overview of BI II Labs and Project Presentation
LAB 02: Introduction to SQL Server Analysis Services (Tabular)
LAB 03: Continuing our Cube adventure with IMSClass
LAB 04: Introduction to SQL Server Reporting Services
LAB 05: Introduction to Self-Service BI
LAB 06: Power BI Solution Development ("Hollywood Movies") Part A
LAB 07: Continuing Power BI with "Hollywood Movies" Part B
LAB 08: Continuing Power BI with "Hollywood Movies" Part C
LAB 09: Exploring Microsoft-based Cloud (Azure) BI Tools
Programs
Programs where the course is taught:
- Specialization in Information Analysis and Management
- Specialization in Risk Analysis and Management
- Specialization in Business Intelligence
- Specialization in Data Science for Marketing
- Specialization in Digital Marketing and Analytics
- Specialization in Information Systems
- Specialization in Marketing Intelligence
- Specialization in Marketing Research and CRM
- specialization in Digital Transformation
- Specialization in Business Intelligence – Working Hours
- Laboral - Especialização em Data Science for Marketing
- Specialization in Digital Marketing and Analytics
- specialization in Information Systems - working hours
- Specialization in Marketing Intelligence
- Master Degree in Data Driven Marketing
- PostGraduate in Information Analysis and Management
- PostGraduate Risk Analysis and Management
- PostGraduate in Business Intelligence
- PostGraduate in Data Science for Marketing
- PostGraduate Digital Marketing and Analytics
- PostGraduate Marketing Research e CRM
- PostGraduate Information Systems Management
- PostGraduate in Marketing Intelligence
- PostGraduate in Enterprise Information Systems
- Pós-Graduação em Transformação Digital