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 WHEREMake 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 |