Data Mining case studies (KNIME Analytics)

21 Abril 2016, 10:30 • ANA MARIA MARQUES RIBEIRO DOS SANTOS LUCAS

Esta aula substitui a de 2016/04/28

Classification: decision tree, naïve Bayes, and artificial neural networks

---

Data Mining, Classification I

14 Abril 2016, 14:00 • ANA MARIA MARQUES RIBEIRO DOS SANTOS LUCAS

In this lecture the students have learnt what data mining means and which categories of data mining tasks exist. Some common terms and concepts are introduced (algorithm, heuristic, cross-validation, overfitting, pruning etc.) Three classification methodologies and its underlying ideas are presented: Naïve Bayes, Decision Trees, and Artificial Neural Networks. A demonstration in KNIME Analytics (credit rating example) is given as an outlook concerning the lectures of the next week.

---

Data Warehousing

7 Abril 2016, 14:00 • ANA MARIA MARQUES RIBEIRO DOS SANTOS LUCAS

 

(esta aula teve lugar em 2016/04/14 das 10:30 às 12:30)

In this lecture the students have learnt why a data warehouse is needed in a business intelligence environment. The differences between OLTP and OLAP systems are explained. The approaches of Inmon and Kimball are shown and the concept of dimensional modelling, especially the star schema, is presented by an example and enhanced by some exercises. Therefore, terms like "fact" and "dimension", but also "surrogate key" or "slow changing dimension" are introduced. The differences between a star schema and a normalized E/R model are illustrated.

---

Structured Query Language (Cont)

31 Março 2016, 14:00 • ANA MARIA MARQUES RIBEIRO DOS SANTOS LUCAS

Apresentação e Prática de SQL

---

O Modelo Relacional (Cont.)

17 Março 2016, 14:00 • ANA MARIA MARQUES RIBEIRO DOS SANTOS LUCAS

O Modelo Relacional

b) Maniplulação (Cont.)

c) Integridade A Linguagem SQL

---