Any necessary updates to the schedule will be documented here.
|
Wk |
Day |
Topics |
Assignments |
|---|---|---|---|
|
1 |
Jan 17 |
Course Introduction and Syllabus The Things You Can Do with Data. PowerPoint: |
|
|
1 |
Jan |
The Information Architecture of an Organization. PowerPoint: |
|
|
2 |
Jan 22 |
Understanding Database Schemas: Normalization, primary/foreign keys, joins PowerPoint: |
|
|
2 |
Jan 24 |
In-class exercise: |
|
|
2 |
Jan 26 |
In-class exercise: Creating a database schema |
|
|
3
|
Jan 29 |
Assignment 1: Assignment #1 – Database_Schemas_MWB.pdf PowerPoint: |
|
|
3
|
Jan. 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 |
|
|
3
|
Feb 2 |
CONTINUED – Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE |
Assignment 1 Due |
|
4 |
Feb 5 |
In-class exercise: Assignment 2: |
|
|
4
|
Feb 7 |
Getting data out of RDMS: Joining tables PowerPoint: |
|
|
4
|
Feb 9 |
CONTINUED Getting data out of RDMS: Joining tables Begin ICA #4 together in class |
|
|
5
|
Feb 12 |
Assignment 3: |
Assignment 2 Due (SQL Part 1) |
|
5 |
Feb 14 |
Review for Exam 1 |
|
|
5
|
Feb 16 |
Introduction to Python In-class exercise: A_Python_basics_Data_types.zip Getting familiar with Jupyter, Python Basic, Data types |
Assignment 3 Due |
|
6 |
Feb 19 |
Python Intro Continued |
|
|
6 |
Feb 21 |
Exam 1 |
|
|
6 |
Feb 23 |
Begin ICA #5 together in class |
|
|
7
|
Feb 26 |
Python Data Structures Assignment 4 – Assignment_4-Python_basics.zip In-class exercise:
|
|
|
7 |
Feb 28 |
Semi-structured data PowerPoint: |
|
|
7 |
Mar 1 |
Review of Exam 1 results |
|
|
8 |
Mar 4 |
SPRING BREAK – NO CLASS |
|
|
8 |
Mar 6 |
SPRING BREAK – NO CLASS |
|
|
8 |
Mar 8 |
SPRING BREAK – NO CLASS |
|
|
9
|
Mar 11 |
In-class exercise: Begin ICA 8 |
Assignment 4 Due 3/12 (Python Basics) |
|
9
|
Mar 13 |
Python and JSON In-class exercise: Working with JSON in Python
|
|
|
9
|
Mar 15 |
ICA 8 Continued Assignment 5: |
|
|
10
|
Mar 18 |
Python Pandas In-class exercise:
|
|
|
10
|
Mar 20 |
Python Pandas Continued |
Assignment 5 Due (Python and JSON) |
|
10 |
Mar 22 |
Wrap up Python Pandas |
|
|
11
|
Mar 25 |
Principles of Data Visualization PowerPoint: In class activity: ICA #10 – Data Visualization Principles.docx Assignment 6: |
|
|
11 |
Mar 27 |
ETL (Extract Transform Load) |
Assignment 6 Due (Pandas) |
|
11
|
Mar 29 |
Hypothesis Testing and Visualization in Python In-class exercise: |
|
|
12
|
April 1 |
Review for Exam 2 |
|
|
12 |
April 3 |
Exam 2 |
|
|
12 |
April 5 |
Introduction to Advanced Analytics PowerPoint: |
|
|
13
|
April 8 |
PowerPoint: Analysis Scenario 1: Predicting a future outcome based on a profile of past data (decision trees) |
|
|
13
|
April 10 |
In-class exercise: Decision trees in Python Assignment 7: PRO point assignment: |
|
|
13 |
April 12 |
Decision Trees continued… |
|
|
14 |
April 15 |
Analysis Scenario 2: Identifying similar customers (clustering and segmentation) PowerPoint: |
Assignment 7 Due (Decision Trees) |
|
14
|
April 17 |
In-class exercise: Clustering and Segmentation in Python ICA13.zip (clustering) Assignment 8 |
|
|
14
|
April 19 |
Analysis Scenario 3: What products are purchased together? (Association Rules) PowerPoint: |
|
|
15 |
April 22 |
Association Rules Continued In-class exercise: |
Assignment 8 Due (Clustering) |
|
15
|
April 24 |
In-class exercise: Assignment 9 |
|
|
15 |
April 26 |
Review for Exam 3 |
Assignment 9 Due (Association Rules) |
|
16 |
April 29 |
Exam 3 |
