| 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
|
||