| WEEK | DATES | TOPIC | TASKS DUE | MATERIALS |
|---|---|---|---|---|
| 1 | 1/17 |
– Course Introduction and Syllabus |
||
| 1/19 |
Understanding Database Schemas: Normalization, primary/foreign keys, joins |
|
||
| 2 | 1/24 | In-class exercise #01: Creating database schema | ||
| 1/26 |
Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE |
|
||
| 3 |
1/31 |
In-class exercise #02: Pen and Paper exercise |
Assignment 1: Database schema |
|
| 2/2 |
Getting data out of RDMS: Joining tables |
|
||
| 4 | 2/7 |
In-class exercise #03: Working with SQL, part 1 |
Assignment 2: SQL #1 |
|
| 2/9 |
Getting data out of RDMS: Subselects In-class exercise #04: Working with SQL, part 2 |
|
||
| 5 | 2/14 |
In-class exercise #04: Working with SQL, part 2 |
|
|
| 2/16 |
Review for Exam 1 |
|
||
| 6 | 2/21 | Exam 1 |
Assignment 3: SQL #2 |
|
| 2/23 |
Semi-structured data In-class exercise #05: Working with semi-structured data |
|
||
| 7 | 2/28 |
Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP |
||
| 3/2 | In-class exercise #06: Working with NoSQL, part 1 |
|
||
| 8 | 3/7 and 3/9 | Spring Break |
|
|
| 9 | 3/14 |
In-class exercise #06: Working with NoSQL, part 1 |
|
|
| 3/16 |
Getting data out of NoSQL: How to query nested document and array, JOIN In-class exercise #07: Working with NoSQL, part 2 |
|
||
| 10 | 3/21 |
Reconciling Data: The extract, transform, load process (ETL) |
Assignment 4: NoSQL #1 |
|
| 3/23 |
Principles of Data Visualization In-class exercise #8: Data Visualization |
|
|
|
| 11 | 3/28 |
Review for Exam 2 |
Assignment 5: NoSQL #2 |
|
| 3/30 | Exam 2 |
|
||
| 12 | 4/4 |
Introduction to Advanced Analytics and Python In-class exercise #9: Getting familiar with Python and Jupyter Part 1 |
||
| 4/6 | In-class exercise #10: Getting familiar with Python and Jupyter Part 2 |
|
|
|
| 13 | 4/11 |
Classification using Decision Trees |
|
|
| 4/13 |
In-class exercise #11: Decision trees in Python |
|
|
|
| 14 | 4/18 |
Analysis Scenario: Identifying similar customers (clustering and segmentation) |
|
|
| 4/20 |
In-class exercise #12: Clustering and Segmentation in Python |
Assignment 6 Due: Decision Trees |
|
|
| 15 |
4/25 |
Analysis Scenario: What products are purchased together? (Association Rules) In-class exercise #13: Computing Confidence, Support, and Lift |
Assignment 7 Due: Clustering |
|
|
4/27 |
Review for Exam 3 |
PRO points project (optional): Due on 4/30
|
||
|
5/3, 4pm-5pm |
Final Exam Q&A session (optional) |
|||
|
5/9, 10:30am-12:30pm |
Exam 3 |