June 6 Turning transaction data into analytical data: Assignment 4 Overview of the Dimensional Model Due: ETL PowerPoint: Dimensional Data The structure of the Dimensional Model: The Modeling Star Schema Working with Dimensional Data: Pivot Tables in Excel exercise: Pivot Tables in Excel June 8 Working with Dimensional Data: Pivot Tables in PowerPoint: Assignment 5 Excel Advanced Analytics Due: Pivot Tables and R in Excel Introduction to Advanced Analytics and R In-class Exercise: Descriptive Statistics Review & getting familiar with R and RStudio Week 5 June 13 Exam 2 Due** PowerPoint: Assignment 6 Analysis Scenario: Determining customer Classification using Due: Intro to R behavior based on a profile (decision trees) Decision Trees Analysis Scenario: Identifying similar customers PowerPoint: (clustering and segmentation) Clustering and Segmentation exercise: Chi-Squared Statistics In-class exercise: Decision trees in R June 15 Analysis Scenario: What products are purchased PowerPoint: Assignment 7 together? (Association Association Rule Due: Decision Mining Trees in R In class exercise: Clustering in R Week 6 June 20 Connecting to a MySQL Database using R Assignment 8 Due: Clustering in R In-class exercise: Computing Confidence, Support, and Lift In-class exercise: Association Rule Mining in R June 22 Exam 3 Assignment 9 Due: Association Rules
June 6 Turning transaction data into analytical data: Overview of the Dimensional Model The structure of the Dimensional Model: The Star Schema Working with Dimensional Data: Pivot Tables in Excel exercise: Pivot Tables in Excel PowerPoint: Dimensional Data Modeling Assignment 4 Due: ETL June 8 Working with Dimensional Data: Pivot Tables in Excel Introduction to Advanced Analytics and R In-class Exercise: Descriptive Statistics Review & getting familiar with R and RStudio PowerPoint: Advanced Analytics and R Assignment 5 Due: Pivot Tables in Excel Week 5 June 13 Exam 2 Due** Analysis Scenario: Determining customer behavior based on a profile (decision trees) Analysis Scenario: Identifying similar customers (clustering and segmentation) exercise: Chi-Squared Statistics In-class exercise: Decision trees in R PowerPoint: Classification using Decision Trees PowerPoint: Clustering and Segmentation Assignment 6 Due: Intro to R June 15 Analysis Scenario: What products are purchased together? (Association In class exercise: Clustering in R PowerPoint: Association Rule Mining Assignment 7 Due: Decision Trees in R Week 6 June 20 Connecting to a MySQL Database using R In-class exercise: Computing Confidence, Support, and Lift In-class exercise: Association Rule Mining in R Assignment 8 Due: Clustering in R June 22 Exam 3 Assignment 9 Due: Association Rules
MIS2502-Syllabus-Hansberry-S1-2017-1-1.docx