Data and Analytics

Department of Management Information Systems, Temple University

Data and Analytics

MIS 2502.003 ■ Fall 2025 ■ Shuhua Wu

Schedule

 

WEEK DATES TOPIC TASKS DUE MATERIALS
1 8/26 – Course Introduction and Syllabus
– The Things You Can Do with Data
– The Information Architecture of an Organization		  
  • Course Introduction
  • Things You Can Do with Data
  • Information Architecture
  8/28 Understanding Database Schemas: Normalization, primary/foreign keys, joins  
  • Relational Data Modeling
2 9/02 In-class exercise #01: Creating database schema
  • Install MySQL Workbench
  • If it crashes on a Mac machine, try an earlier version
  • Alternatively, use virtual machine: OWLab
  • ICA#1: Task
  • Submit on Canvas
  9/04 Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE  
  • PowerPoint: SQL 1
3 9/09 In-class exercise #02: Pen and Paper exercise

Assignment 1: Database schema

  • Task
  • Submit on Canvas
  • ICA #2: Task
  • Submit on Canvas
  9/11 Getting data out of RDMS: Joining tables  
  • PowerPoint: SQL 2
  • ICA #3: Task
4 9/16 In-class exercise #03: Working with SQL, part 1

Assignment 2: SQL #1

  • Task
  • Answer Sheet to fill
  • Submit on Canvas
  • ICA #3: Task
  • Submit ICA #3 on Canvas
  9/18 In-class exercise #04: Working with SQL, part 2  
  • ICA #4: Task
  • ICA #4: Submit on Canvas
5 9/23 Review for Exam 1

Assignment 3: SQL #2

  • Task
  • Submit on Canvas
  • Slides
  9/25 Exam 1  
  • Study Guide
6 9/30

Introduction to Python

In-class exercise #05: Getting familiar with Jupyter, Python Basic, Data types
  • Install Jupyter and Anaconda
  • ICA #5: Notebook
  • ICA #5: Submit on Canvas
  10/02

Python Data Structures

In-class exercise #06: Python Lists and Dictionaries

  
  • ICA #6: Notebook
  • ICA #6: Submit on Canvas
7 10/07

Semi-structured data

In-class exercise #07: Working with semi-structured data

Assignment 4:  Python Basics

  • Notebook
  • Submit on Canvas
  • Slides: Semi-structured data
  • ICA #7: Task
  • ICA #7: Submit on Canvas
  10/9

Python and JSON

In-class exercise #08: Working with JSON in Python

  
  • ICA #8: Task
  • Data: airbnb
  • ICA #8: Submit on Canvas
8 10/14

Python Pandas

In-class exercise #09: Working with Python Pandas

Assignment 5: Python and JSON

  • Notebook
  • Data
  • Submit on Canvas
  • ICA #9: Task
  • Data
  • ICA #9: Submit on Canvas
  10/16

Reconciling Data: The extract, transform, load process (ETL)

In-class exercise #10: More practice with Pandas

  

  • PowerPoint: ETL
  • ICA #10: Task
  • Data
  • ICA #10: Submit on Canvas
9 10/21

Principles of Data Visualization

In-class exercise #11: Data Visualization

Assignment 6: Pandas

  • Notebook
  • Data
  • Submit on Canvas
  • PowerPoint: Data Visualization
  • ICA #11: Task, Data
  • ICA #11: Submit on Canvas
  10/23

Hypothesis Testing

In-class exercise #12: Hypothesis Testing and Visualization in Python

  
  • PowerPoint: Hypothesis Testing
  • ICA #12: Notebook, NBA, Sales
  • ICA #12: Submit on Canvas
10 10/28 Review for Exam 2  

 
  10/30 Exam 2  
  • Study Guide
11 11/04

Introduction to Advanced Analytics and Python

Classification using Decision Trees

  
  • PowerPoint: Advanced Analytics – Introduction
  • PowerPoint: Classification using Decision Trees
  11/06 In-class exercise #13: Decision Trees in Python  
  • ICA #13: Task, Notebook, Data, Answer Sheet to fill
  • ICA #13: Submit on Canvas
12 11/11 Analysis Scenario: Identifying similar customers (clustering and segmentation)

Assignment 7: Decision Trees

  • Task
  • Data
  • Answer Sheet to fill
  • Submit on Canvas
  • PowerPoint: Clustering and Segmentation
  11/13 In-class exercise #14: Clustering and Segmentation in Python  
  • ICA #14: Task, Notebook, Data
  • ICA #14: Submit on Canvas
13 11/18

Analysis Scenario: What products are purchased together? (Association Rules)

In-class exercise #15: Computing Confidence, Support, and Lift

Assignment 8: Clustering

  • Task
  • Data
  • Answer Sheet to fill
  • Submit on Canvas
  • PowerPoint: Association Rule Mining
  • ICA #15: Task
  • Submit on Canvas
  11/20 In-class exercise #16: Computing Confidence, Support, and Lift  
  • ICA #16: Task, Notebook, Data
  • Output [in case Python did not work]
  • ICA #16: Submit on Canvas
14 11/25

Thanksgiving holiday – no class

 

  
  11/27 Thanksgiving holiday – no class  

 
15 12/02 Review for Exam 3

Assignment 9: Association Rules

  • Task
  • RulesFile
  • Submit on Canvas
  • Exam Review Slides
  • Student Feedback Forms
  12/04 Final Exam

PRO points project (optional): Due on 12/08

  • Task
  • Submit on Canvas
  • Follow the instructions in the Task document to request points
  • Study Guide