In Class Assignments

ER Modeling In Class Problems and Solutions

In-Class #2 – ER Modeling

In-Class #2 – ER Modeling [KEY]

In Class #3 – Creating Schemas

In Class #3 – Creating Schemas [KEY]

MySQL in Class Problems and Solutions

In Class #4 – Pen and Paper Query Exercise

In Class #4 – Pen and Paper Query Exercise [KEY]

In-Class  #5 – SQL Out

In-Class Exercise #5 – SQL Out – Solution

In-Class  #6 – SQL In

In-Class Exercise #6 – SQL In [Key]

Data Visualization

In-Class Exercise #7 – Data Visualization

Food Emporium Excel Workbook for #7

Dimensional Modeling

In Class Exercise #8a – Dimensional Modeling

In Class Exercise #8a KEY – Dimensional Modeling

Extract, Transform and Load

In-Class Exercise #6 –  Excel

In-Class Exercise #6 – Instructions

SAS Enterprise Miner

Descriptive Statistics Review

Creating SAS OnDemand Account

In-Class Exercise – Getting Familiar with SAS-v2

In-Class Exercise #8 – Decision Trees_v2

In-Class Exercise #9 – Clustering_v2

In-Class Exercise #10 – Association Rules_v3

Reading EM Output In Class

10 – Reading Decision Tree Output [KEY]

10 – Reading Decision Tree Output

12 – Reading Clustering Output

12 – Reading Clustering Output [KEY]

14 – Reading Association Mining Output

14 – Reading Association Mining Output [KEY]