Class Capture
Week 1
Class on 12 Jan (Data and Information)
Class on 14 Jan (The relational paradigm)
Class on 16 Jan (Entities and Attributes)
Week 2
Class on 21 Jan (In class exercise on Entities/Attributes)
Class on 23 Jan (ERD Models)
Week 3
Class on 26 Jan (Schema Diagrams)
Class on 28 Jan (Exercise on Schema Diagram/Intro to SQL)
Class on 30 Jan (SQL – Out 1)
Week 4
Class on 2 Feb (Joins and Subselects)
Class on 4 Feb (SQL Out In class exercise)
Class on 6 Feb (Review of SQL Out In class exercise)
Week 5
Class on 9 Feb (SQL In)
Class on 11 Feb (Exam Review – SQL)
Class on 13 Feb (Exam Review – ERD Diagrams)
Week 6
Class on 18 Feb (SQL In- In class exercise)
Class on 20 Feb (ETL)
Week 7
Class on 25 Feb (Dimensional Data Modeling)
Class on 27 Feb (In class exercise – Pivot Table)
Week 9
Class on 9 March (SQL In Assignment)
Class on 11 March (Advanced Analytics Introduction)
Class on 13 March (In-class exercise -SAS introduction)
Week 10
Class on 16 March (Decision Trees)
Class on 18 March (Exam 2 Review -SQL)
Class on 20 March (Exam 2 Review – ETL & Pivot Tables)
Week 11
Class on 25 March (In class exercise – Decision Trees)
Class on 27 March (In class exercise – Decision Trees on SAS)
Week 12
Class on 30 March (Clustering and Segmentation)
Class on 3 April (In class exercise clustering/SAS clustering)
Week 13
Class on 6 April (Association Rules Mining)
Class on 8 April (In-class exercise – Association Rules Mining)
Class on 10 April (Assignment 6 and Association Rules In-class exercises)
Week 14
Class on 13 April (In-class exercise)
Class on 15 April (Choosing the right decision rule)
Class on 17 April (Data Visualization)
Week 15
Class on 20 April (In class exercise – Data Visualization)
Class on 22 April (Assignment 8 )
Class on 24 April (Analytics Techniques Review)
Week 16
Class on 27 April