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