Yang Yang

RAW= your mid-term raw score (full score is 100) Extra = your extra mid-term score (full score is 100). Your final mid-term score = RAW + 5 + (Extra – RAW)*(100-RAW)/150 Two rules are made to make sure it is fair to those students who didn’t take extra project: If your Extra is lower than your RAW, only […]

Click Final Exam Study Guide to download Schedule: May 10th 2011, Speakman Hall 114, 10:30 am – 11:30 am Format: (1) Conceptual Q&A, (2) Multiple choices, (3) Data Analytics Here is a practice exam (with answer key), which is similar in format: MIS2502003 Final exam practice MIS2502003 Practice Final – answer keys Please practice and grade it with answer […]

Some  Collective Intelligence Thoughts   Case Study Homework: Your team will analyze the “Decisions 2.0: The Power of Collective Intelligence” article and answer 5 questions below http://people.icoserver.com/users/eric/SMR_Collective_Decisions.pdf . Decision making can be divided into two tasks: the generation of potential solutions and the evaluation of potential solutions.  Describe how each of those tasks can be negatively influenced by numerous human biases. Can the human biases […]

Regression Lab Practice

You need to finish this lab and answer the inside questions. A hard copy deliverable is required by April 21st (Thursday).

Solution: Regression-Lab-solutions

Regression is a basic and important modeling technique for analyzing the data variance and predicting the future event.

Click here to download the slides for: Regression Instruction

For Tuesday, we will do an exercise of data clustering and profile segmentation. Exercise:  Exercise of Clustering and Segmentation Answer: Answer for Exercise of Clustering and Segmentation   For Thursday, we will learn how to find the relationships between “Beer and Napies” Instruction:  Association Rules or Market Basket Analysis Exercise:  Exercise of Association Rules Answer: Answer for Exercise of Association Rules […]

Slides:

Introduction to Pattern Discovery

Manual:

Clustering and Segmentation

SAS Enterprise Entrance:  https://support.sas.com/ctx3/sodareg/index.html?execution=e2s1 Instruction of using SAS Enterprise Miner to do data sourcing and exploration:  Accessing and Assaying Prepared Data Please note that this manual was for SAS Enterprise Miner 6.1, but we are using 6.2. There are two big differences: (1) we don’t have to create local folder in 6.2. So you can skip the […]

On Tuesday we will learn some basic theory of data mining, and learn how to create an account to use SAS data mining services.

Click here for introduction slides. Click Here to learn how to create SAS miner Account

Advanced textbook for using SAS miner:

http://proquest.safaribooksonline.com.libproxy.temple.edu/book/databases/sas/9781590478295

Here is a textbook which was used for teaching by MIS textbook. Although it was for ORACLE database, the content is the same for ERD and SQL parts. Check it out here:  DBMS textbook

You need submit everything before Apr. 3 midnight 11:59 pm by Email, including your ERD, scenario description. Besides, you also need to create the database, tables and several records to your SQL workspace. Project Description It is an optional project for extra 10 points. 1. Create a detailed scenario from any of following topics: (1) Amazon product review system […]

Welcome back from spring break and I hope you have had a great time. For this week, we will start a new journey of business data analytics: OLAP and Data mining entry. For Tuesday, we will cover basic concepts of OLAP and do some practice in class. Related slides are here: Week-8-1 OLAP-Intro Week-8-2-PivotTable Data for case1:  retail_sales_feb1 Data […]

Mid-term Exam Answer Keys

Click HERE to download the slides for mid-term review.

Click Week-6-1-ERD-SQL-Exercise for slides.

SQL tutorial site: http://www.w3schools.com/sql/

Practice interface: http://class1.mis.temple.edu/dbclass.php

Intro to Join and Alias: Week-5-2-SQL-ALIAS-JOIN

Lab Practice:

SQL2.1 Update Insert Delete

SQL2.3 Alias Join

Introduction to basic SQL

SELECT, INSERT, UPDATE, and DELETE
For the class presentation material and exercise questions, click HERE
Lab practice 1: MIS2502_Lab-Exercise-1-Deliverable-Intro-to-SQL.docx,
Lab practice 2: MIS2502_Lab-Exercise-2-Deliverable-Intro-to-SQL_Continued.docx

Design a database which can be used to record all the transaction details of a retail firm such as Gap. Consider following players: Seller, Customer, Product. (Ignore suppliers here) Show your database design with ERD. Before draw it with Access 2007, please work together with your group members and draw it manually within 10 minutes. […]

Introduction to Database

Relational Database Model

Intro to Access 2007

Access 2007 Tutorial (Textbook)

Good database design is important because even a good DBMS will perform poorly with a poorly designed database. The hierarchical model is based on a tree structure that is composed of a root segment, parent segments, and child segments. The hierarchical model depicts a set of one-to-many (l:M) relationships between a parent and its children. […]