WEEK | DATES | TOPIC | TASKS DUE | MATERIALS |
---|---|---|---|---|
1 | 1/16 | – 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/23 | In-class exercise #01: Creating database schema |
|
|
Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE | ||||
3 | 1/30 |
In-class exercise #02: Pen and Paper exercise |
Assignment 1: Database schema |
|
Getting data out of RDMS: Joining tables | ||||
4 | 2/6 | In-class exercise #03: Working with SQL, part 1 |
Assignment 2: SQL #1 |
|
In-class exercise #04: Working with SQL, part 2 | ||||
5 | 2/13 | 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/20 |
Exam 1 |
|
|
Python Data Structures In-class exercise #06: Python Lists and Dictionaries |
||||
7 | 2/27 |
Semi-structured data In-class exercise #07: Working with semi-structured data |
Assignment 4: Python Basics |
|
Python and JSON In-class exercise #08: Working with JSON in Python |
||||
SPRING BREAK | 3/3-3/7 |
|
||
9 | 3/13 |
Python Pandas In-class exercise #09: Working with Python Pandas |
Assignment 5: Python and JSON |
|
Reconciling Data: The extract, transform, load process (ETL) In-class exercise #10: More practice with Pandas |
|
|||
10 | 3/20 |
Principles of Data Visualization In-class exercise #11: Data Visualization |
Assignment 6: Pandas |
|
Hypothesis Testing In-class exercise #12: Hypothesis Testing and Visualization in Python |
|
|||
11 | 3/27 | Review for Exam 2 |
|
|
Exam 2 |
|
|||
12 | 4/3 |
Introduction to Advanced Analytics and Python Classification using Decision Trees |
|
|
In-class exercise #13: Decision Trees in Python |
|
|||
13 | 4/10 | Analysis Scenario: Identifying similar customers (clustering and segmentation) |
Assignment 7: Decision Trees |
|
In-class exercise #14: Clustering and Segmentation in Python |
|
|||
14 | 4/17 |
Analysis Scenario: What products are purchased together? (Association Rules) In-class exercise #15: Computing Confidence, Support, and Lift |
Assignment 8: Clustering |
|
In-class exercise #16: Computing Confidence, Support, and Lift |
|
|||
15 | 4/24 | Review for Exam 3 |
Assignment 9: Association Rules |
|
16 | Final Exam |
PRO points project (optional): Due on 12/08
|
|