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