Instructor: Jing Gong

Schedule and Syllabus

Updated: November 16, 2015

Here is the updated syllabus (as of 11/3): MIS2502 Syllabus [Gong] – Fall 2015 v1103

Syllabus and schedule are subject to change.

Day Topics Course Materials Assignments

Week 1

Aug 24 Course Introduction and Syllabus

The Things You Can Do with Data

PowerPoint: The Things You Can Do With Data
Aug 26 The Information Architecture of an Organization PowerPoint: Information Architecture
Aug 28 Data Modeling

Gathering requirements
Introducing The Entity-Relationship Diagram

PowerPoint: Relational Data Modeling

Week 2

Aug 31 In-class exercise: Identifying entities
Sep 2 More on ERDs:
Relationships, cardinality
PowerPoint: Relational Data Modeling
Sep 4 In-class exercise: Creating an entity relationship diagram

(Last day to add or drop a full-term course)

Week 3

Sep 7 Labor Day – No Class
Sep 9 From ERDs to Schemas: Normalization, primary/foreign keys, joins
PowerPoint: Relational Data Modeling
Sep 11 In-class exercise: Converting ERDs to schemas

Week 4

Sep 14 Getting data out of the database: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE

Make sure you’ve reviewed the guide for setting up a connection in MySQL Workbench and reviewed the MySQL PowerPoint deck.

PowerPoint: SQL 1 Assignment 1 Due: ER Modeling
Sep 16 In-class exercise: Pen-and-paper SQL exercise
Sep 18 Getting data out of the database: Joining tables, SQL subselects, LIMIT PowerPoint: SQL 1

Week 5

Sep 21 In-class exercise: Working with SQL, part 1
Sep 23 Creating and updating the database: SQL CREATE, DROP, and ALTER;  SQL INSERT, UPDATE, and DELETE PowerPoint: SQL 2
Sep 25 Papal Visit – No Class

Week 6

Sep 28 In-class exercise: Working with SQL, part 2
Sep 30 Principles of Data Visualization
PowerPoint: Data Visualization Assignment 2 Due: SQL #1
Oct 2 Review for Exam 1
 

Week 7

Oct 5 In-class exercise: Data Visualization (We will not meet in class. Video recorded)
Oct 7 Exam 1 Assignment 3 Due: SQL #2
Oct 9 Principles of Data Visualization PowerPoint: Data Visualization

Week 8

Oct 12 Getting data into the analytical database: The Extract, Transform, Load process PowerPoint: ETL
Oct 14 Turning transaction data into analytical data: Overview of the Dimensional Model PowerPoint: Dimensional Data Modeling
Oct 16 The structure of the Dimensional Model: The Star Schema PowerPoint: Dimensional Data Modeling

Week 9

Oct 19 Working with Dimensional Data:
Pivot Tables in Excel                                         In-class exercise: Pivot Tables in Excel(Oct. 20 is the Last day to withdraw from a full-term course)
Assignment 4 Due: ETL in Excel
Oct 21 Introduction to Advanced Analytics and R PowerPoint: Advanced Analytics – Introduction
Oct 23 In-class exercise: Descriptive Statistics Review

Week 10

Oct 26 In-class exercise: Getting familiar with R and RStudio Assignment 5 Due: Pivot Tables in Excel
Oct 28 Review for Exam 2 Assignment 6 (Group Project) Due: Data Visualization
Oct 30 Exam 2

Week 11

Nov 2 In-class exercise: Getting familiar with R and RStudio (continued)
Nov 4 Analysis Scenario: Determining customer behavior based on a profile (decision trees) PowerPoint: Classification using Decision Trees  
Nov 6 In-class exercise: Interpreting Decision Tree Output

 In-class exercise: Decision trees in R

 

Week 12

Nov 9 In-class exercise: Decision trees in R PowerPoint: Clustering and Segmentation Assignment 7 Due: Analytics #1 – Introduction to working with R
Nov 11 Analysis Scenario: Identifying similar customers (clustering and segmentation)
Nov 13 In-class exercise: Clustering and Segmentation in R

Week 13

Nov 16 In-class exercise: Clustering and Segmentation in R (Continued)
Analysis Scenario: What products are purchased together? (Association Rules)
PowerPoint: Association Rule Mining
Nov 18 Analysis Scenario: What products are purchased together? (Association Rules) (Continued)

In-class exercise: Computing Confidence, Support, and Lift

 PowerPoint: Association Rule Mining Assignment 8 Due: Analytics #2 – Decision Trees in R
Nov 20 In-class exercise: Association Rule Mining in R

Week 14

Nov 23, 25, 27 Fall Break &Thanksgiving Recess – No Class

Week 15

Nov 30 In-class exercise: Association Rule Mining in R (Continued) Assignment 9 Due: Analytics #3 – Clustering in R
Dec 2 Advanced Analytics: Wrap up
Dec 4 Review for Final Exam

Week 16

Dec 8 Assignment 10 Due: Analytics #4 – Association Rules in R

Final Exam

Wednesday, Dec 16 from 1:00 to 3:00 pm