WEEK | DATES | TOPIC | TASKS DUE | MATERIALS |
---|---|---|---|---|
1 | 8/26 |
– Course Introduction and Syllabus
|
||
8/28 |
– The Information Architecture of an Organization – Understanding Database Schemas: Normalization, primary/foreign keys, joins |
|||
8/30 | – Understanding Database Schemas: Normalization, primary/foreign keys, joins | |||
2 | 9/02 |
Labor Day – No Class |
||
9/04 | In-class exercise #01: Creating database schema | |||
9/06 | Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE | |||
3 | 9/9 |
Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE
|
Assignment 1: Database schema |
|
9/11 |
In-class exercise #02: Pen and Paper exercise
|
|
||
9/13 |
Getting data out of RDMS: Joining tables In-class exercise #03: Working with SQL, part 1 |
|||
4 | 9/16 |
In-class exercise #03: Working with SQL, part 1
|
|
|
9/18 |
In-class exercise #03: Working with SQL, part 1 In-class exercise #04: Working with SQL, part 2 |
Assignment 2: SQL #1 |
|
|
9/20 | In-class exercise #04: Working with SQL, part 2 | |||
5 | 9/23 | Review for Exam 1 |
Assignment 3: SQL #2 |
|
9/25 | Review for Exam 1 |
|
||
9/27 | Exam 1 | |||
6 | 09/30 |
Introduction to Python In-class exercise #05: Getting familiar with Jupyter, Python Basic, Data types |
|
|
10/02 |
Python Data Structures In-class exercise #06: Python Lists and Dictionaries |
|||
10/04 |
Python Data Structures In-class exercise #06: Python Lists and Dictionaries |
|
||
7 | 10/07 |
Semi-structured data In-class exercise #07: Working with semi-structured data |
Assignment 4: Python Basics |
|
10/09 |
Python and JSON In-class exercise #08: Working with JSON in Python |
|
|
|
10/11 |
Python and JSON In-class exercise #08: Working with JSON in Python |
|
|
|
8 | 10/14 |
Python Pandas In-class exercise #09: Working with Python Pandas |
Assignment 5: Python and JSON |
|
10/16 |
In-class exercise #10: More practice with Pandas |
|
|
|
10/18 |
Reconciling Data: The extract, transform, load process (ETL) |
|
||
9 | 10/21 |
Principles of Data Visualization In-class exercise #11: Data Visualization |
Assignment 6: Pandas |
|
10/23 |
Hypothesis Testing In-class exercise #12: Hypothesis Testing and Visualization in Python |
|
|
|
10/25 |
Hypothesis Testing In-class exercise #12: Hypothesis Testing and Visualization in Python |
|
|
|
10 | 10/28 | Review for Exam 2 | ||
10/30 | Review for Exam 2 | |||
11/01 | Exam 2 | |||
11 | 11/04 |
Introduction to Advanced Analytics and Python |
||
11/06 |
Classification using Decision Trees |
|||
11/08 | In-class exercise #13: Decision Trees in Python |
|
||
12 | 11/11 | Analysis Scenario: Identifying similar customers (clustering and segmentation) |
Assignment 7: Decision Trees |
|
11/13 | In-class exercise #14: Clustering and Segmentation in Python |
|
||
11/15 | In-class exercise #14: Clustering and Segmentation in Python |
|
||
13 | 11/18 |
Analysis Scenario: What products are purchased together? (Association Rules) |
Assignment 8: Clustering |
|
11/20 |
In-class exercise #15: Computing Confidence, Support, and Lift |
|
||
11/22 | In-class exercise #16: Computing Confidence, Support, and Lift |
|
|
|
14 | 11/25 |
Thanksgiving holiday – no class |
||
11/27 | Thanksgiving holiday – no class | |||
11/29 | Thanksgiving holiday – no class | |||
15 | 12/02 | Review for Exam 3 |
Assignment 9: Association Rules |
|
12/04 | Review for Exam 3 |
|
||
12/06 | Final Exam |
PRO points project (optional): Due on 12/06
|