Data and Analytics

WEEK	DATES	TOPIC	MATERIALS	TASKS DUE
1	8/22	Course Introduction and Syllabus The Things You Can Do with Data	PowerPoint: – Course Introduction – Things You Can Do With Data
	8/24	The Information Architecture of an Organization	PowerPoint: – Information Architecture of an Organization
	8/26	Understanding Database Schemas: Normalization, primary/foreign keys, joins	PowerPoint: – Relational Data Modeling
2	8/29	In-class activity 1: Creating database schema	ICA #1 Database Schema Schema Template Submit on Canvas
	8/31	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
	9/2	Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE (continued)	PowerPoint: – SQL 1
3	9/5	Labor Day-No Classes Held
	9/7	Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE (continued)	PowerPoint: – SQL 1
	9/9	In-class activity 2: Pen and Paper exercise	ICA #2 – Pen and Paper Query Exercise Submit on Canvas	Assignment 1: Database schema (due Friday 9/9, 11:59 PM) Assignment 1: Database Schemas Schema Template Submit on Canvas
4	9/12	Getting data out of RDMS: Joining tables	PowerPoint: – SQL 2
	9/14	In-class activity 3: Working with SQL, part 1	ICA #3: SQL Part 1 Submit on Canvas
	9/16	Getting data out of RDMS: Subselects	PowerPoint: – SQL 2	Assignment 2: SQL #1 (due Friday 9/16, 11:59 PM) Assignment 2 Instructions Submit on Canvas
5	9/19	In-class activity 4: Working with SQL, part 2	ICA #4 – SQL Part 2 Submit on Canvas
	9/21	Semi-structured data	PowerPoint: – Semi-Structured Data
	9/23	Semi-structured data	PowerPoint: – Semi-Structured Data	Assignment 3: SQL #2 (due Friday 9/23, 11:59 PM) Assignment #3 Instructions Submit on Canvas
6	9/26	Semi-structured data	PowerPoint: – Semi-Structured Data
	9/28	Review for Exam 1	PowerPoint: – Exam 1 Study Guide – Review for Exam 1
	9/30	Exam 1
7	10/3	In-class activity 5: Working with semi-structured data	ICA #5-Semi-Structured Data
	10/5	Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP	PowerPoint: – NoSQL 1
	10/7	In-class activity 6: Working with NoSQL, part 1	ICA #6 – NoSQL Part 1 – Submit on Canvas
8	10/10	Getting data out of NoSQL: How to query nested document and array, JOIN	PowerPoint: – NoSQL 2
	10/12	Getting data out of NoSQL: How to query nested document and array, JOIN	PowerPoint: – NoSQL 2
	10/14	Wellness Day- No Classes Held
9	10/17	In-class activity 7: Working with NoSQL, part 2	– ICA #7 – NoSQL Part 2 – Submit on Canvas	Assignment 4: NoSQL #1 (due Monday 10/17, 11:59 PM) Assignment #4 – NoSQL Part 1 Submit on Canvas
	10/19	Reconciling Data: The extract, transform, load process (ETL) Principles of Data Visualization	PowerPoint: – ETL – Data Visualization
	10/21	Reconciling Data: The extract, transform, load process (ETL) Principles of Data Visualization	PowerPoint: – ETL – Data Visualization	Assignment 5: NoSQL #2 (due Friday 10/21, 11:59 PM) Assignment #5 – NoSQL Part 2 Submit on Canvas
10	10/24	Review for Exam 2	PowerPoint: – Exam2 Study Guide – Review for Exam2
	10/26	In-class activity 8: Data Visualization	– ICA #8 – Data Visualization Principles – ICA #8 – Excel – Submit on Canvas
	10/28	Exam 2
11	10/31	Introduction to Advanced Analytics and R	PowerPoint: – Advanced Analytics and Python 2009BaseballTeamStats
	11/2	In-class activity 9: Getting familiar with Python and Jupyter	(The files are available on Canvas)
	11/4	In-class activity 9: Getting familiar with Python and Jupyter	(The files are available on Canvas)
12	11/7	Classification using Decision Trees	PowerPoint: – Classification using Decision Trees
	11/9	In-class activity 10: Decision trees in Python	(The files are available on Canvas)
	11/11	In-class activity 10: Decision trees in Python	(The files are available on Canvas)
13	11/14	Analysis Scenario: Identifying similar customers (clustering and segmentation)	PowerPoint: – Clustering
	11/16	In-class activity 12: Clustering and Segmentation in Python	(The files are available on Canvas)	Assignment 6: Decision Trees (due Wednesday 11/16, 11:59 PM) (The files are available on Canvas)
	11/18	In-class activity 12: Clustering and Segmentation in Python	(The files are available on Canvas)
14	11/21	Fall Break & Thanksgiving Holiday – No Classes Held
	11/23
	11/25
15	11/28	Association Rule Mining	PowerPoint: – Association Rule Mining
	11/30	Association Rule Mining	PowerPoint: – Association Rule Mining
	12/2	Review for Exam 3	PowerPoint: – Exam 3 Study Guide – Review for Exam 3	Assignment 7: Clustering (due Friday 12/2, 11:59 PM)
16	12/5	Exam 3