# Schedule

Day | Topics | Course Material | Assignments |

1/11/16 | Course Introduction & Syllabus The Information Architecture of an Organization | Deck: The Things You can Do with Data Deck: Information Architecture | |

1/13/16 | Data Modeling; Gathering Requirements; Introducing The Entity-Relationship Diagram |
Deck: Relational Data Modeling | |

1/15/16 | In-class exercise: Identifying entities |
||

1/18/16 | MLK Holiday – No Class | ||

1/20/16 | More on ERDs – Relationships, Cardinality In-class exercise: Creating an Entity Relationship Diagram |
Deck: Relational Data Modeling | |

1/22/16 | From ERDs to Schemas: Normalization, primary/foreign keys, joins | Deck: Relational Data Modeling | |

1/25/16 | In-class exercise: Converting ERDs to schemas |
||

1/27/16 | 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. |
Deck: SQL 1 | |

1/29/16 | In-class exercise: Pen-and-paper SQL exercise |
Assignment 1 Due: ER Modeling | |

2/1/16 | Getting data out of the database: Joining tables, SQL subselects, LIMIT | Deck: SQL 1 | |

2/3/16 | In-class exercise: Working with SQL, part 1 |
||

2/5/16 | Creating and updating the database; SQL CREATE, DROP, and ALTER; SQL INSERT, UPDATE, and DELETE | Deck: SQL 2 | |

2/8/16 | Creating and updating the database; SQL CREATE, DROP, and ALTER; SQL INSERT, UPDATE, and DELETE | Deck: SQL 2 | Assignment 2 Due: SQL #1 |

2/10/16 | In-class exercise: Working with SQL, part 2 |
||

2/12/16 | Review for Exam 1 |
||

2/15/16 | Exam 1 |
||

2/17/16 | Principles of Data Visualization | Deck: Data Visualization | |

2/19/16 | Principles of Data Visualization | Deck: Data Visualization | |

2/22/16 | In-Class Exercise: Data Visualization |
||

2/24/16 | Getting data into the analytical database: The Extract, Transform, Load process | Deck: ETL | Assignment #3 Due: SQL #2 |

2/26/16 | Getting data into the analytical database: The Extract, Transform, Load process | Deck: ETL | |

2/29/16 | Spring Break – No Class | ||

3/2/16 | Spring Break – No Class | ||

3/4/16 | Spring Break – No Class | ||

3/7/16 | Turning transaction data into analytical data: Overview of the Dimensional Model; The structure of the Dimensional Model: The Star Schema | Deck: Dimensional Data Modeling | |

3/9/16 | Working with Dimensional Data: Pivot Tables in Excel | ||

3/11/16 | In class exercise: Pivot Tables in Excel |
Assignment 4 Due: ETL in Excel | |

3/14/16 | Introduction to Advanced Analytics and R Studio | Deck: Advanced Analytics & R | |

3/16/16 | In-class exercise: Descriptive Statistics Review |
||

3/18/16 | In-class exercise: Getting familiar with R and Rstudio |
Assignment 5 Due: Pivot Tables in Excel | |

3/21/16 | Review for Exam 2 | ||

3/23/16 | TBD – Guest Speaker or Review Continued | ||

3/25/16 | Exam 2 |
||

3/28/16 | Analysis Scenario: Determining customer behavior based on a profile (decision trees) | Deck: Classification using Decision Trees | |

3/30/16 | In-class exercise: Chi-Squared Statistics |
||

4/1/16 | In-class exercise: Decision trees in R |
Assignment 6 Due: Intro to R Studio | |

4/4/16 | Exam Review | Deck: Clustering and Segmentation | |

4/6/16 | Analysis Scenario: Identifying similar customers (clustering and segmentation) | ||

4/8/16 | In-class exercise: Clustering in R |
||

4/11/16 | Analysis Scenario: What products are purchased together? (Association Rules) | Deck: Association Rule Mining | Assignment 7 Due: Decision Trees in R |

4/13/16 | In-class exercise: Computing Confidence, Support & Lift |
||

4/15/16 | In-class exercise: Association Rule Mining in R |
||

4/18/16 | In-class exercise: Association Rule Mining in R (cont) |
Assignment 8 Due: Clustering | |

4/20/16 | Connecting to a MySQL Database using R | ||

4/22/16 | In-class exercise: TBD |
||

4/25/16 | Last Day of Class – Review for Final | Assignment 9 Due: Association Rules | |

4/27/16 | Study Day | ||

5/2/16 |
Final Exam – 8AM – 10AM |