Data and Analytics

Department of Management Information Systems, Temple University

Data and Analytics

MIS 2502.004 ■ Fall 2024 ■ Konstantin Bauman

Schedule

 

WEEK DATES TOPIC TASKS DUE MATERIALS
1 8/27 – Course Introduction and Syllabus
– The Things You Can Do with Data
– The Information Architecture of an Organization		  
  8/29 Understanding Database Schemas: Normalization, primary/foreign keys, joins  
2 9/03 In-class exercise #01: Creating database schema
  9/05 Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE  
3 9/10 In-class exercise #02: Pen and Paper exercise

Assignment 1: Database schema
  9/12 Getting data out of RDMS: Joining tables  
4 9/17 In-class exercise #03: Working with SQL, part 1

Assignment 2: SQL #1
  9/19 In-class exercise #04: Working with SQL, part 2  
5 9/24 Review for Exam 1

Assignment 3: SQL #2
  9/26 Exam 1  
6 10/01

Introduction to Python

In-class exercise #05: Getting familiar with Jupyter, Python Basic, Data types
  10/03

Python Data Structures

In-class exercise #06: Python Lists and Dictionaries

  
7 10/08

Semi-structured data

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

Assignment 4:  Python Basics
  10/10

Python and JSON

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

  
8 10/15

Python Pandas

In-class exercise #09: Working with Python Pandas

Assignment 5: Python and JSON
  10/17

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

In-class exercise #10: More practice with Pandas

  

9 10/22

Principles of Data Visualization

In-class exercise #11: Data Visualization

Assignment 6: Pandas
  10/24

Hypothesis Testing

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

  
10 10/29 Review for Exam 2  

 
  10/31 Exam 2  
11 11/05

Introduction to Advanced Analytics and Python

Classification using Decision Trees

  
  11/07 In-class exercise #13: Decision Trees in Python  
12 11/12 Analysis Scenario: Identifying similar customers (clustering and segmentation)

Assignment 7: Decision Trees
  11/14 In-class exercise #14: Clustering and Segmentation in Python  
13 11/19

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

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

Assignment 8: Clustering
  11/21 In-class exercise #16: Computing Confidence, Support, and Lift  
14 11/26

Thanksgiving holiday – no class

 

  
  11/28 Thanksgiving holiday – no class  

 
15 12/03 Review for Exam 3

Assignment 9: Association Rules
  12/05 Final Exam

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