Data and Analytics

Course Introduction and Syllabus
The Things You Can Do with Data

The Information Architecture of an Organization

PowerPoint:

– Course Introduction

– Things You Can Do With Data

– Information Architecture of an Organization

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

PowerPoint:

– Relational Data Modeling

ICA #1 Database Schema

Schema Template

Submit on Canvas

Assignment 1: Database schema (due Friday 1/27, 11:59 PM)

• Assignment #1 – Database Schemas
• Schema Template
• Submit on Canvas

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:

– SQL1

1/31

PowerPoint:

– SQL1

ICA #2 – Pen and Paper Query Exercise

Submit on Canvas

Getting data out of RDMS: Joining tables

PowerPoint:

– SQL 2

Assignment 2: SQL #1 (due Friday 2/10, 11:59 PM)

• Assignment #2 – SQL Part 1
• Submit on Canvas

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

ICA #3: SQL Part 1

Submit on Canvas

Getting data out of RDMS: Subselects

PowerPoint:

– SQL 2

Assignment 3: SQL #2 (due Friday 2/17, 11:59 PM)

• Assignment #3 -SQL Part 2
• Submit on Canvas

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

ICA #4 – SQL Part 2

Submit on Canvas

PowerPoint:

– Exam 1 Study Guide

– Review for Exam 1

Exam 1

Semi-structured data

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

PowerPoint:

– Semi-Structured Data

– ICA #5 – Working with Semi-Structured Data

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

PowerPoint:

– NoSQL 1

Spring Break – No Classes Held

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

– ICA #6 – NoSQL Part 1

– Submit on Canvas

Assignment 4: NoSQL #1 (due Friday 3/17, 11:59 PM)

• Assignment #4 – NoSQL Part 1
• Submit on Canvas

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

PowerPoint:

– NoSQL 2

– ICA #7 – NoSQL Part 2

– Submit on Canvas

Assignment 5: NoSQL #2 (due Friday 3/24, 11:59 PM)

• Assignment #5 – NoSQL Part 2
• Submit on Canvas

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

Principles of Data Visualization

In-class activity 8: Data Visualization

PowerPoint:

– ETL

– Data Visualization

– ICA #8 – Data Visualization Principles

– ICA #8 – Excel file

– Submit on Canvas

Review for Exam 2

PowerPoint:

– Exam2 Study Guide

– Review for Exam2

Introduction to Advanced Analytics and R

PowerPoint:

– Advanced Analytics and Python

2009BaseballTeamStats

In-class activity 9: Getting familiar with Python and Jupyter

(The files are available on Canvas)

Classification using Decision Trees

PowerPoint:

– Classification using Decision Trees

In-class activity 10: Decision trees in Python

Assignment 6: Decision Trees (due Monday 4/17, 11:59 PM)

Analysis Scenario: Identifying similar customers (clustering and segmentation) 

In-class activity 11: Clustering and Segmentation in Python

PowerPoint:

– Clustering

(The files for ICA 11 are available on Canvas)

Assignment 7: Clustering (due Friday 4/21, 11:59 PM)

Association Rule Mining

In-class activity 11: Clustering and Segmentation in Python (continued)

PowerPoint:

– Association Rule Mining

4/25

Review for Exam 3

PowerPoint:

– Exam 3 Study Guide

– Review for Exam 3

Exam 3