Visualização Interativa

Code:

M4139

Acronym:

M4139

Keywords
Classification	Keyword
CNAEF	Mathematics and statistics

Instance: 2022/2023 - 2S (edição n.º 1)

Active?	Yes
Responsible unit:	Department of Mathematics
Course/CS Responsible:	Computational Statistical Modelling

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
E:MEC	5	PE_Computational Statistical Modelling	1	-	3	21	81

Teaching language

Portuguese

Objectives

Introduction to data processing and interactive visualization. Particular attention is given to the creation of dynamic statistical analysis tools.

It is intended that the student acquires familiarity with software for reporting and integration of statistical analysis, namely Microsoft PowerBi and R.

Learning outcomes and competences

To develop skills in establishing relationships between data from different sources, as well as acquiring practical skills necessary for their presentation.

At the end of this curricular unit, the student:

• should acquire knowledge and experience on good practices in data processing, focusing on methodological aspects of its processing, analysis and representation;


• should be able to handle interactive visualization tools.

Working method

Presencial

Program

1. Brief introduction to Microsoft Power BI.

2. Preparing data for analysis (import and transformation).

3. Building data models (relationships and creating metrics).

4. Data representation and integration techniques with R.

5. Creating interactive reports and publishing documents.

Mandatory literature

Knight, D., Pearson, M., Schacht, B., Ostrowsky, E.; Microsoft Power BI Quick Start Guide, Packt Publishing, 2022. ISBN: 1800561571

Complementary Bibliography

Powell, B.; Mastering Microsoft Power BI: Expert techniques for effective data analytics and business intelligence, Packt Publishing, 2018. ISBN: 1788297237

Teaching methods and learning activities

Theoretical-practical classes with presentation and discussion of themes, group and individual exercises, with interpretation of the results of practical exercises.

Software

Power BI

Evaluation Type

Distributed evaluation with final exam

Assessment Components

designation	Weight (%)
Exame	20,00
Trabalho prático ou de projeto	80,00
Total:	100,00

Amount of time allocated to each course unit

designation	Time (hours)
Elaboração de projeto	0,00
Total:	0,00

Eligibility for exams

No requirements.

Calculation formula of final grade

The curricular unit will have its evaluation resulting from the completion of a practical work in a mandatory group with its respective presentation (80%) and a theoretical test (20%).

The theory test will take place during exam season.
The grade of the work and its presentation cannot be improved.

Classification improvement

The grade improvement can only be performed in the theoretical test component.