Excel & Python Analysis (EPA-MIM)

Área

AC Gestão > UC Mestrados

Activa nos planos curriculares

Management > Management > 2º Ciclo > Unidades Curriculares Obrigatórias > Excel & Python Analysis

Nível

2º Ciclo (M)

Tipo

Estruturante

Regime

Semestral

Carga Horária

Aula Teórica (T): 0.0 h/semana

Aula TeoricoPrática (TP): 1.38 h/semana

Trabalho Autónomo: 62.0 h/semestre

Créditos ECTS: 3.0

Objectivos

LO1 - To understand and use the main Ms Excel tools for Data Analysis in business
LO2 - To understand the basics of programming languages
LO3 - To use Python for Data Analysis
LO4 ? To develop data Analysis applications with Python

Programa

1. Basic Ms Excel worksheet concepts and organization
2. Main Functions in Excel
3. Pivot Table and Power Pivot in Excel
4. Scenarios and Sensitive analysis
5. Data visualization
6. Foundations of Python programming language
7. Data structure in Python
8. Programming basics: control structure and functions
9. Main libraries

Metodologia de avaliação

Expositive method with demonstration of the software applications followed by students' case or exercise resolution in a computer laboratory.
The evaluation includes individual (50%) and group work (50%) components, specifically, an individual final exam and a group work assignment project that is also presented to the class.

Bibliografia

Principal