Slide Decks

Week 1:Course Introduction & Information Architecture

• 0 Course Introduction
• 1 Things You Can Do With Data
• 2 Information Architecture of an Organization

Week 2:Relational Data Modeling (ERD & Cardinality)

• 3 Relational Data Modeling Part 1

Week 3:Relational Data Modeling (ERD to Schemas)

• 3 Relational Data Modeling Part 2
• 4. MySQL and Workbench

Week 4:SQL: Extracting Data from a Database  

• 5 SQL – Extracting Data from a Database

Week 5:SQL: Putting Data into a Database  

• 6 SQL – Putting Data into a Database

Week 6: Data Visualization 

• 7 Principles of Data Visualization
• 8 Extract, Transform and Loading

Week 7: Data Visualization – Continued 

• 8 Supplement – excel basics.pdf
• 8 Supplement – excel basics.xlsx

Week 8: Data Visualization – Dimensional Data Modeling 

• 9 Dimensional Data Modeling

Week 9: Spring Break 

• No classes held

Week 10: Data Analytics in R

• 10.1 Supplement – Basic Statistics
• 10.2 Advanced Analytics and R
  • Supporting file 1: 2009BaseballTeamStats.csv
  • Supporting file 2: BaseballAnalysis.txt (download, copy and paste in R-studio)

Week 11: Decision Trees

• 11 Decision Trees

Week 12: Clustering 

• 12 Clustering

Week 12: Association Rule Mining 

• 13 Association Rule Mining