Instructor: Jing Gong. Class Time: M/W/F 2:00-2:50 pm

Announcements

Agenda for Week 12 (Week of 11/13)

Class Schedule:

  • Monday — ICA #10 (Decision Trees in R)
  • Wednesday — ICA #10 (Decision Trees in R) continued
  • Friday — Slide Deck: Clustering

Deadlines (unless otherwise mentioned, the due time is 11:59 pm):

  • Assignment #5 (Introduction to working with R and RStudio): 11/13 (Monday).
  • ICA #10 (Decision Trees in R): 11/17 (Friday).
  • Assignment #6 (Decision Trees): 11/27 (Monday).

Want extra practice with R?

If you’re looking for an additional tutorial on R syntax, try this CodeSchool site: http://tryr.codeschool.com/.

It is not required that you do this, but some of you might find it helpful. Remember, most the information you need for the course is in the in-class exercises, slides, notes, and assignments. But sometimes people want something extra, and this is a pretty good interactive walk-through.

The most relevant chapters are 1, 2, 4, and 7. However, it looks like you have to do them in order (you have to complete chapters 1 and 2 to get to chapter 3, etc.). So my suggestion would be to at least go through Chapter 1. If you find it useful, keep going!

Agenda for Week 11 (Week of 11/6)

Class Schedule:

  • Monday — ICA #8 (Descriptive Statistics Using R and RStudio)
  • Wednesday — ICA #8 (Descriptive Statistics Using R and RStudio) continued
  • Friday — Classification using Decision Trees

Deadlines (unless otherwise mentioned, the due time is 11:59 pm):

  • ICA #8 (Descriptive Statistics Using R and RStudio): 11/8 (Wednesday).
  • Assignment #5 (Introduction to working with R and RStudio): 11/13 (Monday).

Agenda for Week 9 (Week of 10/23)

Class Schedule:

  • Monday — No class. Please review this slide deck: 9. Supplement – Basic Statistics on your own.
  • Wednesday — Dimensional Data Modeling: Star Schema
  • Friday — Introduction to Advanced Analytics and R

Deadlines (unless otherwise mentioned, the due time is 11:59 pm):

  • ICA #7 (Pivot Tables in Excel): 10/23 (Monday).
  • Assignment #4 (ETL and Pivot Tables in Excel): 10/25 (Wednesday).
  • Group project: 10/31 (Tuesday).

Excel Videos from Fox Video Vault

In case you’d like some resources to learn Excel and as help for Assignment #4, here are some links for video tutorials on text manipulation (e.g., CONCATENATION),  VLOOKUP, and Pivot Tables. You will need to log in to watch the videos.

Text manipulation: https://www.fox.temple.edu/vault/video/Text-Manipulation/

VLOOKUP: https://www.fox.temple.edu/vault/video/lookup-tables/

Pivot Tables: https://www.fox.temple.edu/vault/video/pivot-tables/

Thanks to Grace Laggan who recommended these videos to me.

Agenda for Week 8 (Week of 10/16)

Class Schedule:

  • Monday — Extract, Transform, Load (ETL) and some Excel basics
    • Please review the supplementary materials: Excel Basics, on your own
  • Wednesday — Dimensional Data Modeling: Overview
  • Friday — ICA #7 (Pivot Tables in Excel)

Deadlines (unless otherwise mentioned, the due time is 11:59 pm):

  • Group project
    • Submit names and AccessNet accounts of your group members by 10/20 (Friday) at noon.
    • Submit your visualization and description (both in PDF) by 10/31 (Tuesday).
  • ICA #7 (Pivot Tables in Excel) is due by 10/23 (Monday).
  • Assignment #4 (ETL and Pivot Tables in Excel) will be announced and due by  10/25 (Monday).