Schedule

1

1/16

MLK DAY – No class

1

1/18

Course Intro

PowerPoint:

01 Things You Can Do With Data.pptx

1

1/20

The Information Architecture of an Organization

PowerPoint:

02 Information Architecture of an Organization.pptx

2

1/23

Understanding Database Schemas: Normalization, primary/foreign keys, joins

PowerPoint:

03 Relational Data Modeling.pptx

2

1/25

In-class activity 1: Creating database schema

Resources:

ICA_1_Database_Schema_MWB.docx

2

1/27

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: 

04 SQL Out 1- Basic.pptx

Assignment 1:

Assignment #1 – Database Schemas_MWB.docx

(due Monday 2/6, 11:59 PM)

3

1/30

Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE

PowerPoint: SQL Slide deck (Basic)

3

2/1

Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE

PowerPoint: SQL Slide deck (Basic)

3

2/3

In-class activity 2: Pen and Paper exercise

4

2/6

Getting data out of RDMS: Joining tables

PowerPoint: 
05 SQL Out 2 – Advanced.pptx

Assignment 1 is due by the end of the day

4

2/8

In-class activity 3: Working with SQL, part 1

4

2/10

Getting data out of RDMS: Subselects

PowerPoint: SQL Slide deck (Basic)

Assignment:
Assignment #2 – SQL Part 1.docx

5

2/13

Getting data out of RDMS: Subselects (Continued)

PowerPoint: 
05 SQL Out 2 – Advanced.pptx

5

2/15

In-class activity 4: Working with SQL, part 2

5

2/17

Review of ICA #4

Assignment:

Assignment #3 – SQL – Advanced.docx

Assignment #3 – SQL Advanced_Answer sheet.docx

6

2/20

Semi-structured data

PowerPoint: 

06 Semi-Structured Data.pptx

6

2/22

In-class activity 5: Working with semi-structured data

6

2/24

Review for Exam 1

7

2/27

Exam 1

7

3/1

Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP

PowerPoint: 

07 NoSQL 1 – Out- Basic.pptx

7

3/3

TBD

8

3/6

NO CLASS – Spring Break

8

3/8

NO CLASS – Spring Break

8

3/10

NO CLASS – Spring Break

9

3/13

Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP

PowerPoint: (same as before break!)

07 NoSQL 1 – Out- Basic.pptx

9

3/15

In-class activity 6: Working with NoSQL, part 1

9

3/17

Exam 1 review and start Assignment 4 

Assignment 4

Assignment #4 – NoSQL Basic.docx

10

3/20

Getting data out of NoSQL: How to query nested document and array, JOIN

PowerPoint:

08 NoSQL 2 Out-Advanced.pptx

10

3/22

In-class activity 7: Working with NoSQL, part 2

ICA #7 – NoSQL Part 2.docx

10

3/24

Reconciling Data: The extract, transform, load process (ETL)

PowerPoint:
09 ETL.pptx

Assignment 5

Assignment #5 – NoSQL Part 2.docx

11

3/27

Principles of Data Visualization

PowerPoint:

10 Data Visualization.pptx

11

3/29

In-class activity 8: Getting familiar with Python and Jupyter Part 1

For ICA #8:

ICA08.zip

11

3/31

In-class activity 9: Data Visualization

For ICA #9:

ICA #9 – Data Visualization Principles.docx

ICA #9 – Food-Emporium_Dashboard.xlsx

12

4/3

Review for Exam 2

Exam 2 Study Guide.pdf Exam 2 Study Guide

PowerPoint:

Review for Exam 2.pptx

12

4/5

Exam 2

12

4/7

In-class activity 10: Getting familiar with Python and Jupyter Part 2

Resource file for ICA 10

ICA10.zip

13

4/10

Classification using Decision Trees

PowerPoint: 

12 Decision Trees.pptx

13

4/12

In-class activity 11: Decision trees in Python

ICA resources: ICA11.zip

Assignment 6 resources: assignment6.zip

Assignment #6 – Decision Tree – Corrected Q8.docx

13

4/14

ICA 11 (again!)

14

4/17

Review

Assignment 6: Decision Trees (due Tuesday 4/18, 11:59 PM)

14

4/19

Analysis Scenario: Identifying similar customers (clustering and segmentation)

PowerPoint: 

13 Clustering.pptx

14

4/21

In-class activity 12: Clustering and Segmentation in Python

Resource:

ICA#12.zip

Assignment:

assignment7.zip

15

4/24

Analysis Scenario: What products are purchased together? (Association Rules)

PowerPoint: 

14 Association Rule Mining.pptx

Assignment 7: Clustering (due Tuesday 4/25, 11:59 PM)

15

4/26

In-class activity 13: Association Rule Mining in Python

In Class Activity:

ICA13.zip

Assignment:

assignment8.zip

15

4/28

In-class activity 14: Computing Confidence, Support, and Lift

In Class Activity:

ICA #14 – Computing Confidence, Support, and Lift

16

5/1

Review for Exam 3

Exam 3 Study Guide 2023.docx

PowerPoint:

Review for Exam 3.pptx

Assignment 8: Association Rules (due Monday 5/1, 11:59 PM)