Slide Decks
Week 1:Course Introduction & Information Architecture
Week 2:Relational Data Modeling (ERD & Cardinality)
Week 3:Relational Data Modeling (ERD to Schemas)
Week 4:SQL: Extracting Data from a Database
Week 5:SQL: Putting Data into a Database
Week 6: Data Visualization
Week 7: Data Visualization – Continued
Week 8: Data Visualization – 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
Week 12: Clustering
Week 12: Association Rule Mining