Schedule

1/14

Course Introduction and Syllabus

The Things You Can Do with Data.

The Information Architecture of an Organization

PowerPoint: Course Introduction

The Things You Can Do with Data

Information Architecture

1/16

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

PowerPoint: Relational Data Modeling

1/21

In-class exercise: Creating database schema in MySQL Workbench

1/23

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

PowerPoint: SQL 1

1/28

In-class exercise: Pen and Paper exercise

Assignment 1 Due: Database schema

1/30

In-class exercise: Working with SQL, part 1

2/4

Getting data out of RDMS: Joining tables

In-class exercise: Working with SQL, part 2

PowerPoint: SQL 2

Assignment 2 Due: SQL #1

2/6

In-class exercise: Working with SQL, part 2

2/11

Review for Exam 1

Assignment 3 Due: SQL #2

2/13

Exam 1

2/18

Semi-structured data

In-class exercise: Working with semi-structured data

PowerPoint: Semi-structured data & NoSQL

2/20

Introduction to Python

In-class exercise: Getting familiar with Jupyter, Python Basic, Data types

2/25

Python Data Structures

In-class exercise: Python Lists and Dictionaries

2/27

Python and JSON

In-class exercise: Working with JSON in Python

Assignment 4 Due: Python Basics

3/3-7

Spring Break – No class

3/11

In-class exercise: Working with JSON in Python (continued)

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

PowerPoint: ETL

3/13

Python Pandas

In-class exercise: Working with Python Pandas

Assignment 5 Due:  Python and JSON

3/18

Hypothesis Testing

Principles of Data Visualization

In-class exercise: Data Visualization

PowerPoint: Hypothesis Testing
Data Visualization

3/20

Review for Exam 2 

Assignment 6 Due: Pandas

3/25

Additional practice for Exam 2 (by Shuhua Wu)

3/27

Exam 2

4/1

Introduction to Advanced Analytics

Classification using Decision Trees

PowerPoint: Advanced Analytics – Introduction

Classification using Decision Trees

4/3

In-class exercise: Decision trees in Python

4/8

Analysis Scenario: Identifying similar customers (clustering and segmentation) 

PowerPoint: Clustering and Segmentation

Assignment 7 Due: Decision Trees

4/10

In-class exercise: Clustering and Segmentation in Python

4/15

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

In-class exercise: Computing Confidence, Support, and Lift

PowerPoint: Association Rule Mining

Assignment 8 Due: Clustering

4/17

In-class exercise: Association Rule Mining in Python

4/22

Review for Exam 3

Assignment 9 Due: Association Rules

4/24

Exam 3