Data and Analytics

Department of Management Information Systems, Temple University

Data and Analytics

MIS 2502.004 ■ Fall 2023 ■ Konstantin Bauman

Schedule

 

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

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

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

Assignment 3: SQL #2
  9/28 Exam 1  
6 10/03

Introduction to Python

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

Python Data Structures

In-class exercise #06: Python Lists and Dictionaries

  
7 10/10

Semi-structured data

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

Assignment 4:  Python Basics
  10/12

Python and JSON

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

  
8 10/17

Python Pandas

In-class exercise #09: Working with Python Pandas

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

Assignment 5: Python and JSON
9 10/24

Principles of Data Visualization

In-class exercise #10: Data Visualization

Assignment 6: Pandas
  10/26

Hypothesis Testing

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

  
10 10/31 Review for Exam 2  

 
  11/02 Exam 2  
11 11/07

Introduction to Advanced Analytics and Python

Classification using Decision Trees

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

Assignment 7: Decision Trees
  11/16 In-class exercise #13: Clustering and Segmentation in Python  
13 11/21 Thanksgiving holiday – no class    
  11/23 Thanksgiving holiday – no class    
14 11/28

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

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

Assignment 8: Clustering
  11/30 In-class exercise #15: Computing Confidence, Support, and Lift  
15 12/05 Review for Exam 3

Assignment 9: Association Rules
  12/07 Final Exam

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