| WEEK | DATES | TOPIC | MATERIALS | TASKS DUE |
|---|---|---|---|---|
| 1 | 8/22 |
Course Introduction and Syllabus |
PowerPoint: |
|
| 8/24 |
The Information Architecture of an Organization |
PowerPoint: |
||
| 8/26 |
Understanding Database Schemas: Normalization, primary/foreign keys, joins |
PowerPoint: |
|
|
| 2 | 8/29 | In-class activity 1: Creating database schema |
|
|
| 8/31 |
Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE Make sure you’ve reviewed the guide for setting up a connection in MySQL Workbench and reviewed the MySQL PowerPoint deck |
PowerPoint: |
||
| 9/2 |
Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE (continued) |
PowerPoint: |
||
| 3 |
9/5 |
Labor Day-No Classes Held | ||
|
9/7 |
Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE (continued) |
PowerPoint: |
|
|
| 9/9 | In-class activity 2: Pen and Paper exercise |
Assignment 1: Database schema (due Friday 9/9, 11:59 PM) |
||
| 4 | 9/12 |
Getting data out of RDMS: Joining tables |
PowerPoint: |
|
| 9/14 | In-class activity 3: Working with SQL, part 1 |
|
||
| 9/16 |
Getting data out of RDMS: Subselects |
PowerPoint: |
Assignment 2: SQL #1 (due Friday 9/16, 11:59 PM) |
|
| 5 | 9/19 |
In-class activity 4: Working with SQL, part 2 |
|
|
| 9/21 |
Semi-structured data |
PowerPoint: |
|
|
| 9/23 |
Semi-structured data |
PowerPoint: |
Assignment 3: SQL #2 (due Friday 9/23, 11:59 PM) |
|
| 6 | 9/26 |
Semi-structured data |
PowerPoint: |
|
| 9/28 | Review for Exam 1 |
PowerPoint: |
|
|
| 9/30 |
Exam 1 |
|
|
|
| 7 | 10/3 |
In-class activity 5: Working with semi-structured data |
|
|
| 10/5 |
Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP |
PowerPoint: – NoSQL 1 |
|
|
| 10/7 | In-class activity 6: Working with NoSQL, part 1 |
|
|
|
| 8 | 10/10 |
Getting data out of NoSQL: How to query nested document and array, JOIN |
PowerPoint: – NoSQL 2 |
|
| 10/12 |
In-class activity 7: Working with NoSQL, part 2 |
|
Assignment 4: NoSQL #1 (due Wednesday 10/12, 11:59 PM) |
|
| 10/14 | Wellness Day- No Classes Held | |||
| 9 | 10/17 | Reconciling Data: The extract, transform, load process (ETL) |
PowerPoint: – ETL |
|
| 10/19 |
Principles of Data Visualization |
PowerPoint: – Data Visualization |
|
|
| 10/21 |
In-class activity 8: Data Visualization |
|
Assignment 5: NoSQL #2 (due Friday 10/21, 11:59 PM) |
|
| 10 | 10/24 |
Introduction to Advanced Analytics and R |
PowerPoint: – Advanced Analytics – Introduction |
|
| 10/26 |
Review for Exam 2 |
|
|
|
| 10/28 | Exam 2 |
|
|
|
| 11 | 10/31 |
In-class activity 9: Getting familiar with Python and Jupyter Part 1 |
||
| 11/2 |
In-class activity 10: Getting familiar with Python and Jupyter Part 2 |
|||
| 11/4 |
Classification using Decision Trees |
PowerPoint: – Classification using Decision Trees |
Assignment 6: Introduction to working with Python (due Friday 11/4, 11:59 PM) |
|
| 12 | 11/7 | In-class activity 11: Decision trees in Python |
|
|
| 11/9 | Analysis Scenario: Identifying similar customers (clustering and segmentation) |
PowerPoint: – Clustering and Segmentation |
|
|
| 11/11 | In-class activity 12: Clustering and Segmentation in Python |
|
Assignment 7: Decision Trees (due Friday 11/11, 11:59 PM) |
|
| 13 | 11/14 |
Analysis Scenario: What products are purchased together? (Association Rules) |
PowerPoint: – Association Rule Mining |
|
| 11/16 |
Analysis Scenario: What products are purchased together? (Association Rules) |
PowerPoint: – Association Rule Mining |
|
|
| 11/18 | In-class activity 13: Computing Confidence, Support, and Lift |
|
Assignment 8: Clustering (due Friday 11/18, 11:59 PM) |
|
| 14 | 11/21 |
Fall Break & Thanksgiving Holiday – No Classes Held
|
||
| 11/23 | ||||
| 11/25 | ||||
| 15 |
11/28 |
In-class activity 14: Association Rule Mining in Python |
|
Assignment 9: Association Rules (due Monday 11/28, 11:59 PM) |
|
11/30 |
Review for Exam 3 |
|
||
| 12/2 | TBD |
|
|
|
| 16 |
12/5 |
Exam 3 |
|
|