-
Presentation
Presentation
The Decision Support Systems / Business Intelligence UC aims to ensure that there is an introduction to the theme of data analysis processes to support the areas of business management. In this sense, UC has a fundamental role in the study cycle in understanding the management and decision processes of organizations, as well as how to put data infrastructures at the service of the corporate business.
-
Class from course
Class from course
-
Degree | Semesters | ECTS
Degree | Semesters | ECTS
Bachelor | Semestral | 6
-
Year | Nature | Language
Year | Nature | Language
2 | Mandatory | Português
-
Code
Code
ULHT260-7303
-
Prerequisites and corequisites
Prerequisites and corequisites
Not applicable
-
Professional Internship
Professional Internship
Não
-
Syllabus
Syllabus
- DW Business Challenges
- DW Architectures
- Modeling the Data Warehouse ¿ Best Practices
- ETL Overview
- BI Databases
- Reporting Tools
- Build Reports
-
Objectives
Objectives
- Understand why companies need a BI environment
- What architecture components exists for BI
- Modelling Schemas for DW
- Know the several Data Manipulation Processes within a DW Environment
- What can a User get in a Reporting Interface
-
Teaching methodologies and assessment
Teaching methodologies and assessment
To be described
-
References
References
-
Bolton, J. (Ed.). (2019). Data Warehousing Essentials. Larsen and Keller Education.
-
Deckler, G. (2022). Learn Power BI: A comprehensive, step-by-step guide for beginners to learn real-world business intelligence, 2nd Edition (2nd ed. edition). Packt Publishing
-
Inmon, B., & Puppini, F. (2020). The Unified Star Schema: An Agile and Resilient Approach to Data Warehouse and Analytics Design. Technics Publications.
-
Kelly, N. (2021). Delivering Data Analytics: A Step-By-Step Guide to Driving Adoption of Business Intelligence from Planning to Launch (1st edition). Kogan Page.
-
Kimball, R. (2008). The Data Warehouse Lifecycle Toolkit, 2nd Edition (2 edition). Wiley.
-
Kimball, R. (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition (3 edition). Wiley.
-
-
Office Hours
Office Hours
-
Mobility
Mobility
No