Schedule

Day	Topics	Course Materials	Assignments
8/26	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
8/28	Understanding Database Schemas: Normalization, primary/foreign keys, joins	PowerPoint: Relational Data Modeling
9/2	In-class exercise: Creating database schema in MySQL Workbench
9/4	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
9/9	In-class exercise: Pen and Paper exercise		Assignment 1 Due: Database schema
9/11	In-class exercise: Working with SQL, part 1
9/16	Getting data out of RDMS: Joining tables In-class exercise: Working with SQL, part 2	PowerPoint: SQL 2	Assignment 2 Due: SQL #1
9/18	In-class exercise: Working with SQL, part 2
9/23	Review for Exam 1		Assignment 3 Due: SQL #2
9/25	Exam 1
9/30	Semi-structured data In-class exercise: Working with semi-structured data	PowerPoint: Semi-structured data & NoSQL
10/2	Introduction to Python In-class exercise: Getting familiar with Jupyter, Python Basic, Data types
10/7	Python Data Structures In-class exercise: Python Lists and Dictionaries
10/9	Python and JSON In-class exercise: Working with JSON in Python		Assignment 4 Due: Python Basics
10/14	In-class exercise: Working with JSON in Python (continued) Reconciling Data: The extract, transform, load process (ETL)	PowerPoint: ETL
10/16	Python Pandas In-class exercise: Working with Python Pandas		Assignment 5 Due: Python and JSON
10/21	In-class exercise: Jason & Pandas
10/23	Hypothesis Testing Principles of Data Visualization In-class exercise: Data Visualization	PowerPoint: Hypothesis Testing Data Visualization
10/28	Review for Exam 2		Assignment 6 Due: Pandas
10/30	Exam 2
11/4	Introduction to Advanced Analytics Classification using Decision Trees	PowerPoint: Advanced Analytics – Introduction Classification using Decision Trees
11/6	In-class exercise: Decision trees in Python
11/11	Analysis Scenario: Identifying similar customers (clustering and segmentation)	PowerPoint: Clustering and Segmentation	Assignment 7 Due: Decision Trees
11/13	In-class exercise: Clustering and Segmentation in Python
11/18	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
11/20	In-class exercise: Association Rule Mining in Python
	Fall & Thanksgiving break (11/24-28)
12/2	Review for Exam 3		Assignment 9 Due: Association Rules
12/4	Exam 3