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