Day  Topics  Course Materials  Assignments 
1/14 
Course Introduction and Syllabus The Things You Can Do with Data. 
PowerPoint: Course Introduction 

1/16  The Information Architecture of an Organization.  PowerPoint: Information Architecture  
1/18  Data Modeling Introducing EntityRelationship Diagram 
PowerPoint: Relational Data Modeling1  
1/21  Martin Luther King, Jr. Day – No Class  
1/23  Inclass exercise: Identifying entities  
1/25  More on ERDs: Relationships, cardinality 
PowerPoint: Relational Data Modeling1  
1/28  Inclass exercise: Creating an entity relationship diagram  
1/30  From ERDs to Schemas: Normalization, primary/foreign keys, joins  PowerPoint: Relational Data Modeling2  
2/1  Inclass exercise: Converting ERDs to schemas  Assignment 1 Due: ER Modeling  
2/4 
Getting data out of the database: 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: SQL 1 – Basic  
2/6  Inclass exercise: Working with SQL, part 1  
2/8  Getting data out of the database: Joining tables, SQL subselects, LIMIT  PowerPoint: SQL 1Advance  
2/11  Inclass exercise: Working with SQL, part 2  
2/13  No class  Assignment 2 Due: SQL #1 (2/14)  
2/15  Review for Exam 1  
2/18  Exam 1  
2/22  Creating and updating the database SQL CREATE, DROP, and ALTER SQL INSERT, UPDATE, and DELETE  PowerPoint: SQL 2  
2/25  Inclass exercise: Working with SQL, part 2  
2/27  Principles of Data Visualization  PowerPoint: Data Visualization  
3/1 
Inclass exercise: Data Visualization


3/48  Spring Break – No Class  
3/11  Reconciling Data: The extract, transform, load process (ETL)  PowerPoint: ETL  Assignment 3 Due: SQL #2 
3/13  Inclass exercise: ETL using Tableau Prep  
3/15  Inclass exercise: ETL using Tableau Prep  
3/18  Semistructured data  PowerPoint: Semistructured data  
3/20 
Inclass exercise: Working with semistructured 

3/22 
Introduction to Advanced Analytics and R dataDescriptive Statistics Review 
PowerPoint: Advanced Analytics – Introduction PowerPoint:Supplement – Basic Statistics 
Assignment 4 Due: ETL using Tableau Prep 
3/25 
Inclass exercise: R basics 

3/27  Inclass exercise: Getting familiar with R and RStudio  
3/29  Review for Exam 2  
4/1  Exam 2  
4/3  Inclass exercise: Getting familiar with R and RStudio  
4/5  Classification using Decision Trees  PowerPoint: Classification using Decision Trees  
4/8  Inclass exercise: Decision trees in R  Assignment 5 Due: Introduction to working with R  
4/10  Inclass exercise: Decision trees in R  
4/12  Analysis Scenario: Identifying similar customers (clustering and segmentation)  PowerPoint: Clustering and Segmentation  
4/15  Inclass exercise: Clustering and Segmentation in R  Assignment 6 Due: Decision Trees in R  
4/17  Inclass exercise: Clustering and Segmentation in R  
4/19  Analysis Scenario: What products are purchased together? (Association Rules)  PowerPoint: Association Rule Mining  
4/22  Inclass exercise: Computing Confidence, Support, and Lift  Assignment 7 Due: Clustering  
4/24 
Inclass exercise: Association Rule Mining in R Advanced topic – Data Visualization in R 

4/26  Review for Exam 3 
Assignment 8 Due: Association Rules Bonus Assignment Due (4/28) 