Data and Analytics

• Course Introduction
• Things You Can Do with Data
• Information Architecture

• Relational Data Modeling

• Install MySQL Workbench
• If it crashes on a Mac machine, try an earlier version
• Alternatively, use virtual machine: OWLab

• ICA#1: Task
• Submit on Canvas

• PowerPoint: SQL 1

In-class exercise #02: Pen and Paper exercise

Assignment 1: Database schema

• Task
• Answer Sheet to fill in 
• Submit on Canvas

• ICA #2: Task
• ICA #2: Submit on Canvas

• PowerPoint: SQL 2

Assignment 2: SQL #1

• Task
• Moviedb schema
• Answer Sheet to fill in
• Submit on Canvas

• ICA #3: Task
• ICA#3 moviedb schema 
• Submit ICA #3 on Canvas

• ICA #4: Task
• ICA #4: Submit on Canvas

Assignment 3: SQL #2

• Task
• Submit on Canvas

• Exam Review Slides
• Study Guide
• Practice Quiz for Proctorio Installation 

Introduction to Python

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

• Install Jupyter and Anaconda

• ICA #5: Notebook
• ICA #5: Submit on Canvas

Exam 1

Exam during first half of class

Python Data Structures

In-class exercise #06: Python Lists and Dictionaries

• ICA #6: Notebook
• ICA #6: Submit on Canvas

Python Data Structures

In-class exercise #06: Python Lists and Dictionaries

• • ICA #6: Notebook
  • ICA #6: Submit on Canvas

Spring Break

In-class exercise #07: Working with semi-structured data

Python and JSON

In-class exercise #08: Working with JSON in Python

Assignment 4:  Python Basics

• Notebook
• Submit on Canvas

• Semi-structured Data Slides

• ICA #7: Task
• ICA #7: Submit on Canvas
• ICA #8: Task
• Data: airbnb
• ICA #8: Submit on Canvas

Python Pandas

In-class exercise #09: Working with Python Pandas

In-class exercise #10: More practice with Pandas

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

ETL Lecture Recording now posted on Canvas via Zoom>Cloud Recordings

Assignment 5: Python and JSON

• Notebook
• Data
• Submit on Canvas

View recording before next class on 3/27

• ICA #9: Task
• Data
• ICA #9: Submit on Canvas

• PowerPoint: ETL
• ICA #10: Task
• Data
• ICA #10: Submit on Canvas

Principles of Data Visualization

Lecture Recording

View recording before next class on 3/27

• PowerPoint: Data Visualization

Principles of Data Visualization

In-class exercise #11: Data Visualization

Hypothesis Testing

In-class exercise #12: Hypothesis Testing and Visualization in Python

Assignment 6: Pandas

• Notebook
• Data
• Submit on Canvas

• ICA #11: Task
• Data
• ICA #11: Submit on Canvas
• PowerPoint: Hypothesis Testing
• ICA #12 Notebook, NBA, Sales
• ICA #12: Submit on Canvas

• Study Guide

Introduction to Advanced Analytics and Python

Classification using Decision Trees

In-class exercise #13: Decision Trees in Python

• PowerPoint: Advanced Analytics – Introduction
• PowerPoint: Classification using Decision Trees

• ICA#13 Task, Notebook, Data,
  Answer Sheet to fill
• ICA #13: Submit on Canvas

Assignment 7: Decision Trees

• Task
• Data
• Answer Sheet to fill
• Submit on Canvas

Analysis Scenario: Identifying similar customers (clustering and segmentation)

In-class exercise #14: Clustering and Segmentation in Python

• PowerPoint: Clustering and Segmentation
• ICA #14: Task, Notebook, Data
• ICA #14: Submit on Canvas

Assignment 8: Clustering

• Task
• Data
• Answer Sheet to fill
• Submit on Canvas

• PowerPoint: Association Rule Mining
• ICA #15: Task
• ICA #15: Submit on Canvas

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

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

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

• ICA #16: Task, Notebook, Data
• Output [in case Python did not work]
• ICA #16: Submit on Canvas

Assignment 9: Association Rules

• Task
• RulesFile
• Submit on Canvas

• Exam Review Slides
• Student Feedback Forms

Exam 3 Review

Final Exam 4/30 5:45 – 7:45

PRO points project 

• Task
• Submit on Canvas
• Follow the instructions in the Task document to request points

• Exam 3 Study Guide
• Exam 3 Review Slides