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

Course Materials

How to use the slide decks?

  • Check the schedule in the syllabus for the dates we are covering the material in each slide deck.
  • Review the slide deck prior to class.
  • Take notes during class.

Here they are:

No.  Module Slides In-Class Activities (ICA)
Additional Files
1 Course Introduction;

Things You Can Do with Data

0. Course Introduction

1. Things You Can Do With Data

 
2 Information Architecture of an Organization 2. Information Architecture of an Organization    
3 Relational Data Modeling 3. Relational Data Modeling ICA #1 – Identifying Entities (due by Fri 9/8, 11:59 pm) (ICA#1 solution key)

ICA #2 – ER Modeling (due by Wed 9/13, 11:59 pm)  (ICA#2 solution key)

ICA #3 – Converting ERDs to Schemas (due by Wed 9/20, 11:59 pm) (ICA #3 solution key)

(right click and save as…)

ICA #2 Inventory and Parts.erdplus

ICA #2 Housing Authority.erdplus

ICA #3 Schema Template.pptx

4 SQL 1: Getting Information Out of a Database Before start, make sure you’ve followed the guide for setting up a connection in MySQL Workbench 

4.1 SQL 1 – Out – Basics

4.2 SQL 1 – Out – Advanced

4. Supplement – MySQL and Workbench (review on your own)

 ICA #4 – Pen and Paper Query Exercise (due by Mon 9/25, 11:59 pm) (ICA #4 solution key)

ICA #5 – SQL Part 1 (due by Fri 9/29, 11:59 pm) (ICA #5 solution key)

 SQL Quick Reference 1
5 SQL 2: Putting Information Into a Database 5. SQL 2 – In ICA #6 – SQL Part 2 (due by Friday 10/6, 11:59 pm) (ICA #6 solution key; ICA #6 SQL statements)
 SQL Quick Reference 2
6 Principles of Data Visualization 6. Data Visualization ICA #7 – Creating Infographics (will not be collected) Files needed for ICA #7 (right click and save as):

Obesity in America.xlsx

Impact of beverage prices.png

Philadelphia Area Obesity Rates.png

7 Extract, Transform, Load (ETL) 7. ETL

7. Supplement – excel basics (review on your own)  (additional files:  7. Supplement – excel basics.xlsx;      7. Supplement – excel basics (key).xlsx)

 No ICA  
8 Dimensional Data Modeling  8. Dimensional Data Modeling ICA #8 – Pivot Tables (due by Monday 10/23, 11:59 pm) (ICA #8 solution key; Salesperson Cube – key.xlsx)

 

 File needed for ICA #8 (right click and save as): 

Salesperson Cube.xlsx

9 Advanced Data Analytics and R 9. Supplement – Basic Statistics

9. Advanced Analytics and R 

(9 R basics.r; 9 BaseballAnalysis.r; 2009BaseballTeamStats.csv)

ICA #9: Descriptive Statistics Using R/RStudio (due by Wednesday 11/8, 11:59 pm) (ICA #9 solution key; Descriptives – Try it yourself.r) File needed for ICA #9 (right click and save as): 

Descriptives.rNBA14Salaries.csv

10 Classification Using Decision Trees  10. Decision Trees ICA #10 – Decision Trees in R (due by Friday 11/17, 11:59pm)  File needed for ICA #9 (right click and save as): 

dTree.r

OrganicsPurchase.csv

11 Clustering  11. Clustering    
12 Association Rules  12. Association Rules    
13 Advanced topic