#### 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 10 (Week of 10/30)

Class Schedule:

- Monday — Introduction to Advanced Analytics and R (Continued)
- Wednesday — Review for Exam 2
- Friday — Exam 2

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

- Group project: 10/31 (Tuesday)

# 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).

# Nathan’s Office Hour for Assignment 4

Date/Time: October 24 (Tuesday), 3:30 pm – 4:30 pm

Location: Alter 240A (Breakout room)

# 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.

# Schedule Change for 10/23 (Monday)

I will be out of town on 10/23 (Monday). **We will not meet in class**. Instead, please review this slide deck: 9. Supplement – Basic Statistics on your own.

For 10/25 (Wednesday), we will meet as usual.

# 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).

# Nathan’s Office Hour for Assignment 3 (Friday 3:00-4:00 pm)

Time: 3:00 pm – 4:00 pm on Friday (10/13)

Location: Alter 240B