Schedule
|
Day |
Topics |
Course Materials |
Assignments |
|
Week 1 |
|||
Jan 22 |
Course Introduction and Syllabus The Things You Can Do with Data. The Information Architecture of an Organization. |
PowerPoint: The Things You Can Do With Data PowerPoint: Information Architecture |
|
|
|
Data Modeling Gathering requirements
In-class exercise: What is an entity? |
PowerPoint: Relational Data Modeling |
|
|
Week 2 |
|||
Jan 29 |
More on ERDs: In-class exercise: Converting ERDs to schemas |
PowerPoint: Relational Data Modeling |
|
|
|
In-class exercise: Creating an Entity Relationship Diagram |
PowerPoint: Relational Data Modeling |
|
|
Week 3 |
|||
Feb 3 |
Drop Deadline |
|
|
Feb 5 |
Getting data out of the database: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE
Make sure you’ve done the MySQL tutorial and reviewed the MySQL PowerPoint deck. In-class exercise: Pen-and-paper SQL exercise |
PowerPoint: SQL 1 |
|
|
|
Getting data out of the database: Joining tables, SQL subselects, LIMIT |
|
Assignment 1 Due: ER Modeling |
|
Week 4 |
|||
Feb 12 |
In-class exercise: Working with SQL, part 1 |
|
|
|
|
Creating and updating the database SQL CREATE, DROP, and ALTER SQL INSERT, UPDATE, and DELETE |
PowerPoint: SQL 2 |
|
Week 5
Feb 19
In-class exercise: Working with SQL, part 2
Assignment 2 Due: SQL #1
Review for Exam 1
Week 6
Feb 26
Exam 1
Principles of Data Visualization
PowerPoint: Data Visualization
Week 7
Mar 5
SPRING BREAK
Week 8
Mar 12
In-class exercise: Data Visualization
Assignment 3 Due: SQL #2
Turning transaction data into analytical data: Overview of the Dimensional Model
The structure of the Dimensional Model: The Star Schema
PowerPoint: Dimensional Data Modeling
Week 9
Mar 19
Working with Dimensional Data:
Pivot Tables in Excel
In-class exercise: Pivot Tables in Excel
Getting data into the warehouse and cube:
The Extract, Transform, Load process
Data quality: Best practices, data cleansing, and integration
PowerPoint: ETL
Week 10
Mar 25
Withdraw Deadline
Mar 26
In-class exercise: ETL
Assignment 4 Due: Pivot Tables in Excel
Introduction to Advanced Analytics and SAS Enterprise Miner
In-class exercise: Descriptive Statistics Review
PowerPoint: Advanced Analytics – Introduction
Week 11
Apr 2
In-class exercise: Introduction to SAS Enterprise Miner/Preparing Data for Analysis
Assignment 5 Due: Data Visualization
Review for Exam 2
|
Week 12 |
|||
Apr 9 |
Exam 2 |
|
|
|
|
Analysis Scenario: Determining customer behavior based on a profile (decision trees)
In-class exercise: Interpreting Decision Tree Output |
PowerPoint: Classification using Decision Trees |
|
Week 13
Apr 16
In Class: Decision Trees , Association Rules
Homework: Decision Trees due April 19th
Week 14
Apr 23
In Class: Clustering
Homework: Association Rule Mining Due
Week 15
Apr 30
In Class: Clustering, Exam Review
Homework: Clustering Due