WEEK | DATES | TOPIC | MATERIALS | TASKS DUE |
---|---|---|---|---|
1 | 1/17 |
Course Introduction and Syllabus The Information Architecture of an Organization |
PowerPoint: |
|
1/19 |
Understanding Database Schemas: Normalization, primary/foreign keys, joins |
PowerPoint: |
|
|
2 | 1/24 | In-class activity 1: Creating database schema |
Assignment 1: Database schema (due Friday 1/27, 11:59 PM) |
|
1/26 |
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: |
|
|
3 |
1/31 |
Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE (continued) |
PowerPoint: |
|
2/2 | In-class activity 2: Pen and Paper exercise |
|
||
4 | 2/7 |
Getting data out of RDMS: Joining tables
|
PowerPoint:
|
Assignment 2: SQL #1 (due Friday 2/10, 11:59 PM) |
2/9 |
In-class activity 3: Working with SQL, part 1 |
|
||
5 | 2/14 |
Getting data out of RDMS: Subselects |
PowerPoint: |
Assignment 3: SQL #2 (due Friday 2/17, 11:59 PM) |
2/16 |
In-class activity 4: Working with SQL, part 2 |
|
||
6 | 2/21 | Review for Exam 1 |
PowerPoint: |
|
2/23 |
Exam 1 |
|
|
|
7 | 2/28 |
Semi-structured data In-class activity 5: Working with semi-structured data |
PowerPoint: |
|
3/2 |
Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP |
PowerPoint: |
|
|
8 | 3/7 |
Spring Break – No Classes Held
|
||
3/9 | ||||
9 | 3/14 |
In-class activity 6: Working with NoSQL, part 1 |
Assignment 4: NoSQL #1 (due Friday 3/17, 11:59 PM) |
|
3/16 |
Getting data out of NoSQL: How to query nested document and array, JOIN |
PowerPoint: |
|
|
10 | 3/21 | In-class activity 7: Working with NoSQL, part 2 |
Assignment 5: NoSQL #2 (due Friday 3/24, 11:59 PM) |
|
3/23 |
Reconciling Data: The extract, transform, load process (ETL) Principles of Data Visualization In-class activity 8: Data Visualization |
PowerPoint:
|
|
|
11 | 3/28 |
Review for Exam 2 |
PowerPoint: |
|
3/30 | Exam 2 |
|
|
|
12 | 4/4 |
Introduction to Advanced Analytics and R |
PowerPoint: |
|
4/6 |
In-class activity 9: Getting familiar with Python and Jupyter |
(The files are available on Canvas) |
||
13 | 4/11 |
Classification using Decision Trees |
PowerPoint: |
|
4/13 |
In-class activity 10: Decision trees in Python |
|
Assignment 6: Decision Trees (due Monday 4/17, 11:59 PM) |
|
14 | 4/18 |
Analysis Scenario: Identifying similar customers (clustering and segmentation) In-class activity 11: Clustering and Segmentation in Python |
PowerPoint: (The files for ICA 11 are available on Canvas) |
Assignment 7: Clustering (due Friday 4/21, 11:59 PM)
|
4/20 |
Association Rule Mining In-class activity 11: Clustering and Segmentation in Python (continued) |
PowerPoint: |
|
|
15 |
4/25 |
Review for Exam 3 |
PowerPoint: |
|
4/27 |
Exam 3 |
|
|