ISQS 3358 Lecture Notes

 

Instructor: Zhangxi Lin

 

-----------------------------------------------------------------------------------

Home | Schedule | Your records | Group Sign up | Group List | Projects | Notes

-----------------------------------------------------------------------------------

 

4/30/2007, Monday

 

Agenda:

 

1)      Project 5 Q/A

2)      SAS EG Review

a.      SAS file import

b.      SAS EG query

c.      SAS EG reporting

d.      SAS EG analytic tasks

3)      SAS EM review

a.      SAS EM – decision tree

b.      SAS EM – association analysis

c.      SAS EM – clustering

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

4/27/2007, Friday

 

Agenda:

 

1)      IT project management review

2)      BI program and project management

3)      Review of SAS EG

4)      Lab assignment 10

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

4/25/2007, Wednesday

 

Agenda:

 

1)      Quiz 5 review

2)      Consumer profiling

3)      Project 5 Q/A

4)      Lab assignment 9

 

BI skill: Consumer profiling by clustering

 

Datasets: PROFILE, BANNERAD, eBay trader online reputation scores

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

4/23/2007, Monday

 

Agenda:

 

1)      Quiz 5 (Chapter 8, 12, Association analysis)

2)      Online marketing intelligence

 

BI Skills: Consumer Profiling

Dataset: RLINKS, COMMREX web log

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

4/20/2007, Friday

 

Agenda:

  1. Forecasting
  2. Quality control
  3. SAS Enterprise Guide Regression
  4. Project 4 due
  5. Project 5 instructions (Due May 2)

 

BI Skills: SAS EG Regression

Datasets: SAS analytics exercise downloads (quality control, regression, ANOVA)

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

4/18/2007, Wednesday

 

Agenda:

1.      Quiz 4 review

2.      Probability and statistics review

3.      Association Analysis review

4.      MS Excel Solver

5.      Lab assignment 6: Applying Excel Solver

6.      Chapter 8 – Data Profiling

 

BI Skills: MS Excel Solver

Datasets: TBD

 

Recommended readings:

1)      A tutorial to probability and statistics http://www.cs.utah.edu/classes/cs7966-whitaker/prob-tut.pdf

2)      Conditional probability http://people.hofstra.edu/faculty/Stefan_Waner/RealWorld/tutorialsf3/unit6_5.html

3)      Probability tutorial using dice http://staff.washington.edu/billmcn/math/two_dice.pdf

4)      A quiz http://dialogues.h1088483.serverkompetenz.net/Sevilla/quiz/quiz.php

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

4/16/2007, Monday

 

Agenda:

1.      Quiz 4 (Chapter 7, 15, clustering)

2.      Association Analysis

3.      Q/A for Project 4

 

BI Skills: SAS Enterprise Miner Association Analysis

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

4/13/2007, Friday

 

Lecture outline:

1.      Introduction to Clustering

2.      SAS Enterprise Miner 4.3 – Clustering

3.      Project 3 due

4.      Project 4 Instructions

 

Reference: http://zlin.ba.ttu.edu/6347/Clustering.xls

BI Skills: SAS EM Clustering

Datasets: s3358, s6347

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

4/11/2007, Wednesday

 

Lecture outline:

7.      Quiz 3 review

8.      SAS Enterprise Miner 4.3 – Survey data analysis, German Bank Credit Benchmark

9.      Lab assignment 5: Classification

10.  Chapter 15 – Using External Data

11.  Q/A for Project 3

 

BI Skills: SAS EM Classification

Datasets: s3358, s6347, German Bank Credit Benchmark

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

4/6/2007, Friday

 

Lecture outline:

1.      Quiz 3

2.      SAS Enterprise Miner 4.3 – Survey data analysis

3.      Lab assignment 4: EG Chapter 5, decision tree

4.      Chapter 7 – Business Rules

 

BI Skills: Tabular summer report, SAS EM decision tree

Datasets: s3358, German Bank Credit Benchmark

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

4/4/2007, Wednesday

 

Lecture outline:

1)      Project 2 demonstration

2)      SAS Enterprise Miner 4.3 – Survey data analysis

 

BI Skills: Tabular summer report, SAS EM decision tree

Datasets: s3358

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

4/2/2007, Monday

 

Lecture outline:

1.      Introduction to data mining

2.      SAS Enterprise Miner 4.3

3.      Lab assignment 4: decision tree and decision rules

4.      Chapter 14 – Knowledge discovery and data mining

 

BI Skills: Decision model performance analysis

Datasets: Credit Promotion

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

3/30/2007, Friday

 

Lecture outline:

1)      Quiz 2

2)      EG Chapter 6

3)      Lab assignment 3

4)      Chapter 10 – Information integration

 

Datasets: Profit, Orders

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

3/28/2007, Wednesday

 

Lecture outline:

  1. EG Chapter 6
  2. Project 1 data quality and data preprocessing
  3. Project 2 dataset

 

Datasets: Cotton/cottonseed data

 

Notes: Project 2 due on 4/2

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

3/26/2007, Monday

 

Lecture outline:

1)      EG Chapter 4 (joining table), 5.1

2)      Lab assignment 2

3)      Project 2 introduction

 

Datasets: March_shipping

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

3/23/2007, Friday

 

Lecture outline:

1)      EG Chapter 4

2)      Lab assignment 1

3)      Chapter 5 overview

 

BI Skills: Using variable parameter

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

3/21/2007, Wednesday

 

Lecture outline:

1)      Quiz 1

2)      EG Chapter 3

3)      Guided exercise

 

BI Skills: Create a two-way frequency report

 

Datasets: Customers$ in Afs_customers.xls, Afs_oders.txt

 

Notes: Project 1 due is postponed to 3/26

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

3/19/2007, Monday

 

Lecture outline:

  1. Review
  2. Video show
  3. Case (continued): IMW’s online real estate property information service
  4. Guided exercise
    1. Data preparation – IWM user log file
    2. Data import
    3. Descriptive analysis
  1. EG Exercise (IMW user log file)
  2. Open-book self-test exercise – 20 minutes

 

BI Skills: Create a one-way frequency report

 

Datasets: IMW user log

 

---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ---- + ----

 

3/9/2007, Friday

 

Lecture outline:

  1. Review discussion: database and data warehousing – 20 min
  2. Case: IMW’s online real estate property information service – 10 min
  3. Demonstrations – 30 min
    1. Data preparation – IWM data
    2. Data import
    3. Descriptive analysis
  4. Concluding discussion – 20 minutes

 

BI skills by the date:

1.      Raw data conversion

2.      Import datasets in other formats

3.      Create listing a report

4.      SAS EG Chapter 2 Exercise