Banner gráfico
Banner gráfico - mobile

 


Model. Analyze. Decide.

 

Today, information produced by and in organizations is considered a resource as valuable as assets or capital. In a data-driven world, the ability to transform raw information into useful knowledge is an essential skill. The Micro-credentialing in Multidimensional Modeling and Business Intelligence course is designed to equip participants with the skills to use fundamental tools and methodologies to design effective data models and extract value through Business Intelligence (BI) solutions.

With a practical, case-oriented approach, this course explores the principles of multidimensional modeling, from designing star and snowflake schemas to building data cubes and using modern BI tools. Participants will learn how to structure data efficiently, optimize queries, and create reports and dashboards that support strategic decision-making.

Upon completion of the course, participants will be able to:

  • Design effective multidimensional data models;
  • Understand the fundamentals of Data Warehousing and OLAP;
  • Apply BI tools for data analysis and visualization;
  • Support organizational decisions based on structured and reliable data.
        

ECTS: 4

Objectives

Enable participants to design, implement and apply multidimensional data models, promoting efficient analysis of information through Business Intelligence tools, with a view to improving decision-making in organizations.

Professional Goals

The micro-credential in Multidimensional Modeling and Business Intelligence opens doors to several opportunities in the data and digital transformation sector. The skills acquired throughout the course are highly valued in organizations that want to improve their analysis, planning and decision-making processes based on structured data.

This training is an excellent asset for:

  • Managers and decision-makers who want to better interpret their organizations' data;
  • IT professionals transitioning to areas of analysis and Business Intelligence;
  • Students and recent graduates looking for a specialization with strong employability.
Plano curricular
Cód. UC Area ECTS Lecturer
Obg. Opt.
Anual
40261 Modelação Multidimensional e Business Intelligence 4

1. Introduction to Business Intelligence

-Basic BI concepts

-Data Warehousing Architectures

2. Multidimensional Modeling

-Fundamental principles and concepts

-Star schema and snowflake schema models

-Identification of dimensions, measures and performance metrics

3. ETL (Extract, Transform, Load)

-Data integration processes

4. Business Intelligence and Data Visualization Tools

-Use of Business Intelligence tool - Microsoft Power BI

-Production of reports and interactive dashboards

(1) Docente Responsável
(2) Docente que lecciona

Contacts

Course coordinator

Vasco Renato Marques Gestosa da Silva

Vasco Renato Marques Gestosa da Silva

Gabinete: B111
t.: 249 328 100
ext.: 2111
endereço de e-mail
NP4552
Financiamento
KreativEu
erasmus
catedra
b-on
portugal2020
centro2020
compete2020
crusoe
fct
feder
fse
poch
portugal2030
poseur
prr
santander
republica
UE next generation
Centro 2030
Lisboa 2020
Compete 2030
co-financiado