Exercício 1

CUBO

Exercício 1

CUBO

Exercício 2

DW, Star Schema, Snowflake schema

Exercício 3

Defining Calculations, Normalization, PCA

Exercício 4

ETL,   Apriori fp-growth

Exercício 5

clustering, k-Means, EM Clustering

Exercício 6

Apriori, kNN, Sequence-Clustering, Belief Networks

Exercício 7

Naibe Bayes, Decision Trees

Exercício 8

Gradient descent, Backpropagation

Epoca Especial

Epoca Especial solution and grades

Finale Grades

Finale Grades

Exame2 solution and grades

Exame2 solution and grades

Exame1 solution and grades

See Secção Material Adicional. SAD exame review 29/6/2014 11-12h room 2 N7.1

Overview

Overview information about SQL Server, login information, practical lectures, links

SQL installation

Installation of SQL Server 2008, related to SQL 2012.

You do not need to install it on your computers, since SQL SErver is installed in lab.

Lesson_3

Analysis Services Lesson 3 finished. To deploy in Lab 0.21 use the required parameters as specified in the OverviewSAD document

Lesson 5

Lesson 5, needed for Home Wok 3.

ETL

ETL examples